on 10-15-2008 1:25 PM
Hi Experts,
I am working on BEx 3.5, and my requirement is how to calculate "No. of Record". InfoCube contains 0customer, 0material, profit, quantity, sales and 0calday. Now i want to display a report, no. of records on a particular day. for example,
0calday No. of Records
14/10/2008 2000
15/10/2008 3400
Some one help me in this regard....
Thanks & Regards
Ramakrishna Kamurthy
Ideally it would help if you have a counter in the cube - else you would need to have a key figure with "Before Aggregation"
Arun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arun,
i created one calculated KF "No. of Records", in that i meainted as "=quantity" and in the enhance tab i matintained as "count all values" and reference Char. as cumstomer. But in output it is displaying the count as after aggregation, but ineed befpre aggregation. But i am unable to find this option to change it to before aggregation.
Plz help me in this regard/....
Thanks & Regards
Ramakrishna Kamurthy
Issue Solved
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.