cancel
Showing results for 
Search instead for 
Did you mean: 

How to get the count on characteristics infoobject

Former Member
0 Kudos
189

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

Accepted Solutions (1)

Accepted Solutions (1)

anshu_lilhori
Active Contributor
0 Kudos

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
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

Thanks Anoop.It works now with your suggestion

Answers (1)

Answers (1)

former_member182470
Active Contributor
0 Kudos

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