Hi All

i want to know how to find the employee count for the HR Cube which is
distinct count.
How to do this?
Plz tell me this.

thanking u,

From
Hash

is AS2005 you can use the distinct count aggregation and create a "physical"
measure
Is AS2000 the dcount aggregation measure can result in errors if the user
apply multiple filters in the cube (like selecteing 2 stores);
in this case you have to create a dynamic distinct count (a calculated
measure)

the calculated measure option is also available in AS2005, but if you need
performance and if the re is lot of access to this measure, don't use it and
play with a real aggregated measure.

search in google and this newsgroup to find some formula
(search "calculated distinct count" or "basket analysis")

"Hash" <harshal.patil (AT) sify (DOT) com> wrote