Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Show all Customers (Master data) even if Sales is zero in Webi Report

Hi all,

I have a requirement in webi report like even if sales for a particular customer has net value zero for past 12 months ( which is shown in the reports), the customer should be seen in the report. Now what is happening is if there is no value the particular customer is neglected.

From the Following post https://scn.sap.com/thread/1566637 i understand, one solution is to simply add a constant value in query. Should this constant be created in bex level or universe level.

Can somebody please guide me to create a constant value in query and achieve the requirement.

Thanks,

priya.

Former Member
Former Member replied

Hi,

you can also copy the webi query and in the second query dont include any key figures, then merge the customer dimension. With this trick you can display all customers.

Best regards

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question