Pass Multi-select parameters in URL — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Pass Multi-select parameters in URL

Received Response
31
Views
5
Comments
user8618679
user8618679 Rank 2 - Community Beginner

Hello!

I need to display a report as an embedded content in a dashboard. I have two prompts in the dashboard namely Year and Region. Now, for passing the the year and region values to the report I have created presentation variables and used that in the URL. My single select prompt is working fine with this but for multi-select, all values passed are considered as a single string. i.e if I select Region1 & Region2 in the Region prompt the values are passed as "Region1, Region2" and the report filter considers this as a single string and displaying no results showing Region is equal to/is in 'Region1,Region2'. Is there any other way we can pass multi-select value to the report through URL?

Given below is the URL I have given in the embedded content.

http://localhost:9502/analytics/saw.dll?Go&Path=%2Fshared%2FReports%2FExpand%20Column%20Sample%20Report&Action=Navigate&…

Answers

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    Hello,

    There is any specific reason why you are using URL to pass parameters?

    why dont we using "action links", you could pass more the one value in a one parameter, and it's very simple to use.

    Creating and Using Action Links and Actions

    Kind Regards,

  • Joel
    Joel Rank 8 - Analytics Strategist

    IF you do need GO URL instead of action links then you can find more information here:

    http://MYSERVER:9704/analytics/saw.dll?Dashboard

    &PortalPath=/shared/Sample Lite/_portal/QuickStart

    &Page=Overview

    &Action=Navigate

    &col1="Products"."Products Hierarchy"

    &hierid1=Products 

    &dimid1=H1 Products

    &tblnm1="Products"

    &val1="Brands"+"FunPod"+"Product Types"+"Cell Phones"

    &psa1="Sample Sales Lite"

    &col2="Time"."Per Name Year"

    &val2="2008"+"2009"+"2010"

    &psa2="Sample Sales Lite"

    &col3="Offices"."Office"

    &val3="Foster Office"+"Tellaro Office"+"Eden Office"

    &psa3="Sample Sales Lite"

  • user8618679
    user8618679 Rank 2 - Community Beginner

    I have two reports one main report and detail report. I have placed the main report and corresponding prompt in a dashboard page and navigating to the detail report from the main report through the action link. On clicking the action link, the user needs the detail report to be displayed on the same page without hiding the existing dashboard page(hide only the main report not the dashboard). So I am trying to put the main report in the dashboard page as an embedded content.

    When including the report as embedded content, on clicking the action link replaces the main report and displays the detail report on the same dashboard page as per the user requirement. This works well without prompts or with single select. But I have a multi-select prompt and it is not working as expected.

  • user8618679
    user8618679 Rank 2 - Community Beginner

    Hi Joel,

    Thanks for your reply.

    For me the multi-select values are dynamic, User can select Region1 & Region2 at a time or Region1, Region2, Region3 at a time and goes on... I can't predict the values and hence cant pass the values as such in the URL. So only I am using parameter variable and but that is passing all selected values as a single string.(for ex "Region1,Region2" instead of "Region1", "Region2".

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    Hello, maybe it is not the best solution but as a workaround you could create another dashboard page with the detail report(keep the reports that you have in your dashboard) and you could pass the parameters. Kind regards