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.
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…
We would like to understand the reason for the difference in configuration options for the “Send Message to Team” action across the Redwood VBCS Recruiting pages. Currently, we observe the following behavior: On the Job Requisition and Job Requisition List pages, it is possible to hide/remove the “Send Message to Team”…
Is there a way to extract existing BIP reports saved in a specific folder? Like can capture Report Name, Report Path and Owner for example?
Is there a log that can be checked on our side that might help with the issue. I've submitted an SR, however it is currently being bounced around between different areas. Could not establish connection. oracle.xdo.delivery.ssh2.SSHMessageException: Error in decrypting message Current thought is that this is an issue with…
Hello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reporting in Redwood Dashboards Redwood Experience: Recruiting Dashboard When I add a session variable to my OTBI reports, I correctly see a value of 0 in my…
'Facility Name' exists in the Recruiting - Recruiting Real Time multiple times with varying usage. Job Requistion -> Job Requisition - Additional Details -> Facility Name Job Requistion -> Location -> Facility Name Is there any reason why these two Facility Names would not exist in the Recruiting - Real Time Events subject…
