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