Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

DISPLAY THE DATA BASED ON PROMPT SELECTION IN OBIEE 11G?

Received Response
82
Views
6
Comments
ARIVEMULA KAVYA KUMARI, LERA TECHNOLOGY PVT LTD
ARIVEMULA KAVYA KUMARI, LERA TECHNOLOGY PVT LTD Rank 5 - Community Champion
edited Aug 13, 2024 7:09PM in Oracle Analytics Cloud and Server

Hi,

I am woking on obiee 11g. I want to display the data as current_month, previous_month, variance.

My requirement is , if select the month, then automatically display the current_month and previous_month, variance data columns in table.

Please help me.

Thanks in advance,

A.kavya

Answers

  • Sandeep Andhale
    Sandeep Andhale Rank 3 - Community Apprentice

    Hi

    -first edit analysis under prompt tab

    -you have to create prompt on month or Calendar Month (their lot of fields related month under time folder of standard subject area).


  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    Current_month you have it by the filter on the month column (based on the prompt where you select the month).

    Add a new column where you use the AGO function on your measure to get the previous month figures.

    Add a 3rd column where you calculate the variance by using the previous 2 columns.

    For the AGO function to work you must have a correctly defined time dimension in your model with a level for the month.

    You can also get the previous month figures by doing some modelling in the RPD in case you want (as you can also create the calculate column with AGO in the RPD directly to not have to do it by hand all the time).

  • ARIVEMULA KAVYA KUMARI, LERA TECHNOLOGY PVT LTD
    ARIVEMULA KAVYA KUMARI, LERA TECHNOLOGY PVT LTD Rank 5 - Community Champion

    Hi,

    I have tried. but i am getting null values.

    please send any document for this.

    Please help me....

    Thanks in advance,

    A.kavya.

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    What have you tried exactly?

    Did you analyse the reason of the NULL values?

    If you just make a simple analysis by filtering on a single month can you manage to get a measure and the same using the AGO function?

    Is is this one return NULL?

    What does your formula looks like?

    What does the physical query looks like?

    If you analyse a bit your case you will probably find the reason of the NULL (can be an error in the formula, a badly designed time dimensions, wrong chronological keys etc.).

  • jprakash
    jprakash Rank 2 - Community Beginner

    Kavya,

         You can create the ago measure using the below link

          OBIEE 10G/11G - Period to period comparison with the AGO Function [Gerardnico]

    For ur case:

        AGO(<YOUR MEASURE>, <MONTH COL>, <1>)

    Note: You need to have Time Dimension defined in your business model

    Thanks, JP

  • Gianni Ceresa
    Gianni Ceresa Mod

    Just a detail ....

    <MONTH COL> isn't the month column in your subject area !

    The second parameter of the AGO function is the level name of the time dimension you want to you for your AGO (by changing this value you have day ago, month ago, year ago etc.)