Paginated Report - Measure and Recordset From Query consideration

Hi!! With Paginated Reports you generally cannot pass an OUT SYS_REFCURSOR from an Oracle stored procedure using OLE DB. The report expects a query that directly returns a result set. The usual workaround is to wrap the procedure in a table/pipelined function or view and query it with SELECT * FROM TABLE(...).

In the other hand, measures in paginated reports don’t behave like in Power BI Desktop. You can’t reliably use a measure to filter groups/datasets because filtering happens before measures are evaluated. The best approach is to push the filter logic into the SQL/query or create a calculated field in the dataset.

Hope this helps!