To Filter Blank Records In Bex

[Former Member]

Hello,

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?

[former_member199945]

Hi,

Either you want to hide single kfg which contains zero records or for all kfg's?

Have you checked data in RSRT after Suppress Zero Records ?

and one more thing suppress result rows applied in Bex won't work in dashboard clearly mentioned in below doc:

http://www.mastering-sap-and-businessobjects.com/sap-businessobjects-bi-4-service-pack-05-support-fo...

Try with conditions in Bex query itself and check either expectyed data is coming or not as suggested by Yasemin.

if not in Dashboard itself try as below :

Thanks.

[Former Member]

i hv done in in Dashboard side, but the issue it has decreased the performance of Dashboard.

for example i need to handle 3000 records but only 500 records are only useful.

I look for a solution in which Bi Query itself will transfer these 500 records....

[former_member199945]

Hi,

Then it need to be do at modelling level in BI itself  before coming data to query i.e info provider level itself,

Have you tried with filters /conditions in Bex query ?

Share some sample data which contains logic handle 3000 records but only 500 records.

Thanks.

[yasemin_kilinc]

Hi Nadeem,

I don't have any experience with dashboard though you may try adding a condition where the KF > 0.

[Former Member]

Hi Yesemin,

There is no effect of conditions while  connect query with 3rd party tools.