Customer Count in Various revenue bucket

[Former Member]

Hi

We have Billing Cube. in which one of the characteristic is a customer and we have key figure called billed amount.

Their is requirement to show report in following manner.

Billing done Result

0 to $10000 12

$10000 to $40000 5

$40000 and %100000 12

29

Bucket stands for the sum of billing done to various customer in the given period

Thanks for the help in advance

[Former Member]

Hi,

If you are able to modifiy your InfoCube then introduce a New KF called "Customer Count", the properties of the KF should be set to "Exception Aggregat. = Counter" and Agg. reference char = Customer Char.

Now you can create CKF based on revenue buckets.

This is helpful espically in cases if the customer gets billed more than once but you want him to be counted only once in a particular period.

Hope that this helps.

Thanks

Srini

[Former Member]

Hi

This would work fine, i want to know based on t he billing amount. if i want to know based on the total billing done in a given period.

for example MR a i have done a billing of 100, 4000 , 9000 in a given period

i would like to show him in the 10000 to 40000 category and he has to be counted only once. he should not be counted more than once.

[former_member188325]

Hi,

If i have understoodd u r requirement correctly,try this:

Create a 3Fomulas say

Formula1 = (billing amt >= 0) AND (Billing amt <= 10000)

Formula2 = (billing amt > 10000) AND (Billing amt <= 40000)

Formula3 = (billing amt > 40000) AND (Billing amt <= 100000)

and 3 more formulas

Count1 = COUNT ( 'Formula1' )

Count1 = COUNT ( 'Formula2' )

Count1 = COUNT ( 'Formula3' )

'COUNT' function is available under 'Data Functions'.

>=,<,....etc are under Boolean operators.

Set 'Calculate result as' summation for all COUNT1, COUNT2,and COUNT3.

So you in Overall Result row,you will see no of customers billing done between 0 to $10000 (from formula1).....etc...

You can Hide Formula1,formula2,and Formula3. And Change Descriptions of Count1,Count2,and Count3 as required.

Hope this helps.

[former_member188325]

In addition to that,

create one more formula say 'count4' to calculate total customers:

Count4 = (billing amt <= 0 ) OR ( billing amt>= 0 )

and set Calculate result as...Summation..

In Overall result row,You can see total no of customers...and You can always cross check with individual no of customers..i.e. Count1count2count3 = count4.

Here I assume All biling amounts falls in the range 0 to 100000.

Then only Count1count2count3 = count4.

Thanks

[former_member184494]

Srikanth,

Ways to do this would be :

1. Define your restrictions and declare the count in the formula editor to find out the count of values.

2. have a separate KF with values of 1,2 3,for each of the buckets and have a CKF which counts on the new KF but that would be a more tedious process.

Arun

[Former Member]

Hi,

Until you have this type of data ( Arun's Solution # 2) available in cube , you can not generate this type of reports. OR you have to depend up on Virtual Key figures.

SAP has to think about it , to provide a simple solution (with out VKF) .

With rgds,

Anil Kumar Sharma .P