MDX newbie: How do I filter/except based on an intermediate level which is not unique -


i have dimension itemsales hierarchy of levels site->itemtype->item

itemtype not unique. sites can sell same itemtype. want exclude type totals (such unknown)

this must easy i'm stuck. seems except work far can work out, except requires me enumerate every site

except([itemsales].[sites].[itemtype].members],{[itemsales].[site1].[unknown],[itemsales].[site2].[unknown]})

this doesn't if want aggregate @ sites level.

the examples see filter focus on numerical filters measures. can filter on name of member or whatever call key value gets column?

sorry asking such easy question i'm not getting less confused more read.

not sure best way address problem, can filter() function using .name of members keep [itemtype] not 'unknown' :

filter(    [itemsales].[sites].[itemtype].members,    [itemsales].[sites].currentmember.name <> 'unknown'  ) 

Comments

Popular posts from this blog

php - Calling a template part from a post -

Firefox SVG shape not printing when it has stroke -

How to mention the localhost in android -