mdxpy icon indicating copy to clipboard operation
mdxpy copied to clipboard

Functionality for aggregate rollups?

Open stevenorsini opened this issue 1 year ago • 0 comments

I have an MDX Query that I am trying to mirror,

WITH SET [Virtual Measure:Virtual Measure:}rollup_1] AS {[Virtual Measure].[Virtual Measure].[Value]} MEMBER [Virtual Measure].[Virtual Measure].[}rollup_1] AS AGGREGATE({[Virtual Measure:Virtual Measure:}rollup_1]}) SELECT {[Virtual Dimension].[Version].Members} ON COLUMNS , {[Virtual Dimension].[Measure].Members} ON ROWS FROM [Sales Virtual] WHERE ( [Virtual Measure].[Virtual Measure].[}rollup_1] )

The only issue with this is I do not know of an aggregate function within MDXPy, nor do I see the capability to mirror the "SET ..." functionality on the second line of the MDX.

Thanks in advance!

stevenorsini avatar Apr 24 '24 19:04 stevenorsini