OBIEE - Dynamic selection from prompt and its manipulation — Oracle Analytics

Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

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

OBIEE - Dynamic selection from prompt and its manipulation

Received Response
11
Views
3
Comments
Fat Goblin
Fat Goblin Rank 2 - Community Beginner
in Oracle Business Intelligence Applications

Hi Guys,

I want to select 6 (continuous) months from prompt and display them on report.

But also i want create calculated Measure which will hold the difference between the 2 latest months from selected months.

Note : Month column has datatype var-char.

I want to know is this possible?

Thanks and regards.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    I would say it's doable.

    But I wouldn't select the 6 months from the prompt as you can't force the user to select continuos months, so you better ask the user to select 1 months and then you do all your logic.

    For example the user select the last month, you then display 6 months going back from the selected one and the rest of the logic.

    Everything is doable ... it's just some logic in filters etc.

  • User_N8YMF
    User_N8YMF Rank 3 - Community Apprentice

    Hi,

    Its doable in a dashboard. Select one value from the dashboard prompt, store it in a presentation variable and then calculate and arrive at the remaining months in a hidden prompt, and you can other possible calculations in the hidden prompts as well and then use it in the report.

    Thanks

    Rajesh

  • EmmanuelMash
    EmmanuelMash Rank 4 - Community Specialist

    There are quite a number of ways to achieve this. One is to make use presentation variables like already suggested above or you can the default selection in your new prompt window. You can choose the SQL Results option and write a sql statement using the TIMESTAMPADD feature i.e First get current_date then go back six months using SQL_TSI_MONTH,6