Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 29, 2014 at 12:16 PM

    Hi Leszek,

    We have SE,DE as kf's which are placed under rows.

    Under SE:

    SE - Purchase Req (ZSEOOPR),Purchase Order(ZSEOOPO),Production Order(ZSEOOPRQ) Etc..

    DE-Safety Stock(ZDESS),Sales Order(ZDESRSO),Deliveries(ZDESRD) Etc..

    In column it has structure which displays the month of Jan-Dec.

    The output of the report  snapshot attached

    Now my client requirement is

    S8e

    Demand Elements

    No

    Text

    N/A

    N/A

    N/A

    N/A

    Yes

    Optional

    List Values

    Default to All

    S8e

    Supply Elements

    No

    Text

    N/A

    N/A

    N/A

    N/A

    Yes

    Optional

    List Values

    Default to All

    Regards,

    Krishna.


    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      After creating a characteristic all mentioned actions will be available.

      You can display/filter/sort/aggregate records with the help of any characteristic.

      If you use a characteristic as an attribute. It's enough to use it as display attribute if you want display data only. I you want to displayfilter/aggregate data a navigational attribute should be used.

      Regards, Leszek,

  • Dec 29, 2014 at 11:25 AM

    Hi,

    Variable on a key figure ?

    What do you expect it to do ?

    May be using a condition or an exception is a better idea ?

    Regards, Leszek

    Add comment
    10|10000 characters needed characters exceeded