Skip to Content
0
Jul 07, 2016 at 05:02 PM

Limitation of Constant Selection in Business Explorer (SAP BEx) Query Designer

181 Views

I am created query on multi provider, This multi provider is made of combinations of Financial Planning: Real Time Info Cube (/CPD/PFP_R01) , Project Cost Status of ECP data (Virtual Info provider - /CPD/AVR_V21) and Project Cost Status of WBS Element (Virtual Info provider - /CPD/AVR_V08). See the attachment 1

Input selection is on Financial Plan ID (/CPD/FPOID) and Master Project Id (/CPD/AMPID). Rows is Structure Element (/CPD/FPID) and Columns KF's are Cost(Plan) (/CPD/FPCA), Cost(Actual) (/CPD/ACT) and Planned revenue (/CPD/PLRVN). (Financial Plan ID (/CPD/FPOID) is from /CPD/PFP_R01 and /CPD/AVR_V08 , Master Project Id (/CPD/AMPID) and Planned revenue (/CPD/PLRVN) is from /CPD/AVR_V21 and Cost(Actual) (/CPD/ACT) is from /CPD/AVR_V08.)


Cost(Plan) and Cost(Actual) are displayed in the query output but I am getting the planned revenue. (If i created separated queries I am getting the data for both cost and planned KF's)


I am using constant selection in BEx Query designer but it is not working properly. Is there any limitation of constant selection in BEx.

Attachments

1.PNG (13.4 kB)