Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DistinctCount - Counting Error

Status
Not open for further replies.

levodestro

Programmer
Mar 20, 2008
9
BR
Good morning,

I hava a cube with a distinct count measure.

When all partitions have data the measure is shown correctly.

However, if I insert a new dimension without data the measure shows wrong data (it duplicates, actually).

What could be the problem ?

Thanks,

Benedito.
 
what is the relationship on the diemsnion usage tab? If no relationship is set for a measuregroup dimension intersect then the data is repeated for all members of the dimension.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top