Referencing Parameters in the Layout Editor Filter
Hi,
What is the syntax we should use to reference a parameter in the Layout Editor Filter?
BR Hany
Hi - what is the end result you are expecting? To display what parameter was chosen or to filter your report to the parameter?
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.
Please check https://docs.oracle.com/middleware/11119/bip/BIPRD/create_report_new.htm#editing_parms
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.
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.
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
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:
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
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
The report is based on Subject Area not Analysis. The parameter is created on the Report Level.
We have built an OTBI report intended for Line Managers to view their subordinates’ emergency contact details. The report uses the Workforce Management - Person Real Time subject area. When a Line Manager runs the report, the emergency contact fields (e.g. EC Phone Type, EC Phone Number, EC Email Type and EC Email Address)…
Hi All, Good Day. We have created one custom OTBI report and it has "Business Unit" as of one of the parameter. The related list of values is showing all the business units and we want to restrict it to the user who has the related Business Unit data access set access. Please let us know how to achieve this in OTBI report.
I have a Leave Details Report with the condition below to restrict the report based on the logged-in user's AOR. However, the report is not returning any data for any legislation, when users run it under the 'About Me' context.
Our Requisition OTBI analysis is having many values Requisition Number Requisition Title Requisition Status Hiring Manager Full Name Recruiter Full Name am able to see values for all. When am passing Prompt(Hiring Manager Full Name or Recruiter Full Name) am not able to see the data. Am sure we have values/data for passed…