Hi all,
Now it is possible to use all types of variables in the title.It has been acknowledged as a defect with bug no.:6019292.The effective solution they have provided is as follows:
For session variables:
@{biServer.variables[‘NQ_SESSION.variablename’]}
For repository variables:
@{biServer.variables[‘variablename’]}
For your reference this is the overview of OBIEE Variables Chart:(From http://siebel-essentials.blogspot.com/2008/09/oracle-bi-ee-variables.html))
Dhaduvai
October 4, 2008 at 11:00 pm
Shiva,
Very useful post. Thanks for this overview. I had a lot of questions on OBIEE variables which have been answered with this overview.
Regards,
Dhaduvai
Rajat
October 22, 2008 at 8:48 pm
Shiva,
How did you get the demo2 user assigned to region “East”.
Reply
Rajat
Shiva Molabanti
October 23, 2008 at 11:00 am
Rajat,
Use datalevel security concept for your Region table.
Thanks
Shiva
Geoff Smith
January 7, 2009 at 3:50 pm
If I use @{biServer.variables[‘staticvariablename’]} for a static repository variable in a title field I just get the code used to set the value. A dynamic repository variable displays fine.
Rittman borges
January 22, 2009 at 9:46 pm
Hi Shiva
Very good posts
Shiva can you give us an overview of presentation variables and how to use them in answers
also if you can share your views on briefing books it will be nice for us.
Can you also let us know the shared logon feature in connection pooling and why its used
Looking forward
Borges
Jogesh
March 25, 2009 at 2:49 pm
Thanks for the Post.It helped.
🙂
Sethu
June 16, 2009 at 3:53 pm
Hi Shiva,
Thanks for the post, it is useful information.
There are 2 prompts on a dashboard, the first prompt sets a presentation variable (PV) and the second prompt is populated based on the 1st prompts’ PV value. This is coming up fine, however, we need the default value also to be populated based on the PV value. The version we are using is 10.1.3.3.2. Please suggest a workaround/solution if you have come across this issue.
Thank you,
Sethu
Senthil
December 1, 2009 at 7:30 pm
Hi Shiva,
I have a requirement where on selecting a value from a drop down (filter) a quivalent unique key (primary key) needs to be used as part of the query used by OBIEE.
For eg:
I have Region Names shown as part of drop down (filter).
Now when the user selects North America, the associated id say 7 has to be used in the query by OBIEE insetead of Select … From .. Where regionName = ‘North America’ it has to use Select … From .. Where regionId = 7.
Is this achievable in OBIEE? If yes, do help me.
thanks,
Senthil
Usman
January 1, 2010 at 2:17 pm
Respectable!
I am new to OBIEE. It becomes a challenge for me to pass variables from dashboard prompts and to catch their value in Answer’s Request.
I would like to illustrate it with an example.
Request based on the following SQL statement
Select NAME, AGE, CITY, ADDRESS
From emp
Where DOB = ‘@{p_date}’
Now DOB is in TIMESTAMP format,
it looks like ‘11/1/2009 12:00:00 AM’.
Dash board Prompt also depends upon the same column and have also same TIMESTAMP format.
In next step
I create a dashboard page
Place prompt and report there
Saved the dashboard
Now I select a date from prompt list and press go button
It shows no result.
I tried several combinations in @1 syntax e.g.
Where DOB = ‘@{p_date}’
Where DOB = ‘@{p_date}{1-nov-2009} ’
Where DOB = cast (@{p_date} as date)
Where DOB = cast(to_char(@{p_date}, ‘dd-mmm-yyyy’) as date)
…………………….
And many other combinations
I am looking for any help/tips in this regard
Subhash.T
January 6, 2010 at 12:56 pm
Hi
Small Requirement.
By default in OBIEE we will have Sub Total and Grand Total
Now I wan to change according to the prompt I want to select.
i.e, In stead of sub total I want total for that value which ever I select in prompt
For example: If I select a in prompt then
Sub total should display like total for a and if i select b it should display total for b and if select both in multi select then I should get both
how can we achieve that in OBIEE
Thanks
Subhash
Subhash.T
January 6, 2010 at 12:57 pm
Hi
Small Requirement.
By default in OBIEE we will have Sub Total and Grand Total
Now I wan to change according to the prompt I want to select.
i.e, In stead of sub total I want total for that value which ever I select in prompt
For example: If I select a in prompt then
Sub total should display like total for a and if i select b it should display total for b and if select both in multi select then I should get both
how can we achieve that in OBIEE
Thanks
Subhash
Lemon
January 25, 2010 at 11:56 am
Hi Shiva,
I was wondering if there is any way to use presentation variables in calculated items in the pivots? I tried using the variables using the syntax @{variable_name} but to no success.
Hope you can shed some light.
Thanks,
Lemon
Willie
May 6, 2011 at 1:52 pm
Hi Lemon,
I saw your post :
Posted by Lemon on January 25, 2010 at 11:56 am
Hi Shiva,
I was wondering if there is any way to use presentation variables in calculated items in the pivots? I tried using the variables using the syntax @{variable_name} but to no success.
Hope you can shed some light.
Thanks,
Lemon
…I am wondering if you ever got a solution to this problem as I am also facing this issue.
Thanks.
Willie
sujithaallada
January 25, 2010 at 12:11 pm
hi shiva,
very glad to meet u..
Abdulla Kazim
May 25, 2010 at 7:03 am
Shiva,
I am new to Oracle BI and both the online documentation and the help documents don’t have the right syntax to display the repository variable in the title.
Your solution helped me.
Appreciated.
SUMAN
August 19, 2010 at 10:35 am
hi passing request variable frm dashboard and it go to the RPD and pass this variable value in to our physical query in physical yaar.how it is possible ..plz replay me…
ravi
June 17, 2011 at 7:13 am
hi
how can i display my name in column wise
ex:
ravi as
r
a
v
i
MuRam
August 16, 2012 at 5:33 am
In version-10.1.3.3.1, its not working… Its it something with the version ?