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 AI and Analytics

Child Item

Referencing Parameters in the Layout Editor Filter

Mr H

Summary

Referencing Parameters in the Layout Editor Filter

Content

Hi,

What is the syntax we should use to reference a parameter in the Layout Editor Filter?

BR
Hany

Test Filter.png

Find more posts tagged with

Answers

OTBI

Customizing Reports

Analyses

Customizing Layout

Accepted answers

All comments

Prudence K

Hi - what is the end result you are expecting? To display what parameter was chosen or to filter your report to the parameter?

Mr H

Hi,

We have a special case to use the Parameter value to Filter the records based on two columns. So it will do the job for the 1st column and we need to pass it through the filter to the second column.

BR
Hany

Mihaela M

Hi,

Please check https://docs.oracle.com/middleware/11119/bip/BIPRD/create_report_new.htm#editing_parms

Mr H

Hi Mihaela,

I can create and use Parameters with no issues. I need to reference the value of the passed Parameter in another Filter condition. Like in Analysis we can reference the Parameters as Presentation Variable.

BR
Hany

Mr H

As per the screenshot below in Analysis a Prompt is defined as variable and used in the Filter condition.

I need to do the same in the Layout Editor.

BR
Hany

Annotation 2020-02-11 140830.png

Noelle Bartlam-Oracle

Analysis prompts will not be visible within bipublisher reports. They are obiee content, not bipublisher. BIPublisher has it's own parameters that are defined in the datamodel.

If you're usecase is to pass the value of the parameter from an obiee dashboard, there is an excellent blog article that explains how to do this: https://blogs.oracle.com/xmlpublisher/running-bip-reports-in-biee-with-prompts

Noelle

Mr H

Thanks Noelle, the report is based on subject area not a data model. I checked the blog but the parameters form in this case does not have the option to name the parameter as presentation variable. So I was wondering if there is a special naming convention to reference the parameter. Please check the image below:

Noelle Bartlam-Oracle

For BIPublisher reports based on analysis, the filters are inherited by the analysis.

https://docs.oracle.com/middleware/12211/bip/BIPDM/GUID-A456647C-34E7-4278-B07D-7A6B55A8FBF9.htm#BIPDM192

Additional Notes on Oracle BI Analysis Data Sets

Parameters and list of values are inherited from the BI analysis and they display at run time.

The BI Analysis must have default values defined for filter variables. If the analysis contains presentation variables with no default values, it is not supported as a data source by BI Publisher

Mr H

The report is based on Subject Area not Analysis.
The parameter is created on the Report Level.

BR
Hany

Upcoming Event

AI Data Platform - Deploying Agents and Agent Hub in AI Data Platform
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…

Top Leaders