Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Functionality for aggregate rollups? #48

Open
stevenorsini opened this issue Apr 24, 2024 · 0 comments
Open

Functionality for aggregate rollups? #48

stevenorsini opened this issue Apr 24, 2024 · 0 comments

Comments

@stevenorsini
Copy link

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!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant