Skip to Content
avatar image
Former Member

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

SHIFTPB 0CALWEEK BARCDPB TARGETID 0ROWCOUNT1 TGTVALUE 1 062015 409013919734 PBOX_T 1 100 062015 409018975025 PBOX_T 1 100 062015 409021260309 PBOX_T 1 100 082015 409012623861 PBOX_T 1 300 082015 409902672658 PBOX_T 1 300 2 092015 409018975025 PBOX_T 1 400 3 092015 409009907424 PBOX_T 1 400

Please suggest.

Regards,

Pankaj

Capture.PNG (29.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 16, 2015 at 12:43 PM

    Hi Pankaj.

    With MPro as Option and makingĀ  Constant selection and Drill down may not work...

    If you use an infoset...this requirement would suffice..

    rgds

    SVU

    Add comment
    10|10000 characters needed characters exceeded