<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>