Go URL does not pass context values

odie_63

Hi,

OBIEE 12.2.1.4

I have a source analysis A1 with these columns (fully qualified names) :

Dim : "Organization"."Organization Code"

Dim : "Time"."Period Name"

Dim : "Resource"."Resource Group"

Meas. : FILTER("Fact"."Required Qty" USING "Resource"."Resource Group" = 'GRP1')

"Organization Code" is filtered by a prompt.

Data is displayed in a bar chart :  measure expression vs. "Period Name"

All very simple so far.

I created an action link on the measure using "Navigate to a Web Page" and defined this target URL (line breaks added for readability) :

@[actionsvr]/saw.dll?PortalGo

&Action=Navigate

&PortalPath=/shared/Folder1/_portal/MyDashboard

&Path=/shared/Folder1/Analyses/A2

&col1="Resource"."Resource Group"

&val1=GRP1

The purpose is to open detail analysis A2 when we click on the bar in the chart.

A2 also has both "Organization"."Organization Code" and "Resource"."Resource Group" columns, with corresponding filters set to "Is Prompted".

Issue :

On click, navigation occurs to A2 as expected but only "Resource Group" is passed, and not "Organization Code".

According to the documentation, "Organization Code" should have been passed implicitly.

https://docs.oracle.com/middleware/1221/biee/BIEIT/apiwebintegrate.htm#BIEIT365

The destination search should have filters defined on columns for which it wants to receive context. These can be specific filters or, usually, the Is Prompted filter. In addition to the Table.Column value specifically referenced in the navigation call, all filters from the source request that have corresponding table.columns in the destination, are applied to the destination. Therefore, the appropriate context from a source can be passed to the destination.

"Navigate to BI Content" works correctly but this is not exactly the feature I'm looking for.

I want to be able to pass a specific parameter, along with values from the source context.

Thanks for any input on this.

Marc.

Jerry Casey

Hi Marc,

When using "Navigate to a web page", you have to explicitly include all of the columns you wish to pass.  In your prompted url, you'll need a  val, col, psa triplet for Org Code as well as  Resource group.

Jerry

odie_63

Thanks for your reply.

So do I have to conclude the documentation is wrong, or at least very misleading?

I'm suprised it doesn't work the same as "Navigate to BI Content" because it also issues a PortalGo behind the scenes (via a POST command) with almost the same parameters, and without passing "Organization Code" explicitly.

The only major difference I see is the passing of the ViewState. Is that the one that makes it all?

Jerry Casey

My answer is only based on experience.  I haven't looked at that particular documentation in quite a while, but if it is a little misleading, I wouldn't be shocked.