SAP Knowledge Base Article - Public

1283890 - OLAP report (Crystal Reports 2008) - measure groups are not recognized

Symptom

  • Measure groups from a Microsoft Analysis Services 2005 OLAP cube are not recognized in an OLAP report in Crystal Reports 2008.
  • in the Member Selector all the individual measures are visible, but not the measure groups with the associated fields under the group name.

Reproducing the Issue

  • Windows XP, Windows 2000 and Windows 2003
  • Any version of Crystal Reports 2008 
  1. Create a Crystal Reports 2008 OLAP report based on Microsoft Analysis Services 2005 sample cube Adventure Works.
  2. Go to the member selector for the measure group.
  3. You will see the single measures, but you won't the the measure groups for these measures.

Cause

  • Crystal Reports 2008 re-used some former OLAP Intelligence components which has not been modified to support member groups.

Resolution

  • Measure groups were a new feature in Microsoft Analysis Services 2005 and beyond, and that new feature is not something currently supported in the OLAP components that Crystal Reports uses.
  • To add support for this feature would be a significantly sized item to address, and can only be done as an Enhancement.
  • Enhancement_Request with ID: ADAPT01162839 was created for this functionality.

Keywords

Crystal Reports, CR 2008, MSAS 2008, MSAS 2005, OLAP Measure groups , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V1