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

Question

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

Gianni Ceresa · Answer

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

jprakash · Answer

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(, , <1>) Note: You need to have Time Dimension defined in your business model Thanks, JP

Gianni Ceresa · Answer

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