Pastebin launched a little side project called VERYVIRAL.com, check it out ;-) Want more features on Pastebin? Sign Up, it's FREE!
Guest

Untitled

By: a guest on Aug 2nd, 2012  |  syntax: XML  |  size: 5.16 KB  |  views: 58  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. <root>
  2.   <lineage>
  3.     <item>
  4.       <name>[Sales (query)].[Retailers].[Retailer Province-State]</name>
  5.       <ns>[goretailers]</ns>
  6.       <qs>[RETAILER_SITE]</qs>
  7.       <qi>[Retailer Province-State]</qi>
  8.     </item>
  9.     <item>
  10.       <name>[Sales (query)].[Products].[Product line]</name>
  11.       <exp>#'[gosales].[PRODUCT_LINE].[PRODUCT_LINE_'+ $Language_lookup{$runLocale}+ '] '#</exp>
  12.     </item>
  13.     <item>
  14.       <name>[Sales (query)].[Time].[Month (numeric)]</name>
  15.       <ns>[gosales]</ns>
  16.       <qs>[TIME_DIMENSION]</qs>
  17.       <qi>[Month (numeric)]</qi>
  18.     </item>
  19.     <item>
  20.       <name>[Sales (query)].[Sales].[Revenue]</name>
  21.       <ns>[gosales]</ns>
  22.       <qs>[Sales]</qs>
  23.       <qi>[Revenue]</qi>
  24.     </item>
  25.     <item>
  26.       <name>[Sales (query)].[Sales].[Planned revenue]</name>
  27.       <ns>[gosales]</ns>
  28.       <qs>[Sales]</qs>
  29.       <qi>[Planned revenue]</qi>
  30.     </item>
  31.     <item>
  32.       <name>[Sales (query)].[Time].[Year]</name>
  33.       <ns>[gosales]</ns>
  34.       <qs>[TIME_DIMENSION]</qs>
  35.       <qi>[Year]</qi>
  36.     </item>
  37.     <item>
  38.       <name>[Sales (query)].[Branch].[City]</name>
  39.       <ns>[gosales]</ns>
  40.       <qs>[BRANCH]</qs>
  41.       <qi>[City]</qi>
  42.     </item>
  43.     <item>
  44.       <name>[Sales (query)].[Sales].[Gross profit]</name>
  45.       <ns>[gosales]</ns>
  46.       <qs>[Sales]</qs>
  47.       <qi>[Gross profit]</qi>
  48.     </item>
  49.     <item>
  50.       <name>[Sales (query)].[Sales].[Quantity]</name>
  51.       <ns>[gosales]</ns>
  52.       <qs>[ORDER_DETAILS]</qs>
  53.       <qi>[Quantity]</qi>
  54.     </item>
  55.     <item>
  56.       <name>[Sales (query)].[Retailers].[Region]</name>
  57.       <exp>#'[gosales].[SALES_REGION].[SALES_REGION_'+ $Language_lookup{$runLocale}+ '] '#</exp>
  58.     </item>
  59.   </lineage>
  60.  
  61.  <!--There is more XML code in between -->
  62.  
  63. <queries>
  64.         <query name="RevenuMapquery">
  65.         <!--More Code in between that is unimportant-->
  66.         <selection>
  67.                 <dataItem name="Region">
  68.                         <expression>[AllRegion].[Region]</expression>
  69.                 </dataItem>
  70.                 <dataItem name="Revenue">
  71.                         <expression>[MeasureRevenue].[Revenue]</expression>
  72.                 </dataItem>
  73.                 <dataItem name="Planned revenue">
  74.                         <expression>[MeasureRevenue].[Planned revenue]</expression>
  75.                 </dataItem>
  76.         </selection>
  77.         </query>
  78.         <query name="AllRegion">
  79.         <source>
  80.         <model />
  81.         </source>
  82.         <selection>
  83.                 <dataItem name="Region">
  84.                         <expression>[Sales (query)].[Retailers].[Retailer Province-State]</expression>
  85.                 </dataItem>
  86.         </selection>
  87.                 <detailFilters>
  88.                 <detailFilter>
  89.         <filterExpression>[Sales (query)].[Retailers].[Retailer country] = ('United States')    </filterExpression>
  90.                 </detailFilter>
  91.                 </detailFilters>
  92.         </query>
  93.         <query name="MeasureRevenue">
  94.         <source>
  95.         <model />
  96.         </source>
  97.         <selection>
  98.         <dataItem aggregate="none" name="Region" rollupAggregate="none">
  99.                 <expression>[Sales (query)].[Retailers].[Retailer Province-State]</expression>
  100.                 <XMLAttributes>
  101.                         <XMLAttribute name="RS_dataType" output="no" value="3" />
  102.                         <XMLAttribute name="RS_dataUsage" output="no" value="attribute" />
  103.                 </XMLAttributes>
  104.         </dataItem>
  105.         <dataItem aggregate="summarize" name="Product line" rollupAggregate="none">
  106.                 <expression>[Sales (query)].[Products].[Product line]</expression>
  107.                 <XMLAttributes>
  108.                         <XMLAttribute name="RS_dataType" output="no" value="3" />
  109.                         <XMLAttribute name="RS_dataUsage" output="no" value="attribute" />
  110.                 </XMLAttributes>
  111.         </dataItem>
  112.         <dataItem aggregate="none" name="Month (numeric)" rollupAggregate="none">
  113.                 <expression>[Sales (query)].[Time].[Month (numeric)]</expression>
  114.                 <XMLAttributes>
  115.                         <XMLAttribute name="RS_dataType" output="no" value="1" />
  116.                         <XMLAttribute name="RS_dataUsage" output="no" value="attribute" />
  117.                 </XMLAttributes>
  118.         </dataItem>
  119.         <dataItem aggregate="total" name="Revenue">
  120.                 <expression>[Sales (query)].[Sales].[Revenue]</expression>
  121.                 <XMLAttributes>
  122.                         <XMLAttribute name="RS_dataType" output="no" value="2" />
  123.                         <XMLAttribute name="RS_dataUsage" output="no" value="fact" />
  124.                 </XMLAttributes>
  125.         </dataItem>
  126.         <dataItem aggregate="total" name="Planned revenue">
  127.                 <expression>[Sales (query)].[Sales].[Planned revenue]</expression>
  128.                 <XMLAttributes>
  129.                         <XMLAttribute name="RS_dataType" output="no" value="2" />
  130.                         <XMLAttribute name="RS_dataUsage" output="no" value="fact" />
  131.                 </XMLAttributes>
  132.         </dataItem>
  133.         <dataItem aggregate="none" name="Year" rollupAggregate="none">
  134.                 <expression>[Sales (query)].[Time].[Year]</expression>
  135.                 <XMLAttributes>
  136.                         <XMLAttribute name="RS_dataType" output="no" value="1" />
  137.                         <XMLAttribute name="RS_dataUsage" output="no" value="attribute" />
  138.                 </XMLAttributes>
  139.         </dataItem>
  140.         <dataItem name="Planned revenue1" aggregate="total">
  141.                 <expression>[Sales (query)].[Sales].[Planned revenue]</expression>
  142.                 <XMLAttributes>
  143.                         <XMLAttribute name="RS_dataType" value="2" output="no" />
  144.                         <XMLAttribute name="RS_dataUsage" value="fact" output="no" />
  145.                 </XMLAttributes>
  146.         </dataItem>
  147.         <dataItem name="City" aggregate="none" rollupAggregate="none">
  148.                 <expression>[Sales (query)].[Branch].[City]</expression>
  149.                 <XMLAttributes>
  150.                         <XMLAttribute name="RS_dataType" value="3" output="no" />
  151.                         <XMLAttribute name="RS_dataUsage" value="attribute" output="no" />
  152.                 </XMLAttributes>
  153.         </dataItem>
  154.         </selection>
  155. </query>
  156. </root>