August 20, 2014 at 12:11 pm
Hello guys I am working with SSAS on sql server 2012 I have a dimension that has the hierarchy of the company this is OLAP cube.
But at some point I am leave the directors without a boss (because they aren't really need at this level) and have a NA value here.
Is there anyway to filter this at design level?.
Thanks in advance.
August 25, 2014 at 9:17 am
I found my behavior that is causing this to be a calculated member
I have create the following tendency
(IIF([Measures].[Age]=TRUE,1,0)+
IIF([Measures].[Idle]=TRUE,1,0)+
IIF([Measures].[Labor]=TRUE,1,0))/3
My issue is that in excel if I use this (or the kpi) the heritages aren't take in account and each heiritable show all possible results instead of
ignore those that is suppose to be filter by.
Example
It should show
America USA 1 1 0 OK Colombia 1 0 1 OK Brazil 0 0 0 Bad Asia Japan 1 1 1 OK
But instead it shows
America USA 1 1 0 OK Colombia 1 0 1 OK Brazil 0 0 0 Bad Japan OK Asia USA OK Colombia OK Brazil Bad Japan 1 1 1 OK
Can anyone point me what I am doing wrong?
September 1, 2014 at 7:44 am
I appreciate everyone who check this, I am aware I put this on the wrong subforum now, anyways I found this behavior its a bug of how excel display the data.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply