-
Notifications
You must be signed in to change notification settings - Fork 11
Open
Description
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!
Metadata
Metadata
Assignees
Labels
No labels