Knowledgebase: Enterprise
A Report Displays a Blank Column When Previewed in Enterprise but Shows Data in Enterprise Reporting
Posted by Priya Doyle on 16 February 2011 11:11 AM

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.


(1 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: