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.