Question:
Is there any way to make COUNT DISTINCT in BW reports?
For example, if we have following records in the cube:
Customer A Invoice 1 Invoice type Y
Customer A Invoice 2 Invoice type Y
Customer A Invoice 3 Invoice type X
Customer B Invoice 4 Invoice type X
Customer C Invoice 5 Invoice type Y
And we need to report a number of customers by invoice type:
Invoice type X # of customers = 2
Invoice type Y # of customers = 2 (though it is 3 records in the cube for this invoice type)
We can include Counter key figure and fill it with '1' on update or transfer rules, but in this case we will be able to count actual records, not customers.
I would appreciate any thoughts on this.
Thanks
Answer:
There's a document called "How to count the occurrences of a characteristic relative to one or more other characteristics" (aka "How to count char instances...").
_________________
Leandro,
Tuly Idiots Shadow Supporter
Answer:
subj