We are developing a DashBoard On Bi Aging report. Data is matching with BI aging report, so no data issue.
In Bi Query we have used Suppress Zero Records but In Dashboard all material are passed i.e Suppress Zero records is not working while data fetch to DashBoard
For Eg: in Bi report with "Suppress Zero" records we have 500 records
and Bi report without "Suppress Zero" records we have 3000 records.
So It has decreased the performance of Dashboard as we need handle large numbers of records in Dashboard.
how can we filter blank record in Bi report?