I have made a cube the following calculated member (with as parent member Measures):
COUNT(NONEMPTY( {[Parsed Logs Visitors].[Parsed Logs Visitors Dimension Table].[Parsed Logs Visitors Dimension Table]} *
{[Measures].[Parsed Logs Count]}))
Here I try to make a unique visitor count using the primary key in a non empty crossjoin with the fact table. When I query it with other dimension attributes it works fine, but it gives the total amount of unique visitors when I use (other) attributes of the same dimension.
How can I avoid that?
Thanks in advance,
Eyso Zanstra
You could try applying "existing" to the primary key attribute set:
COUNT(NONEMPTY( {Existing [Parsed Logs Visitors].[Parsed Logs Visitors Dimension Table].[Parsed Logs Visitors Dimension Table]} *
{[Measures].[Parsed Logs Count]}))
Thank you!

No comments:
Post a Comment