Dashboard Prompt

Question

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,

Felipe_Idalgo · Answer

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 when '@{var_time}' = 'Fiscal Period' then end This Above calculation can be inserted directly on your analisys as you want Felipe Idalgo

John_K · Answer

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.