1633290 - BPC MS Reports and Input Templates Return Inconsistent Results

Inconsistent / incorrect / wrong data values appear in BPC (EPM Add-In/Web/EVDRE/EVGET/EVGTS) reports and input templates. However, the report may return correct data values if you run the same report after the SQL Server Analysis Services (SSAS) data cache is warmed up.

The following error may occur in the Windows Event Viewer application log:

Event Type: Error
Event Source: MSSQLServerOLAPService
Event Category: (256)
Event ID: 22

Description:
The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Internal error: An unexpected exception occured.

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

Inconsistent data, Data doubling, EVDRE doubling, MSSQLServerOLAPService Event ID 22, Internal error: An unexpected exception occured / occurred , KBA , 3rd party tools config and system admin , reporting , EPM-BPC-MS-EXC-SR , Send/Retrieve , Problem