1394646 - Microsoft Analysis Services 2005 measure data type 'Big Integer' not visible in an OLAP Grid of Crystal Reports XI R2

SAP Knowledge Base Article - Public

1394646 - Microsoft Analysis Services 2005 measure data type 'Big Integer' not visible in an OLAP Grid of Crystal Reports XI R2

Symptom

  • Using Crystal Report (XI R2 with SP4) to connect to OLAP cube in Microsoft SQL Server 2005, the result of measure field with the type of  'Big Integer' is '0' after processing the data. 
  • Doing the same against cube in  Microsoft SQL Server 2000 the values for a measure field with the type of  'Big Integer' are correct.

Environment

  • Microsoft SQL Server Analysis Services 2005
  • Crystal Reports XI R2 SP4

Reproducing the Issue

  1. Make sure the SQL Server 2005 cube has at least one measure field of the data type 'Big Integer' (BigInt).
  2. Create an Crystal Reprots OLAP report based on this cube.
  3. Select the BigInt measure (among others) as one of the displayed measures in the OLAP grid.
  4. The data for the BigInt measure is displayed as '0'.
  5. The data which can be seen inside SQL Server 2005 cube (browse cube data) is not displayed at all.

Resolution

  • This Problem was reproduced and escalated under
    • Technical Escalation ID:  5000155341
    • Problem Report:  ADAPT01311688.
  • A fix for this issue has been put into Fixpack 5.8 (released end of December 2009).
  • The fix will also be released in FixPack 6.1 ( expected release date is end of February 2010).

Keywords

OLAP, MSAS, MSAS 2005, SSAS, CR, Big Int, , KBA , BI-RA-MD , OLAP Intelligence, multidimensional databases , Bug Filed

Product

SAP Crystal Reports XI R2