Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Passing prompt presentation variable in Navigate URL

User294199Jan 14 2013 — edited Jan 21 2013

Hi,
I have one field prompt called "View" associated to presentation variable "TimeView"
Then i have a request where facts f(x) fields formulas are related to presentation variable in this way: FactTable. Sales @{TimeView}{Monthly}. My request has also two where conditions on Time.Year and Entity.Description fields.

I need to access directly to request by browser URL, Passing Filters to the request through the Go URL.

Following documentation: [!http://gerardnico.com/wiki/dat/obiee/url_filter!] i've created following url statement:

sit01ap01epmt.root.sys/analytics/saw.dll?Go&Path=/shared/Amplifon Technomind/01a Sales Trend
&Action=Navigate&P0=2&P1=eq&P2=Entity.Description&P3="Country Italy"&P4=eq&P5=Time.Year&P6="2012"

All works fine, in fact my request is correctly filtered by Year 2012 and Description Italy.

Now i need to pass also my presentation variable my_var which value must be substitued dinamically within my facts f(x) fields formulas.

How can I modify my URL to achieve this?

Best Regards

Giancarlo

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 18 2013

Added on Jan 14 2013

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

6 comments

2,321 views