Interview Preparation mode beta
Funny Facebook Status Funny Facebook Status
Enter your email address

MDX query to show year level data for all years except the last one, and month level data for the last year, in SSAS

Nice?Vote!

1 Answer

Nice?Vote!
SELECT {NULL:ClosingPeriod([Date].[Calendar].[Calendar Year], [Date].[Calendar].DefaultMember).PrevMember, DESCENDANTS(ClosingPeriod([Date].[Calendar].[Calendar Year], [Date].[Calendar].DefaultMember), [Date].[Calendar].[Month]) } ON 0
FROM [Sales Summary];
answered 1 year ago by R (19,530 points)

Related questions