Enhancement: Request to Address Conditional Drill Limitation in FDI Product

User_MZI0L

In the current FDI product, we have implemented a conditional drill feature in our reports. However, we are encountering the following issue:

• When executing a report with conditional drill enabled, we receive the error message: “Exceeded configured maximum number of allowed input records” whenever the query processes more than 500,000 records.
• It is important to note that the same report runs successfully and returns expected results when the conditional drill feature is removed, even when processing large data volumes.

We request Oracle to review and update the code or configuration in the FDI product, so that reports using conditional drill can process and display results for record sets larger than 500,000—similar to standard reports without conditional drill. This enhancement will be helpful for ensuring consistent report functionality.

RVohra

While you wait for Oracle to review the idea and provide the solution, see if this new feature can help to overcome your issue.

https://blogs.oracle.com/analytics/enable-and-configure-dynamic-aggregate-tables-feature-in-fusion-data-intelligence

Hope it helps!