cancel
Showing results for 
Search instead for 
Did you mean: 

No. of Records

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member184494
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Arun,

Thank u for qick reply, could u plz explain in detail about how to use before aggregation in exception aggregation.

Thanks & Regards

Ramakrishna Kamurthy

Former Member
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

Issue Solved