Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

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
21
Views
2
Comments
BIAP
BIAP Rank 4 - Community Specialist
edited Aug 13, 2024 6:00PM in Oracle Analytics Forum

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