A collection of OBIEE / OBISE stuff from 101 till 404. I just put the things here I run into.
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
8 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
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?
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
hi , i want to ask if i can use presentation variable on dashboard contain two reports. the parameter read 2012 the first report show 2012 data and the other one show 2011 "same thing" to help the manager to compare the data between two years.
can i make pass a output value of presentation variable as input to another Prompt ..
eg --
i have two table EMP ,DEPT
I have a dashboard contains two prompts ..
From EMP Table -DEPTNO IS prompted From DEPT Table-DEPTNO is prompted .. when ever i select deptno from dept table it should be reflected in emp deptno prompt .how can i achieve this ..
8 comments:
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
@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
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!
@Anonymous,
Better to use a repository (session) variable instead.
Regards
John
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
hi ,
i want to ask if i can use presentation variable on dashboard contain two reports.
the parameter read 2012 the first report show 2012 data and the other one show 2011 "same thing" to help the manager to compare the data between two years.
Hi John ..
can i make pass a output value of presentation variable as input to another Prompt ..
eg --
i have two table EMP ,DEPT
I have a dashboard contains two prompts ..
From EMP Table -DEPTNO IS prompted
From DEPT Table-DEPTNO is prompted ..
when ever i select deptno from dept table it should be reflected in emp deptno prompt .how can i achieve this ..
Thanks ..
sai kumar
Hi,
Do you have an example of using a presentation variable in KPI?
I am having problems with this..
Regards,
HPR
Post a Comment