Hyperion Financial Reporting Products (MOSC)

MOSC Banner

How to display different members within a same dimension in the same row

edited Nov 19, 2017 4:02AM in Hyperion Financial Reporting Products (MOSC) 6 commentsAnswered

Currently we are at11.1.2.4.701 version and 11.1.2.4.701.0112 patch. Our Hyperion version is 11.1.2.4.0.79. We have two members under the same dimension. We would like to create a report that would display both members in one row. Is that possible to do it with a function?

Here is the example:

Expense, Revenue Accounts, and Council Resolution Date are both under Account dimension. We would like to display them all in the same row. I tried to use GetCell text function to pull data from row 1 and column B to column C (<<GetCell("Grid1", 1, >>). The report indicated this is an invalid argument.

If the Budget Item dimension is the same between row 1 and row 2, I would like to get the Council Resolution Date in column B to be displayed in column C. The only difference between row 1 and row 2 is the Account, Category, Request Type, and Period Dimension.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center