March 14, 2014 at 9:59 am
Hi.
I have an issue whereby including my calculated measure in a pivot returns more rows that I've filtered by.
So within my Account dimension I have a few attributes, one being a 'Parent Acct Id' and another the 'Child Acct Id'. I have setup the hierarchy accordingly and then created my measure, this being.
[Measures].[Linked Accounts] AS COUNT([Account].[My Hierarchy].CURRENTMEMBER.SIBLINGS)
Then if I use my 'Child Acct Id' on rows the linked accounts measure would correctly show the number of siblings. However the problem arises when I want to reduce the result set by another dimension attribute (e.g. a country name from a 'Country' dimension) - doing this has no affect on the rows returned.
I should mention that if I filter on another attribute within the 'Account' dimension then that does filter as required.
So I don't understand why the CURRENTMEMBER function doesn't work across other dimensions I'm filtering-on.
Any ideas?
Thanks
Dave
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy