nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Applying same filter in 2 canvas

User_7YD8C

Hi,

Can anyone explain how to create a filter that should be apply for both the canvas that I have in my work book.

Scenario

I have 2 canvas and it contains date column in both canvases.both canvas built from different data sets.

if I select any date that should be reflect on both the canvases

Obiee

in Obiee we used to create presentation variables and same presentation variable name will be assign to the both reports and creating the prompt with the same variable. We can achieve in obiee analytics dashboard

in the same way I need to create in OAS dv how can I do.

please help me on that

Find more posts tagged with

Accepted answers

Gianni Ceresa

In DV, the "parameter" is the equivalent of the presentation variables you have in "classic" analyses and dashboard.

You can read more about parameters at https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/what-are-parameters.html

Because you have different data sets in your 2 canvases, you can't just pin your filter at the workbook level directly, because that would be a column of one of the datasets.

You can use a prompt to set the value for your parameter, and then you can use the parameter everywhere you need it, in each visualization of your canvas or even setting a filter based on parameter value.

Give it a try, it should work pretty easily (you just need to get used to the new names).

Gianni Ceresa

OAS 6.4 (2022) is out of support being more than 2.5 years old.

Parameters are a OAS 7.0 (2023) feature, and they kept evolving with more pieces added over time.

If you use DV, it’s very important to have a yearly upgraded planned because all the changes between OAS releases are mostly DV features (packaging 12 months of changes released on OAC every 2 months into a single OAS release).

Therefore it’s simple: time to upgrade to OAS 2024 (7.6), and already plan another upgrade for May-June 2025.
OAS is generally released in March/April, give yourself 1-2 months to evaluate the changes and quickly test all works and then upgrade your environment to benefit from all the features.

All comments

Rajakumar Burra

you can use Parameters for filters.

User_7YD8C

Can you please brief about that.

Gianni Ceresa

In DV, the "parameter" is the equivalent of the presentation variables you have in "classic" analyses and dashboard.

You can read more about parameters at https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/what-are-parameters.html

Because you have different data sets in your 2 canvases, you can't just pin your filter at the workbook level directly, because that would be a column of one of the datasets.

Give it a try, it should work pretty easily (you just need to get used to the new names).

User_7YD8C

I am not able to see that option in my dv environment

currently we are using 6.4 version.

Gianni Ceresa

OAS 6.4 (2022) is out of support being more than 2.5 years old.

Parameters are a OAS 7.0 (2023) feature, and they kept evolving with more pieces added over time.

User_7YD8C

Thanks a lot for the information

we will upgrade it.

User_7YD8C

we had done a new installation of OAS 7.6 VERSION in our environment

but we tried to generate the bar file in obiee 12.2.1.4 version esio but it showing some error.

The dobut is it mandatory to.generate the bar file from obiee 12.2.1.4

directly can we upload the rpd by changing changing the data source and archiving and unarchiving the catalog from old version to OAS 7.6 version..

[Deleted User]

For the benefit of all forum users and also the contributors who are here to help - can you please manage your two different requests in two different forum threads?

Keep this one reserved and purpose-oriented for the filter topic.

Create a new one for what you're trying to do with the BAR file / migration. Provide concise and sufficient details in each thread. Only you are sitting in front of your system and n other forum participant has all the information available you have.

Please keep the forum tidy and usable. Thanks!

User_7YD8C

Hi Christian Berg,

Noted will follow.

My doubt is if we are moving from obiee 12.2.1.4 to OAS 7.6 is it mandatory to export the bar file. Or is there any other way if the bar file generating utility is not working.

Steve F-2

Agreed on the 1 issue per thread to make the community tidy.
To close this out.
The OAS Upgrade Guide provides two options.

In-place Upgrade
Out-of-Place Migration (Migrate snapshot/BAR)

For errors/issue, open a new thread or an Service Request, if appropriate.

Please mark Gianni replies as 'answered' , since they answered what original question. This will close out this post.