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

I need an MDX statement to get the first month of the last year loaded into a cube, in SSAS

Nice?Vote!

1 Answer

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

Related questions