Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

<<MemberAlias("GridName", Row/Col/Page, "DimName")>> in HFR

adnan645May 12 2020 — edited May 12 2020

Hi,

In HFR report Period dimension (in column A) has values from Jan,Feb...... till Dec.

I am using this formula as <<MemberAlias("Grid1", A, "Period")>> and it gives me Jan. Is it possible if we can bring the second member as output which in this example is Feb? please note that I can not add column B and keep Feb there. I can not keep columns A, B, C, D etc for Jan, Feb, Mar, Apr etc.

Additional Details:

Actually I am using a Range function for period dimension. The result will only come in one specific column, not multiple columns. I want to show the selected range at header of report by select first and last members of the range.

Thanks.

Regards,

Adnan Arshad.

This post has been answered by Srini+K on May 12 2020

Jump to Answer

Added on May 12 2020

#business-intelligence-applications, #performance-management-applications, #planning-and-budgeting

2 comments

210 views