Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 11, 2013 at 09:42 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 11, 2013 at 07:21 AM

    Hi,

    Check the Property of that particular table.

    1. check both show rows with all empty measure values .

    2. check both show rows with all measure values = 0 .

    3. check both show rows with the sum of measure values = 0 .

    Regards,

    Anish

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 11, 2013 at 03:12 PM

    Hi

    There are two ways you can get the Customers even though it contains value

    1) At universe level you can use Nvl(Object;'None') in select statement

    2) You can create a constant value in webi report like if isnull(Object ) then "Others " else Object

    3) if you are using Bex query then by default it creates Not assigned value if there is null

    I recommend you to work around at Universe or Bex level since it is higher level ,if you use in webi level lots of unnecessary data will be retrieved and there we applying conditions

    Hope this helps u

    Regards

    S

    Add comment
    10|10000 characters needed characters exceeded