Skip to content

Instantly share code, notes, and snippets.

@rpbouman
Last active December 11, 2015 23:38
Show Gist options
  • Select an option

  • Save rpbouman/4677682 to your computer and use it in GitHub Desktop.

Select an option

Save rpbouman/4677682 to your computer and use it in GitHub Desktop.
<mql>
<domain_type>olap</domain_type>
<domain_id>SteelWheels</domain_id>
<model_id>SteelWheelsSales</model_id>
<selections>
<selection>
<!-- mql view = olap hierarchy -->
<view>product</view>
<!-- mql column = olap level -->
<column>product</column>
</selection>
<selection>
<view>measures</view>
<column>Quantity</column>
<!-- mql aggregation = implicit for measure member -->
<aggregation>SUM</aggregation>
</selection>
</selections>
</mql>
@rpbouman
Copy link
Author

Equivalent MDX:

SELECT {[Measures].[Quantity]} ON Axis(0)
, [Product].[Product].Members ON Axis(1)
FROM [SteelWheelsSales]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment