How to display different members within a same dimension in the same row
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.