MDX Utility Belt of Calculations Part 1

Who is online?  0 guests and 0 members
Home  »  Blogs  »  DevinKnight  »  MDX Utility Belt of Calculations Part 1
 
0
/5
Avg: 0/5: (0 votes)

Comments (5)

Egan
Egan said:
I actually just posted a question in the MDX forum regarding pulling data for a previous period. I believe the examples you've provided just very well may help get me in the right direction. Thanks for the info!!
12/1/2009
 · 
 
by
DevinKnight
DevinKnight said:
Glad it was helpful Egan I'll post a link to this blog post on your forum thread.
12/1/2009
 · 
 
by
MarkGStacey
MarkGStacey said:
What I do with many of my common MDX calculations, especially YearToDate, YearToDate(PreviousYear) (I call it YTD-1, YTD-2) MTD etc etc. is created a reporting shell dimension where I store all these common calcs. Nice thing is A) users can drag the calculation (or current date for no calc) onto the report surface and B) I can reuse most of these calcs from project to project
12/10/2009
 · 
 
by
DevinKnight
DevinKnight said:
Very cool Mark! I had never thought to do that.
12/10/2009
 · 
 
by
ZafarAlam
ZafarAlam said:
The way I handled this is what Mark suggested. I included the time based intervals as "Named Calculations" in DimTime table. e.g. WTD, WTD-1, WTD-2 or QTD-1 etc. The beauty of this approach is that you get an attribute within your date dimension which can then be used anywhere in the cube against any Measure Group.
12/14/2009
 · 
 
by
Blogs RSS Feed

DevinKnight's latest blog posts

Blogs RSS Feed

Latest community blog posts