How to get the count on characteristics infoobject

[Former Member]

Hi experts,

we have a requirement to create a report between two characteristics info objects.For example

In Cube,we have data for

Info object1     Info object2

C01                M01

C01                M02

In report,I want number of materials purchased by customer C01    

Thatmeans,I want C01 = 2

I created a report with Infoobject1 in row and created a formula in column and used a formula varibale with replacement path for inforobject2 with reference as infoobject1,but after executing it shows X mark.

Can you please help me to how to create the report.

regards

Pradeep

[anshu_lilhori · Accepted solution]

Hi,

The reason you are getting X is when you use formula variable with replacement path then it is mandatory to keep the object in rows which you are replacing otherwise it shows X.

Coming to your requirement to get the count--Create a CKF and put constant 1 inside it--Hit the aggregation tab--Exception aggregation as --Count of all value that are not equal to zero--Reference characteristic as --Infoobject 2.

Hope that helps.

Regards,

AL

[Former Member · Accepted solution]

Hi Anshu,

Thanks for the reply.It works when I give one in the  CKF.But, overall result is not showing the total .

Lets sat in Cube I have,

C01                M01

C01                M02

C02                M03

C02                M04

Report shows

C01               2

C02               2   

Overall result  2

But I want overall result as four

C01               2

C02               2   

Overall result  4

regards

Pradeep

[Former Member · Accepted solution]

Hi Pradeep

Please create a formula variable on Infoobject 2 refering doc:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/009819ab-c96e-2910-bbb2-c85f7bdec...

Then on the CKF add this variable and Exception aggregation should be Summation based on

Infoobject 1

Regards

Anoop

[anshu_lilhori · Accepted solution]

Hi,

Make a new formula and place your CKF inside it--Hit the aggregation tab--exception aggregation as --Summation --Reference characteristic as--Infoobject 1.

This will work and i guess by mistake you have marked the answer as assumed answered.

Please mark the replies accordingly.

Regards,

AL

[Former Member · Accepted solution]

Thanks Anoop.It works now with your suggestion

[former_member182470]

Create a CKF for Material Count: Use Exception Aggregation -->Counter of all detailed values which are not null-->Ref char as Material

Keep Customer in Rows Pane