Count of no of line items in the report

[Former Member]

Hi All,

I have the following reporting requirement.Can anybody please provide me the solution.

Data in the cube

User id Accounting Doc No Lineitem Amount

abc1 10001 001 100

abc1 10001 002 100

abc1 10001 003 100

abc2 10002 001 1000

abc2 10002 002 1100

abc1 10003 001 100

Requirement:

The report output shuold look like this

User id No of Accounting Docs Total no of Lineitem count Amount

abc1 2 4 400

abc2 1 2 2100

I got the count of No of accounting documents.For lineietms I am unable to Get the count.

The system is version BI7.0

Thanks for your time.

Srinivas

[Former Member · Accepted solution]

Hi Srinivas,

Just create a Key figure as ZCOUNT (Number)

Add this KF into your cube and transformtion and add a constant = 1.

then reload data.

Then you can use this key figure in your report and will find the desired Number output.

Regards,

Sandeep

Edited by: Sandeep Khatri(San!) on Jan 9, 2008 5:01 PM

[former_member189638]

Hi Srenevas,

Check out the following document. This might help you.

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

regards,

Rakesh

[Former Member]

An easier approach could be to add a formula = 1 as a counter and use exception aggregation = total for the reference characteristic accounting doc. This should give the desired output and can easily be added in the BEx Query Designer.

Hope it helps.

BR

Stefan