How to navigate to another report by clicking value?

User472204-OC

Hi Experts，

Customers want to click the value of columns in report created by BIEE to navigate new reports in another system, so I want to know how to pass the parameter for this value to another system by the following link (The values '1400007' is dynamical for clicking):http://mstg/Store/1400007

I try to use this function 'Navigate to a Web Page', but it does not work.

Put the url link as below: http://mstg.sys/Store/@{1}

Robert Angel

Hi,

I have used the formulas in the past to build up a dynamic URL to drill out of OBIEE to another system, would this work for your requirement?

If not, can you be a little less vague with what your error is, and also more fully explain where the parameter is getting its value?

[Deleted User]

It's all described in the Integrators Guide in the documentation:

https://docs.oracle.com/middleware/1221/biee/BIEIT/toc.htm

[Deleted User]

Also Action Framework with the Navigate To Website action where you simply parametrize the url

Using Actions to Integrate Oracle BI EE with External Systems

User472204-OC

Hi Robert,

It is on dimension column and generate the following error message.

Robert Angel

Hi,

web is not really my thing, but from the error it looks like it is preventing you building the body of the http, but is okay with you providing a query token along the lines of &my_token_to_pass=@{1}

This would protect your other system from an informed destructive http injection attack.

User472204-OC

Hi  Christian,

I do not see more detail inforation for Navigate to a Web Page, is there any useful sampe for this function? Thanks.

User472204-OC

Hi Robert,

The actual navigating link as below, which is not '=' , and replace the dynamic code with clicking vlaue.

http://mstg.mcd.com.cn/Store/1400007

So is there any method for implementing this requirement?

Gianni Ceresa

Actually the first option posted by @Robert Angel is probably what you need.

Action link accept parameters only in the query part of a url (so it means after a ?, so your target must have be able to understand the parameter like if you call http://mstg/Store/?uscode=1400007 ).

OBIEE refuse parameters as part of the URL (which is a bit dumb as more and more often URL are build to be nice and parameters are put as port of URLs, and there is is then a rewrite to point to the right place).

Gianni Ceresa

You can actually do it in 2 way: editing the formula as suggest or defining a custom format for your column.