Count the occurences into an infocube

[Former Member]

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.

Regards

Anne

[Former Member]

Hi Anne FOURRE,

Follow the below steps..

For "I would like to count the number of distincts customer per any combination of characteristics (days, site and customer type)"

1. Create an attribute "Count" in the characteristic "Customer" and assign value 1 for each customer.

2. In Query Designer, Add the characteristic "Customer" in rows, Create a formulia in Columns -> create formulia variable with replacement path and select the characteristic "Customer", Select "Replace variable with" = "Attribute Value", attribute = "Count". Add this new variable in the formulia.

3. Select any combination of characteristics in rows and Execute the query.'

For "the number of sales tickets for any combination of caractéristics (customers, customer type, sites,...)"

You can use the count for calculating number of sales tickets.

I hope you understood and able to solve your issue.

Regards,

S P.