Oracle Communities

Oracle Analytics and AI

Child Item

Pass in Parameters to Use as Filters in DV URL

Description

I would like the ability to pass in a filter value via a URL querystring (GET method - POST possibly as well) so that another application/website can construct a URL to dynamically filter a DV project directly or embedded DV content.

Use Case and Business Need

We need to create a URL and pass in report criteria to select filters dynamically based on linkage from other website/applications. This functionality exists today in Answers (see example below).

We could also then link Answers to DV pages and pass report criteria in to customize visuals on a specific Canvas within a DV project.

This is somewhat tied to another posted idea that would also be needed so we can reference a specific Canvas within a DV Project using a URL similar to how Answers dashboards allow you to link directly to a particular dash page. This way you are passing the filters required and the canvas you are linking the user to in order to show them the proper pre-filtered data.

More details

Example of Answers URL that allows this functionality today:

/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2FPMRA%2FPublished%20Reports%2FCustomer%20Satisfaction%2FDrill%20to%20Detail%2FDrill%20to%20Detail%20Survey%20Order%20CSat&Page=page%201&Action=Navigate&P0=2&P1=eq&P2=Customer."Sales%20Account%20(NASP%20ID)"&P3="AVXYSZ"&P4=bet&P5=Dates.Date&P6=2+"2015-06-01"+"2015-08-31"

We can dynamically change dates/customer identifiers programmatically within another application to show the proper resultset when a user links into to view that report.

Original Idea Number: cf96abd167

Find more posts tagged with

Delivered

Reporting

Developers

Status: Delivered

Comments

Michal Zima

This feature will put DV on the similar level in respect of functionality/features as the "good old" Answers/Dashboards tools from OBIEE.

Andrew Desalme-Oracle

We're using embedded DV projects with an internal JET-based product and the lack of DV URL parameters (or even params passed into the embedding code) is a major limiting factor for us.

Michal Zima

Very smart idea - DV should have the same concept as GoURL for Answers/Dashboards, alloowing me to construct URL for displaying particular canvas of DV project and passing filtering conditions for that canvas.

Stephan Reyher-Oracle

From my point of view, it is absolutely necessary to be able to transfer filters and parameters to DV dashboards. Embedding in other applications only makes sense if the content in the DV dashboard can be linked to it. We have this requirement in a current customer project. The leading application will be an APEX solution - and DV should be used to display nice visualizations.

Jacques V.-Oracle

Outside of Filters/Prompt values , is there anything else you would expect to be able to be passed on the URL ?

Greg Faris

Being able to pass in the proper Canvas in a DV project would be a requirement as well since we would want to make sure we're linking to the appropriate "page." I had mentioned above an idea regarding adding this as well.

In addition to filter values, we would like to be able to pass in the type of operator like you can do in Answers, so you can choose to use a single value, multiple values, between operators for dates, etc.

Luis E. Rivas -Oracle

This Idea will be address as part of the implementation of https://community.oracle.com/customerconnect/discussion/549540/set-canvas-filter-values-based-on-repository-variables which is an active project and is currently being worked on by the Development team.

Gabby Rubin-Oracle

This video covers it: https://www.youtube.com/watch?v=PQQewy9SB2c&t=35s&ab_channel=OracleAnalytics