Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

OBIEE dynamic Axis titles for charts

Received Response
22
Views
2
Comments
BIAP
BIAP Rank 4 - Community Specialist
edited Aug 13, 2024 6:00PM in Oracle Analytics Cloud and Server

Hi,

We have a presentation variable prompt. One requirement is to display axis title based on the selection of the prompt. Is it possible to dynamically display axis title in OBIEE?

Many Thanks

chart.PNG

Answers

  • BIAP
    BIAP Rank 4 - Community Specialist

    I tried to use "CASE '@{P_Code1_Label}[@]{1}' WHEN '0,1' THEN 'Code 1' ELSE CONCAT('Priority ', '@{P_Code1_Label}[@]{1}') END". OBIEE treats this as a string rather than formula.

  • SaQ-Orcl
    SaQ-Orcl Rank 4 - Community Specialist

    Hi,

    We have done something similar. (m and k scale based on prompt)

    CASE When '@{var}{m}'='m' THEN "Fact"."@Fact"."@{var}{col}"/1000000 when '@{var}={m}'='k' THEN "Fact"."@{var}{col}"/1000 END

    Thanks