Financial Reporting Report Design Affects Performance (Doc ID 1110184.1)

Last updated on AUGUST 08, 2016

Applies to:

Hyperion BI+ - Version 9.3.1.3.00 and later
Information in this document applies to any platform.
***Checked for relevance on dec 11,2014***


Symptoms

You have created two reports against the same Hyperion Financial Management (HFM) data source.

The performance is noticeably different between the reports.

Report1:

Rows:  Entity, Account, C1, C2, C3, ICP
Columns:  Scenario, C4
Run Time:  Less than 1 minute.

Report2:

Rows: Entity, C2, C3, ICP
Columns: Scenario, Account, C1, C4
Run Time:  About 30 minutes.

Moving the Account and C1 dimensions from the rows into the columns causes slower performance.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms