Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Bex Query on Mpro

Hi Guys,

Facing a strange issue in a query over a Multiprovider, seeking advive to hadle, below is the Mpro data looks lik

Now as eveident from the InfoProvider the upper 4 records are from a diferent DSO & last 7 rows are from separate DSO.

Now Now I want a report SHIFTPB & CALWEEK wise & rest other characteristics as free chars . Now in the out put we should have key figures as 0ROWCOUNT1 & TGTVALUE.

Now the issue is I have created the report with putting TGTVALUE (with constant selection of SHIFTPB since SHIFTPB is coming as from different infoprovider .(also I have added in constant sleection other characteristics too which are not coming from the same InfoProvider as the TGTVALUE.

But When I drag in TARGETID, it shows # value also the values of TGTVALUE goes off, Ideally the output should be like

SHIFTPB0CALWEEKBARCDPBTARGETID0ROWCOUNT1TGTVALUE
1062015409013919734PBOX_T1100
062015409018975025PBOX_T1100
062015409021260309PBOX_T1100
082015409012623861PBOX_T1300
082015409902672658PBOX_T1300
2092015409018975025PBOX_T1400
3092015409009907424PBOX_T1400

Please suggest.

Regards,

Pankaj

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question