Bex restrictions stop data to display

[Former Member]

Hi SCN,

Before posting, I gone thru existing discussions and didn't get the required info to solve my problem.

My issue is:

I have one bex report which display all shopping carts based on approvers.

Here Approver as Char variable with mandate option.

Cal day as selection as optional.

When we enter multiple approvers, we are not getting the data due to selections only.

Because at target  level I have data for for whole month for  two approvers.

for rest of the approvers we don't have data for last weeks(june 15 to 30).

Due to that, am getting no data for display message at report level.

is there way to show the report with all the existing data as per the approvers and caldays

Thanks in advance.

RaGhav.

[Former Member · Accepted solution]

Hi Team,

Thanks for your replies.

After checking at system level, its came know that as the input parameters which are entering users in Approver field have duplicate entries.

Duplicated entries doesn't holds any transactions in SAP/BW and hence we are getting no data for display.

Thank you.

RaGhav.

[former_member200967]

Hi ,

Have you tried checking the data with the same restictions on the undelying Multiproivder/Cube? If you can see the data in MPRO/CUbe, you need to check the query for any restriction, filters that you might have used.

If it is not visible in MPRO/Cube too, you need check for restrictions at that level.

Basically a query will give you data irrespective of wether all the approvers have data in the period or not, because they are being OR'ed in the select statement. So even if only 1 approver has the data in the cal day period you are using , you will see only that approver in the report.

Regards

Manpreet

[KodandaPani_KV]

HI,

can you check any restriction on approvers

check below like any global or local filter is there?

or

same query you can run in RSRT tocde - check the information tab -> you will see all the details where is was restriction Is happening the  objects and queries

or

debug the BEx query if you are using the customer exit variables, before the put the break-point in the CMOD particular variable.

Thanks,

Phani.