Skip to Content
0
Former Member
Mar 11, 2009 at 01:49 PM

How to COUNT DISTINCT (Character1, Character2) in cube ?

18 Views

Hi all,

for reporting I need to create keyfigure, that calculate count of visits. In our system there are no info-object for entity VISIT. Visit is a combination of DATE and PLACE. Theese objects are in cube and I need to calculate "COUNT DISTINCT (DATE, PLACE)".

I know how to create "COUNT DISTINCT (DATE)" and "COUNT DISTINCT (PLACE)" separately, but how to create both "COUNT DISTINCT (DATE, PLACE)"?

Best regards,

Andrey.