Unable to see data in the report or workbook

[Former Member]

Hello All,

We are struggling to display data in the report level or workbook, however the data is available in Multiprovider.

Error Message: "No Applicable Data Found"

Steps Carried Out:

1. Dropped the BIA Indexes for relevant cubes and Reactivated the Multiprovider, still did not work.

2. When we checked for previous years like 2013, we are able to see data in the report.  To elaborate an issue, we loaded budget data for year 2015 as requested by user.  Restricted the same filters from the Query in the Multiprovider and able to see the data in the backend, however not data can be seen in the Report.

3. Three Hierarchies are restricted in the Filters of the Query.

It would be great, if any of you can help us to fix the issue.

Best Regards,

Sudhakar

[former_member182997]

Hi
To add to what the experts have suggested, Please debug and check if something wrong in MULTIPROVIDER HINT table, why i am saying this is because in my last project we faced this issue and all examinations were carried out but couldn't solve this problem.
After that SAP suggested the fix as we opened the connection for them.
We had to implement notes suggested by SAP.

Thanks!

[former_member183012]

Hi Sudhakar,

As you said you are able to see data at backend means multiprovider level,I would suggest please check query once again check all the filters in query and apply same filter at multiprovider once again.

check any filter is applied at query level for which your data target does not have data.

Regards,

Ganesh Bothe

[RamanKorrapati]

Hi,

Have you used any exists?

in exists is there any system date kind?

Can you try to run your report thru RSRT and use debug option there.

before reporting please check your all connected targets have data for reporting.

mean at targets-->request tab, reporting symbol was there or not.

Any master data objects included in multi provider?

if yes then please check those, if any ACR was running then it may cause you.

if possible try to develop simple query with as per needs(mean to see 2015 data only).

As my guess selections/filters migth be hidden, please check those.

Thanks