Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Presentation Layer: Custom Display Names and Dynamic Variables?

Received Response
1
Views
1
Comments
Rank 4 - Community Specialist

Hello,

I'm trying to populate Custom Display Names for objects in the Presentation Layer using Dynamic Variables. I tried using a repository variable, but it had no impact on the display name in my subject area. I tried using a session variable also, and it made the display name BLANK in my subject area.

Sample Repository Variable: VALUEOF("Relative_Fiscal_Years"."global_CURRENT_FISCAL_YEAR")

Sample Session Variable: VALUEOF(NQ_SESSION."CURRENT_FY_NAME") 

I'm basically just taking this string and populating it in the Custom Display Name in the properties of a column in a presentation table. Is there something else that needs to happen with the Syntax here? I'd like to do this using the repository variable, but will take the session variable if it works. I've seen it mentioned in a few articles here, but do not see any documentation on doing this anywhere.

Otherwise, I know I can hardcode the names I want to use and that works, but will require maintenance once a year. I'm also able to do this by changing the column defaults in the catalog to use a custom heading based off a presentation variable which references my session variable. Those are probably acceptable solutions, but not as elegant.

Thanks.

Tagged:

Answers

  • Rank 4 - Community Specialist

    I think I actually got this, using repository variables, which is my preferred approach

    I simply entered, referencing a repository variable, with hardcoded text at the end of my string.

    VALUEOF(global_NEXT_FY2_NAME) Spring Forecast

    So it returns "FY25 Spring Forecast".

Welcome!

It looks like you're new here. Sign in or register to get started.