I’m trying out different options for navigation between Dashboards and Analysis, and I need to pass Presentation Variables values (or preserve them) during this navigation. I can’t use the Navigate to BI Content Action Link because sometimes the target analysis is using a column with a different Presentation Table Name.
I’m working with OBIEE 11.1.1.7.140527, and I have checked this document (http://docs.oracle.com/cd/E28280_01/bi.1111/e10544/dashboards.htm#BIEUG690) detailing the new parameters (new with OBIEE 11.1.1.7) instead of the old P0, P1, etc.
Anyway, I have tried using the &valeval# to pass the presentation variable value to an analysis during navigation, and I haven’t been able to make it work.
These are the steps using the OBIEE Sample:
Create a simple analysis to list the P2 Product Type Column, using the is prompted filter:
Create a Dashboard Prompt to ask for a value of the P2 Product Type, and associate the Presentation Variable PV_PRODUCT_TYPE:
Create a new Dashboard, add the Dasboard Prompt and a Text Object, in the Text Properties, check the box of Contains HTML Markup and add the following text:
<a href=http://url:port/analytics/saw.dll?Go&Path=/shared/my_path/my_analysis&Action=Navigate&col1="Products"."P2%20Product%20Type"&op1="eq"&val1="Camera">Navigate to analisys with is prompted filter passing value Camera</a>
Don’t forget to replace the blanks with %20 in your url.
When you execute the Dashboard and click on the link, you navigate to the analysis with the Product Type filtered:
(In fact, it isn’t working for me in OBIEE Sample, but it works in my development enviroment, so I’m sure I have a misspelling error somewhere I’m not seeing)
Now, if I try to change the Navigation passing the Presentation Variable PV_PRODUCT_TYPE, I’m not getting any results. I have tried this tree calls:
<a href=http://url:port/analytics/saw.dll?Go&Path=/shared/my_path/my_analysis&Action=Navigate&col1="Products"."P2%20Product%20Type"&op1="eq"&valeval1="PV_PRODUCT_TYPE">Navigate to analisys with is prompted filter passing PV_PRODUCT_TYPE</a>
<a href=http://url:port/analytics/saw.dll?Go&Path=/shared/my_path/my_analysis&Action=Navigate&col1="Products"."P2%20Product%20Type"&op1="eq"&valeval1=dashboard.currentPage.variables['PV_PRODUCT_TYPE']>Navigate to analisys with is prompted filter passing dashboard.currentPage.variables['PV_PRODUCT_TYPE']</a>
<a href=http://url:port/analytics/saw.dll?Go&Path=/shared/my_path/my_analysis&Action=Navigate&col1="Products"."P2%20Product%20Type"&op1="eq"&valeval1=@{PV_PRODUCT_TYPE}>Navigate to analisys with is prompted filter passing @{PV_PRODUCT_TYPE}</a>
But neither of them is working, nor any variances I have tried (the &op1 parameter shouldn’t be necessary as is the default).
Has someone managed to make this work?
Regards
Ana GH