Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Key Figure Aggregate in Bex Query based on Charactersitic

Hi Gurus

I am using BI7.0; but 3.5x BEx tools

I am loading 6 fields from a flat file. I am loading data for tickets. I have create an InfoObject that counts the number of tickets. No problem. Also I also have key figures that I am assigning the same value to all Charactersitics: 10,30 per ticket.

The Key figures are (Sum) with a Summation aggregation type.

In my Query, the 10,30 aggregate up based on the number of tickets (characteristic) that are available.

Question: How do I remove/stop my key figures from aggregating up (sums) the values of 10, 30 based on the charactersitic? I want only 10, 30 to be present regardless of the number of tickets (constant value applied to the key figure).

Should I change my aggregation type? If so, to what? I see a number of options, such as Last Number, No aggregation, etc or can I override this in my Query property?

Thank you

Former Member
Not what you were looking for? View more on this topic or Ask a question