SAP Knowledge Base Article - Preview

3506736 - EPM report doesn't show data after installing new SQL Server - BPC MS

Symptom

We recently built new SQL server and after that, some EPM reports don't show any data without errors.

The following error occurs when running the MDX query directly in the SQL Server
The level '[AAA]' object was not found in the cube when the string, [ACCOUNT].[H1].[AAA], was parsed.

See KBA 1950966 - How to capture a SQL or MDX trace using SQL Server Profiler

2024-08-14_13-56-59.png

2024-08-14_13-57-33.png


Read more...

Environment

  • SAP Business Planning and Consolidation 10.0 version for the Microsoft platform
  • SAP Business Planning and Consolidation 10.1 version for the Microsoft platform

Product

SAP Business Planning and Consolidation 10.0, version for Microsoft ; SAP Business Planning and Consolidation 10.1, version for Microsoft

Keywords

EPM, BPC NW, BPC MS, Business Planning and Consolidation for NetWeaver, SAP BPC FOR NetWeaver, , KBA , EPM-BPC-MS , Microsoft Version , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.