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

Dashboard Prompt

Received Response
31
Views
2
Comments
Varun Dhondea
Varun Dhondea Rank 2 - Community Beginner
edited Aug 13, 2024 6:10PM in Oracle Analytics Forum

Hello,

I am fairly new to Oracle BI and i need to pass the parameter of the dashboard prompt to a formula in my fact.

I have 2 parameters: Fiscal Year and Fiscal Period

If the user selects year i should change the formula to (Inventory) / <12> or <12> * number of years selected

If user selects 1 month only then formula (Inventory) / <1> changing on the number of years or months selected.


Do you OBIEE experts have an idea how to work this?

Rgds,

Answers

  • John_K
    John_K Rank 5 - Community Champion

    You can achieve things like this using presentation variables, however your requirement sounds "odd". You should try and do as much as possible in the OBIEE repository, and if that means having a logical formula that divides something by the distinct count of something else then do it that way.

  • Felipe_Idalgo
    Felipe_Idalgo Rank 5 - Community Champion

    Hi,

    ++Other way

    You could create a formula for testing your selections or create a new variable prompt with the options Fiscal Year and Fiscal Period

    and based on this selection change your calculations, like that:

    Case when '@{var_time}' = 'Fiscal Year' then <put your columns or calc here>

              when '@{var_time}' = 'Fiscal Period' then <put your columns or calc here>

    end

    This Above calculation can be inserted directly on your analisys as you want

    Felipe Idalgo