BPC Office Client : No data retrieval when using static dimensions

[Former Member]

Hello,

We have used static dimensions to build reports / input schedules, but the data range remains empty when refreshing the workbook after the column - and row key ranges have been filled. There is definitely data in the application for the combination of the current view members and range members chosen. I have put 3 dimensions in the row key range and 4 dimensions in the column key range.

What are the common solutions for this problem ? I don't receive any errors while refreshing the workbook.

[Former Member]

Please also make sure that all your member ID have been defined in uppercase. Have lower or mixed case member ID can sometimes lead to these kind of problems

[Jeffrey_Holdema]

Have you checked security member access profiles to know that the user has access to that slice of data?

You might also double-check your data in BW by running the Shared Query Engine test program UJQ_SQE_TEST from transaction SA38 or SE38. Just select your AppSet and Application, along with matching in the filters the static members you've set in your report.

If you still have issue, try to replicate the issue with a delivered template report and confirm no data is shown.

Otherwise, please create a customer [message|http://service.sap.com/message] in the SAP Service Marketplace and report your issue as a potential bug. To expedite a solution it would be helpful if you detail the steps exactly for the Support team to recreate, verify and troubleshoot the problem.

Best regards,

[Jeffrey Holdeman|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/profile/jeffrey+holdeman]

SAP BusinessObjects

Enterprise Performance Management

Regional Implementation Group