In Query, data is not populated , but data is in Cube and Master data

[Former Member]

Dear All ,

Data is available in master data and all the data is in Active version also and checked the SID also generated properly.

And same data is available in Cube as well, but data is not displaying in Report.

There might be some in-consistency, can you please let me know what are all the options I need to check to resolve this issue.

In RSRT : Execute + Debug mode what all the options I need to select and check it.

Regards,

Nithi

[Former Member]

Answered

[Former Member]

Dear All , 
> 
> Data is available in master data and all the data is in Active version also and checked the SID also generated properly.
> 
> And same data is available in Cube as well, but data is not displaying in Report.
> 
> There might be some in-consistency, can you please let me know what are all the options I need to check to resolve this issue.
> 
> In RSRT : Execute + Debug mode what all the options I need to select and check it.
> 
> Regards,
> 
> Nithi

1. Was there any ACR collisions? Had you checked SE37 > RSDMODSTATEGET > Execute twice. If you find 0 entries, I guess all okay. If not try clearing it using SE37 > RSDMODSTATECLOSE > Give IOBject name. Goto RSATTR & execute the ACRs manually & try check the report o/ps.

2. Is there a problem with Authorization. Can you run the report in RSRT & goto SU53 to check the status logs.

3. Check if the data has been rolled up? Possibly the aggregates have still not been filled up?

[Former Member]

Hi,

The master data that you are trying to view is direct update from DSO or it is a navigational attribute? If it is a navigational attribute, then please check in multi provider level whether it is correctly assigned it.

Also, cross check in the query designer level whether any filters are restricting these values (global or local (KF, Metirics, etc))

Regards,

Chandra.

[Former Member]

Check the following things

1. global filters in the report.

2. local filters in the KPI's.

3. If you are using Multiprovider, check the data there also. ( there might be problem with the assignments).

4. see the information tab in the report output to know what are the filters applied for the report and use same filters in the cube.

Regards,

Siva