Key Figure Aggregate in Bex Query based on Charactersitic

[Former Member]

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]

I answered this question on my own

[former_member433815]

Hi Client

I would like to know how to avoid aggregation of a key figure in Bex 3.5?

Thanks

GS