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.
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
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…
Hi Experts, We are using Oracle BI Publisher Email Bursting to distribute reports via email. Currently, one of our bursting outputs generates a report of approximately 20 MB, and we are trying to understand whether there are any size limitations that could impact email delivery. Scenario: Report Delivery Method: Email…
Team, We have a requirement to select below PVOs HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfileItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfilePVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentTypePVO Do we have any documentation around these?
We have a requirement of enabling OTBI report in Purchase Requisition Redwood page similar to classic UI.How can that be done?
