cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

former_member183463
Participant
0 Kudos

Hi Krishna,

Supply Elements(SE) like purchase order,production order,planned order etc and Demand Elements(DE) like Deliveries,Sales order etc..

those are not Key figures, these are char fields... may be they are placed in Rows, and char fields are maintained in columns..

Query once execute in excel & check it.

Br,

Kamal

Former Member
0 Kudos

Hi Kamal,

These are the Keyfigures with Data type QUAN with unit:0BASE_UOM.

Under :

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.

former_member202718
Active Contributor
0 Kudos

Hi Krishna,

Can you swap the Rows and Columns and check if it satisfies your requiremnt,

Also can share the Requirement in Detail..so that we can help you out.

regards

SVU123

Answers (0)