Show all Customers (Master data) even if Sales is zero in Webi Report
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.
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.