Advertisement
Guest User

Untitled

a guest
Aug 2nd, 2012
294
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 5.16 KB | None | 0 0
  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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement