Skip to Content
0
Former Member
Jul 05, 2012 at 12:54 PM

Measures should not be aggregated

21 Views

Hi,

We are creating a webi report on the top of BEx query in BI 4.0.
The measure values are aggreagated in the report level when we run a query. But we need a row for each transaction.

The report needs this kind of data as there is a formula defined at report level, which gives a different value when applied on each transaction from the value applied on the aggregated data.

A new dimension object is created at report level for the measure, but as it is aggregated at report, this doesnt help.

Could you please let us know how to get each transaction with out aggregation.

Thanks in advance.

Priya