A Report Displays a Blank Column When Previewed in Enterprise but Shows Data in Enterprise Reporting

A Report Displays a Blank Column When Previewed in Enterprise but Shows Data in Enterprise Reporting
		Modified 22-DEC-2010     Type PROBLEM			n

---

Applies to:

Hyperion Enterprise Reporting - Version: 3.6.0.0.00 to 6.5.0.0.00 - Release: 3.6 to 6.5
Information in this document applies to any platform.
Issue when Reports are run from within Core Enterprise. Reports are fine within HER.

Symptoms

A specific report when previewed in HER shows data in a Category column but no data when the same report is run from Reports Module within Enterprise.

Cause

The report used the Period @cur function which failed when the point of view (POV) category was set to one with a different year setting to the category on the Report.

Solution

There are two date functions which can be used to define a period in a report.

CUR returns the current month from the POV including year.

CMO  returns the current month only and so works when the POV Category is a different year.

The columns definition was such that it hard coded the category but used an @CUR to define the period from the POV. The columns were changed to use @CMO and then they returned the data correctly regardless of the POV category year in both Enterprise and HER.