You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to Link a Column in OTBI to a Parameter Based on Conditions?

edited Jul 8, 2024 8:15PM in Reporting and Analytics for ERP 6 comments

Hello,

I am working on a report in Oracle Transactional Business Intelligence (OTBI) and I need some help with linking a column to a parameter based on conditions. Specifically, I have a "From Date" and "To Date" parameter in a pivot table, and there is a column outside the pivot table that I want to show the value of the date before the selected parameter.

For example:

  • If the selected date range is from 1 Jan 2023 to 1 July 2023, the column should display the value for Dec 2022.

Is it possible to achieve this in OTBI? If so, could someone guide me through the steps or provide an example?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!