Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE 11g - How to capture HostName or Analytics URL in Presentation Variable
Hi
Is it possible to capture the URL into a presentation variables in OBIEE 11g.
for instance, I am connected to "http://hostname:9704/analytics/saw.dll?Dashboard" I want to capture HostName or "http://hostname:9704/analytics/saw.dll" into a Presentation variable.
Is this possible ?
Any guidance or pointer would be highly appreciated.
Thanks
Andy
Answers
-
Most implementations just solve this by having a static repository variable representing that
0 -
Hi Chris
Thanks for taking time and suggesting.
Just to be clear, I do not plan to hard code Hostname/URL into Static Repository Variable. How will it variable pick hostname/URL when connected DEV/QA/PROD?
Can it be not implemented in Presentation Variables?
Regards
Andy
0 -
Hi,
There are some variables giving you the hostname and few other things, but as far as I remember not the full link with http:// in front and the port number and /analytics...
So what's your use case? (just an example of what you expect to use the variable for, in which place as ...)
0 -
1042982 wrote:Hi ChrisThanks for taking time and suggesting.Just to be clear, I do not plan to hard code Hostname/URL into Static Repository Variable. How will it variable pick hostname/URL when connected DEV/QA/PROD? Can it be not implemented in Presentation Variables?RegardsAndy
Not sure I get your insistence on the Presentation Variable.
a) A repository variable can be dynamic by reading from a DB table.
b) datamodel.sh -updaterpdvariables <--- invented for precisely that use case: updating things during the DEV/QA/PROD deployments
c) Where would your hypothetic Presentation Variable get its value from?
0 -
Ok, to be more precise on the requirement. I have to call the same report recursively by passing a parameters to it. I do this, using Action Link --> Navigate to Web Page". Here in Action, I want to dynamically change the URL/Hostname based on the environment on which the report is run. Hence, I was thinking to use a presentation variable here after fetching the required host with some tricks.
0 -
I know what you want to do. Why do you think a presentation variable will magically solve this? The instantiated value has to come from somewhere.
Even SampleApp uses the approach I outlined. What don't you like about it?
0 -
OK got it, let me try what you have suggested. I was just wondering to avoid changes at RPD level as I don't have access to it.
0 -
You're just stating "11g" so impossible say if global variables would be another vehicle for you - they're only there as of 11.1.1.9 - but that wouldn't change your basic issues:
- Where do you expect the instantiated value come from?
- How do you expect to keep this up-to-date?
0 -
OBIEE version is 11.1.1.7. I was originally expecting the value to be fetched/updated from Analytics URL.
0 -
Sorry to be obnoxious but there were literally sixteen (16) "11.1.1.7" versions rolled out (ref. MOS Doc ID 1488475.1) so it would really help for most questions to know what you're *actually* running. Sixteen versions spanning four years of lifecycle tend to be "a bit different" as you can imagine.
As for "expecting the value to be fetched/updated from Analytics URL": No. The system session variables and system presentation variables (ref.) give you a lot but not the host.
0
