I am working on a cube and I am trying to determine how to create a
calculated measure that counts the number of fact rows that exist for a
level of a dimension.

The dimension structure is:

Disposition
* Non-Opportunity
* Opportunity
* * Competitor
* * Disqualified
* * Qualified

I am trying to put the measure in the cube instead of representing it
as an MDX statement in a report due to our use of a third-party tool
for displaying and drilling through the cube.

Any help would be greatly appreciated.

Jason Strate

Hi, Jason

Would you please to present your MDX expression to
describe your needs.
Is a (distinct)count aggregation measure about of your needs?

Thanks,
Vladimir Chtepa

<jason.strate (AT) performark (DOT) com> wrote

Counting the number of fact rows...if that's what you truly want
couldn't be much easier. Simply add a new measure to your cube that is
based on one of the key fields of your fact table...then change the
aggregation type of that measure from the default of sum to count.
This count will now be accurate across all the the ways you slice and
dice your cube.

If you want a count of your disposition dimension, irrespective of what
ever slices are executed against any other dimension...then you need to
create a calculated member on this new count measure that intersects
the new count measure with the default member of every other dimension
in the cube other than Displosition. Something like this...

(Time.DefaultMember, Geography.DefaultMember, Customer.DefaultMember,
Disposition.CurrentMember, Measures.Count)