Can we create variables(prompts) on Key figures in Bex(SAP-BW/BI).

[Former Member]

Hi,

Can we create variables on key figures, If yes,Please let me know the process step by step.

My requirement is we have key figures Supply Elements(SE) like purchase order,production order,planned order etc and Demand Elements(DE) like Deliveries,Sales order etc. All these Key figures are dragged and available in Rows.

Now my clients wants variables on SE and DE.

For SE  & DE = Variable type is OPTIONAL and Variable input value =LIST VALUES.

Can any one help me on this.

Your Effort will be Valued.

Regards,

Krishna.

[sander_vanwilligen · Accepted solution]

Hi Krishna,

You cannot create variables for Key Figures. It's possible to create the following variables:

• Characteristic Value Variables;
• Hierarchy Variables;
• Hierarchy Node Variables;
• Text Variables;
• Formula Variables.

Please refer also to SAP Help.

Best regards,

Sander

[Former Member · Accepted solution]

Hi Krishna,

It is not possible to create variable on top of key figure. you can create two characteristics SE & DE as data type NUMC instead of key figures and create variables on top of this.

if you have any calculations using SE& DE you can manage it using formula variables.

Thanks