Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <root>
- <lineage>
- <item>
- <name>[Sales (query)].[Retailers].[Retailer Province-State]</name>
- <ns>[goretailers]</ns>
- <qs>[RETAILER_SITE]</qs>
- <qi>[Retailer Province-State]</qi>
- </item>
- <item>
- <name>[Sales (query)].[Products].[Product line]</name>
- <exp>#'[gosales].[PRODUCT_LINE].[PRODUCT_LINE_'+ $Language_lookup{$runLocale}+ '] '#</exp>
- </item>
- <item>
- <name>[Sales (query)].[Time].[Month (numeric)]</name>
- <ns>[gosales]</ns>
- <qs>[TIME_DIMENSION]</qs>
- <qi>[Month (numeric)]</qi>
- </item>
- <item>
- <name>[Sales (query)].[Sales].[Revenue]</name>
- <ns>[gosales]</ns>
- <qs>[Sales]</qs>
- <qi>[Revenue]</qi>
- </item>
- <item>
- <name>[Sales (query)].[Sales].[Planned revenue]</name>
- <ns>[gosales]</ns>
- <qs>[Sales]</qs>
- <qi>[Planned revenue]</qi>
- </item>
- <item>
- <name>[Sales (query)].[Time].[Year]</name>
- <ns>[gosales]</ns>
- <qs>[TIME_DIMENSION]</qs>
- <qi>[Year]</qi>
- </item>
- <item>
- <name>[Sales (query)].[Branch].[City]</name>
- <ns>[gosales]</ns>
- <qs>[BRANCH]</qs>
- <qi>[City]</qi>
- </item>
- <item>
- <name>[Sales (query)].[Sales].[Gross profit]</name>
- <ns>[gosales]</ns>
- <qs>[Sales]</qs>
- <qi>[Gross profit]</qi>
- </item>
- <item>
- <name>[Sales (query)].[Sales].[Quantity]</name>
- <ns>[gosales]</ns>
- <qs>[ORDER_DETAILS]</qs>
- <qi>[Quantity]</qi>
- </item>
- <item>
- <name>[Sales (query)].[Retailers].[Region]</name>
- <exp>#'[gosales].[SALES_REGION].[SALES_REGION_'+ $Language_lookup{$runLocale}+ '] '#</exp>
- </item>
- </lineage>
- <!--There is more XML code in between -->
- <queries>
- <query name="RevenuMapquery">
- <!--More Code in between that is unimportant-->
- <selection>
- <dataItem name="Region">
- <expression>[AllRegion].[Region]</expression>
- </dataItem>
- <dataItem name="Revenue">
- <expression>[MeasureRevenue].[Revenue]</expression>
- </dataItem>
- <dataItem name="Planned revenue">
- <expression>[MeasureRevenue].[Planned revenue]</expression>
- </dataItem>
- </selection>
- </query>
- <query name="AllRegion">
- <source>
- <model />
- </source>
- <selection>
- <dataItem name="Region">
- <expression>[Sales (query)].[Retailers].[Retailer Province-State]</expression>
- </dataItem>
- </selection>
- <detailFilters>
- <detailFilter>
- <filterExpression>[Sales (query)].[Retailers].[Retailer country] = ('United States') </filterExpression>
- </detailFilter>
- </detailFilters>
- </query>
- <query name="MeasureRevenue">
- <source>
- <model />
- </source>
- <selection>
- <dataItem aggregate="none" name="Region" rollupAggregate="none">
- <expression>[Sales (query)].[Retailers].[Retailer Province-State]</expression>
- <XMLAttributes>
- <XMLAttribute name="RS_dataType" output="no" value="3" />
- <XMLAttribute name="RS_dataUsage" output="no" value="attribute" />
- </XMLAttributes>
- </dataItem>
- <dataItem aggregate="summarize" name="Product line" rollupAggregate="none">
- <expression>[Sales (query)].[Products].[Product line]</expression>
- <XMLAttributes>
- <XMLAttribute name="RS_dataType" output="no" value="3" />
- <XMLAttribute name="RS_dataUsage" output="no" value="attribute" />
- </XMLAttributes>
- </dataItem>
- <dataItem aggregate="none" name="Month (numeric)" rollupAggregate="none">
- <expression>[Sales (query)].[Time].[Month (numeric)]</expression>
- <XMLAttributes>
- <XMLAttribute name="RS_dataType" output="no" value="1" />
- <XMLAttribute name="RS_dataUsage" output="no" value="attribute" />
- </XMLAttributes>
- </dataItem>
- <dataItem aggregate="total" name="Revenue">
- <expression>[Sales (query)].[Sales].[Revenue]</expression>
- <XMLAttributes>
- <XMLAttribute name="RS_dataType" output="no" value="2" />
- <XMLAttribute name="RS_dataUsage" output="no" value="fact" />
- </XMLAttributes>
- </dataItem>
- <dataItem aggregate="total" name="Planned revenue">
- <expression>[Sales (query)].[Sales].[Planned revenue]</expression>
- <XMLAttributes>
- <XMLAttribute name="RS_dataType" output="no" value="2" />
- <XMLAttribute name="RS_dataUsage" output="no" value="fact" />
- </XMLAttributes>
- </dataItem>
- <dataItem aggregate="none" name="Year" rollupAggregate="none">
- <expression>[Sales (query)].[Time].[Year]</expression>
- <XMLAttributes>
- <XMLAttribute name="RS_dataType" output="no" value="1" />
- <XMLAttribute name="RS_dataUsage" output="no" value="attribute" />
- </XMLAttributes>
- </dataItem>
- <dataItem name="Planned revenue1" aggregate="total">
- <expression>[Sales (query)].[Sales].[Planned revenue]</expression>
- <XMLAttributes>
- <XMLAttribute name="RS_dataType" value="2" output="no" />
- <XMLAttribute name="RS_dataUsage" value="fact" output="no" />
- </XMLAttributes>
- </dataItem>
- <dataItem name="City" aggregate="none" rollupAggregate="none">
- <expression>[Sales (query)].[Branch].[City]</expression>
- <XMLAttributes>
- <XMLAttribute name="RS_dataType" value="3" output="no" />
- <XMLAttribute name="RS_dataUsage" value="attribute" output="no" />
- </XMLAttributes>
- </dataItem>
- </selection>
- </query>
- </root>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement