Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
DISPLAY THE DATA BASED ON PROMPT SELECTION IN OBIEE 11G?

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
-
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).
0 -
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).
0 -
Hi,
I have tried. but i am getting null values.
please send any document for this.
Please help me....
Thanks in advance,
A.kavya.
0 -
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.).
0 -
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
0 -
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.)
0