Dashboard Prompt

Varun Dhondea

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,

John_K

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

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