Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Filter a member and hierarchy level Expand / Collapse
Author
Message
Posted Wednesday, August 20, 2014 12:11 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 4:57 PM
Points: 21, Visits: 201
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.
Post #1605561
Posted Monday, August 25, 2014 9:17 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 4:57 PM
Points: 21, Visits: 201
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?
Post #1607111
Posted Monday, September 1, 2014 7:44 AM This worked for the OP Answer marked as solution
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 4:57 PM
Points: 21, Visits: 201
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.
Post #1609353
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse