Use Key Figure as Characteristic

[Former Member]

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?

[former_member188975 · Accepted solution]

Hi Jonathan,

You really can't use a Kf as a char, but if you can calculate it in your query, then you can create exceptions for different values / levels and this way group using color...would this work for you?

[Former Member]

One option would be to use a virtual char, code an MDX (or cube read FM) to get the KF value for this virtual char in the user-exit. I think it would be worse (in terms of performance) than the option of adding a char and reloading the cube.

Just to list the options, you can make the item cost a mater data attribute of the item-no/docu-no, and use it as navigational attribute.