Sort Function Does Not Work in Financial Reporting (FR) Report Using Hyperion Financial Management (HFM) Datasource (Doc ID 1941957.1)

Last updated on NOVEMBER 10, 2014

Applies to:

Hyperion Financial Management - Version 11.1.1.3.00 to 11.1.2.3.501 [Release 11.1]
Hyperion BI+ - Version 11.1.1.3.00 to 11.1.2.3.503 [Release 11.1]
Information in this document applies to any platform.

Symptoms

When creating Financial Reporting (FR) reports, you can add Relations to dimension member like Children, Descendants and Base etc. The added member has Sort if right-clicking on it. If you choose Sort on account dimension, you can choose Hierarchy, Name and Description as Sort Account Item and Order like Ascending or Descending for any data source like HFM. However, it always shows the same order of items even thought setting up the sort.

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