OBIEE 11g Action Link

3184221

Hi All,

I have requirement to achieve through action Link.

Sample Data

  

Project No	Project Version	Project ID
1234	Forecast	12
	Tollgate 0	13
	Tollgate 1	14
	Tollgate 2	15
123456	Order	20
	Tollgate 0	21
	Forecast	22
	Tollgate 2	23

Users want to click on Project no and it should open a another URL which has project ID for Forecast but they don't Project version and Project ID in the report.

Eg :- www.google.com/PJJ_ID=12

I tried with Navigate to web-page when the column is in the report it is working when i exclude the column from the report URL is not working.

Any suggestion how to achieve this requirement?

Gianni Ceresa

Did you try keeping the "Project ID" column in the view of your analysis but as hidden column? As it's still there and part of the view it maybe has a chance to work.

If you exclude it, it doesn't exist in the view, therefore your action can't reference something not present.

3184221

Yes i tried to keep Project ID and hide it in the report but it showing multiple lines in the report which business don't need.

Gianni Ceresa

It obviously influences the granularity of the analysis.

But you can't expect to have a value of a column without the column, and to have the column without the granularity being impacted by it.

3184221

Yes i agree with you but that's the reason i asked is there any different approach to it??

Jerry Casey

Does your target page hold another OBI analysis?  The action link would only require that the target be filtered on "Project ID".

In this example, I've got an action link on "Title" that sends "PIN" to another page.

The target page is filtered on PIN, but PIN isn't required in the output.

Am I missing your point?

The Action Link URL looks like:  https://XXXXXX/analytics/saw.dll?Dashboard&PortalPath=@{1}&Page=@{2}&Action=@{3}&col1=@{4}&op1=@{5}&val1=@{6}

[Deleted User]

Probably the best approach would be the one Jerry mentioned where you pass actual filter values in the URL rather than using the baked-in filter hand-over that Gianni intended. For the former you have to construct things more in detail in the action link (more fiddly) whereas the latter is very easy to use but requires the attributes to exist in both places and be available for filtering.

Gianni Ceresa

So it sounds like the first thing you have to do is to clarify what your need is

3184221 wrote:Users want to click on Project no and it should open a another URL which has project ID for Forecast but they don't Project version and Project ID in the report.Eg :- www.google.com/PJJ_ID=12

Is the page you want to open, as your example, an external link not having nothing to do with OBIEE?

Or is it another dashboard / analysis in OBIEE?