|
|
Browse by Tags
-
Date ordering causing problem when using lastchild.lag() function in MDX and SSAS 2008
I'm writing a query in MDX that shows the last 36 months on columns. I'm trying to use the lastchild.lag(0-35) for my members in order to get those data. What I'm now realizing is, that the members in the OLAP are not ordered timely, that is, instead of january 2003,february 2003, march 2003... -
using non_empty_behavior in MDX
I have a really big query(the code I'm posting is a simple version of my original code) and I really need to have the non_empty_behavior included. The problem is that when I do, I loose a lot of data, as this function seemes to show only the values if the measure [Number Of Packages Sold] for current... -
How can I make my OLAP exectute faster?
I'm having big difficulties with an existing OLAP where the end user uses Excel to pivot the data. The OLAP has 6 dimensions where 5 of the dimension have from 34 to 2266 rows and the last dimension, has around 275.000 rows. The fact table has about 165.000 rows and around 2.500 rows are added each... -
Trouble using Calculated Measures in Time Utility Dimension
Some quick background is that we would like to have both base measures and calculations show values like previous year, quarter, month, previous year change, previous year pct change, based off the current values without having to create many calculated members using parallel period, Periods to Date...
Page 1 of 1 (4 items)