You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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. Maybe I am just new to the library and do not see where the solution is, but I was hoping a contributor would have an idea of how to go about this.
Thanks in advance!
The text was updated successfully, but these errors were encountered:
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. Maybe I am just new to the library and do not see where the solution is, but I was hoping a contributor would have an idea of how to go about this.
Thanks in advance!
The text was updated successfully, but these errors were encountered: