January 23, 2015 at 5:22 am
Hi
We have a sales cube which works well except for when delivering reports we have identified a weakness. Our sales are over 2000 customers and 16000 products, so when pivoting say in Excel you end up with blank cells where there is no sales for a customer or a product in a certain month. However if you filter the cube to say show one product or one customer where there is no sales within a certain month these blank months disappear . . . because there is no sales.
However this behavior does not lend itself to looking at say sales trends where you want to see the blank (0 sales) months, is there a way to make this happen ?
Paul
January 23, 2015 at 7:01 am
I think this is the non-empty behaviour of SSAS.
By default it should not show empty cells.
The following thread explains how you can change this behaviour in Excel:
http://www.sqlservercentral.com/Forums/Topic1085963-17-1.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 23, 2015 at 7:30 am
Brilliant, that is really good . . . Next question, how do you make Report Builder / SSRS behave in the same manner ?
January 23, 2015 at 7:40 am
paul.farnell (1/23/2015)
Brilliant, that is really good . . . Next question, how do you make Report Builder / SSRS behave in the same manner ?
There should be a similar setting somewhere.
You can specify it in the MDX, that's certain. (by default the MDX designer add NON EMPTY to the query)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply