Skip to Content
Former Member
Jun 09, 2008 at 12:16 PM

Count the occurences into an infocube


Hi experts

I am uploading sales ticket per days, customer, customer type and site into my CRM infocube.

I would like to count the number of distincts customer per any combination of characteristics (days, site and customer type) and the number of sales tickets for any combination of caractéristics (customers, customer type, sites,...)

I tried to follow the guide "How to ... count the occurence of a charactistic" : I created a key figure "count" with a constant value "1", I used into my query the "average function"... But I didn't get the right result (to be honnest, my query get no result at all !!!!!)

Is there some body that could help me?

Thanks a lot.