Skip to Content
0
Former Member
Jan 11, 2007 at 05:06 PM

Use Key Figure as Characteristic

56 Views

I have a sales cube that has Item Qty and Ext Sales Amount as key figures. I can easily derive Item Cost as a Calculated Key Figure by dividing Ext Sales Amount by Item Qty.

I would like to use Item Cost as a Characteristic (for grouping) in my queries. Is there any way for me to accomplish this during query execution (at runtime) or am I forced to explicitly calculate the Item Cost when loading the cube and add it as a characteristic in my cube?