1393998 - OLAP chart in Crystal Reports 2008 does not show data of Big Integer data type from MS Analysis Services 2005

SAP Knowledge Base Article - Public

1393998 - OLAP chart in Crystal Reports 2008 does not show data of Big Integer data type from MS Analysis Services 2005

Symptom

  • Measure data type of 'Big Integer' from Microsoft Analysis Services cube displays correctly in the olap grid, but not in the OLAP chart associated with the grid.

Environment

  • Microsoft Analysis Services 2005 / 2008
  • Crystal Reports 2008 V0 / V1 / SP2

Reproducing the Issue

  1. Make sure the MSAS 2005 cube has at least one measure field of the data type Big Integer (BigInt).
  2. Create an OLAP report based on this cube.
  3. Select the BigInt measure (among others) as one of the displayed measures in the OALP grid.
  4. You will see the data for the BigInt measure correctly.
  5. Right click in the OLAP Grid and click on Insert chart.
  6. An OLAP chart is created in the report.
  7. You will see that the BigInt data type Measure doesn't show any values!
  8. When you go to Chart options and show the values in the chart, then all the BigInt values are '0'.

Cause

This is a product defect and has been raised as : Problem Report #ADAPT01312194

Resolution

This issue has been addressed by Fix Pack 2.3 for Crystal Reports SP2.

Workaround:

Use different data type: i.e. Integer

Keywords

MSAS 2005, OLAP, CR, BOE, TE 5000154277, technical escalation, 01312194, 1312194 , KBA , BI-RA-MD , OLAP Intelligence, multidimensional databases , Bug Filed

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1