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

ARIVEMULA KAVYA KUMARI, LERA TECHNOLOGY PVT LTD

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

Sandeep Andhale

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

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

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

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

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

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.)