-
MDX Time Issue
Hi, I have a fairly simple cube (in SSAS2005) containing measures for revenue and margin, dimensions for brands, Sku, time, etc. I need to calculate current Year YTD revenue as a factor of the total revenue from all periods in the previous year. E.g.
Revenue Nov 2008 YTD = £1,500,000
Revenue Nov 2007 Prior YTD = £1,250,000
Revenue All periods Prior Year (Nov 2007 > Oct 2008) = £18,500,000
Result = 8.1%
Is this possible without having to "hard code" years into the MDX?
Thanks in advance. . .
-
Take a Look at My "Time" Articles ...
Hi:
Lots of info surrounding what you need, with multiple working examples, in these articles:
http://www.databasejournal.com/featu...-Functions.htm
MDX Time Series Functions, Part II: The OpeningPeriod () and ClosingPeriod() Functions
MDX Time Series Functions, Part III: The LastPeriods() and ParallelPeriod() Functions
Also, many other articles in my monthly MDX Essentials column deal with MDX time functions.
HTH. Let me know if I can answer further questions.
Bill
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|