Oracle Business Intelligence OBIEE 101: OBIEE Referencing Presentation Variables in Filters

Tuesday, March 17, 2009

OBIEE Referencing Presentation Variables in Filters

How do you reference a presentation variable in your filter:

Press the filter sign of the column

Press Add > Variable > Presentation

Enter the varaible name and default value

Till Next Time

5 comments:

Anonymous said...: oh....please explain me how does this business intelligence works..i have to recommend the implementation of it to allianz in Romania, for my final papper...please help .. hot_chokolate_2003@yahoo.com !please; July 8, 2009 11:12 AM
John Minkjan said...: @Anonymous,

Not really sure what you are looking for. If you want to hire me please contact the ciber office in the Netherlands.

regards
John; July 8, 2009 11:57 AM
Anonymous said...: Is there a way to reference a presentation variable in another column in the same prompt? Say I have a prompt with two columns: Fiscal Year & Month.

The Fiscal Year is Set as a Presentation Variable called "FY".

For the Month I would like to use a SQL Results statement in the "Show" column for the Month which limits the Months shown to only those within the selected Fiscal Year.

SELECT Time."Month" FROM "Sales - Order Process" WHERE Time."Fiscal Year" = //value of the presentation variable fiscal year

Is this possible? And what would I write to get the value of the presentation variable FY?

Thanks!; September 8, 2009 10:10 PM
John Minkjan said...: @Anonymous,

Better to use a repository (session) variable instead.

Regards

John; November 8, 2009 2:43 PM
vipin said...: I have one report requirement which contain one dashboard prompt on Year. this is my presentation variable.
Based on this i want to pull the sales volume of selected year and its previous year.
Ex- if user select year=2009 the in Sales Volume of Current year(2009) and in another column i want Sales Volume of 2008; November 6, 2010 11:33 PM

Subscribe to: Post Comments (Atom)