Traditional web-based reporting with SAS BI tools

distinct measure restricted on 2 dimension

Reply
Regular Contributor
Posts: 163

distinct measure restricted on 2 dimension

Hi,
I have a distinct count measure that I created when building the cube with the NUNIQUE DISTINCT . However, once the cube is surfaced , I would like to have this distinct measure where :
it only includes two members from a dimension ( SET A)
and SET A further restricts on two members from a nother dimension. I am having a hard time creating a calculated member with the distinct measure.
Any MDX clues?

jp
Ask a Question
Discussion stats
  • 0 replies
  • 168 views
  • 0 likes
  • 1 in conversation