NULL values are not displayed in Webi

building reports webintelligence
1

I have an issue in Webi where NULL values are not displayed.

Following are the details:

Org PriorMonth Current Month
A $123 $456
B NULL NULL
C $456 $345

In Webi, i see the following output:

Org PriorMonth Current Month
A $123 $456
C $456 $345

The B organization is missing in Webi as the value is Null.

I have tried the “Show Empty values” snd other options in Properties tab.

Any help would be highly appreciated :slight_smile:

Thanks,
Antara Das

antara0123 (BOB member since 2012-05-25)

2

Hi,

Do you know whether the report query retrieved those values and they are just not displayed in the report? Or the report query did not retrieve them at all? Those are two different cases.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Hi Marek,

The query is not retrieving the NULL values from the database.

Any suggestions plzzzzzz.

Thanks,
Antara

antara0123 (BOB member since 2012-05-25)

4

It can be because of two reasons:

  1. There are conditions in the query that prevents NULL values to be retrieved.
    So check the query conditions and try to adjust them.

  2. There are simply no records of the metrics for the org value B in the database.
    In this case, a technique described in this reporter’s FAQ will help you to display also the B value in the report:
    FAQ: Reporter

Marek Chladny :slovakia: (BOB member since 2003-11-27)

5

@Antara:

If I understood the requirement correctly, it looks like you are building a cross tab report… Cross tabs will remove the records that has 0 or NULL values…

You may look for NoFilter() function or create another data provider that brings ORG object only and merge the two DP’s. Display ORG dimension from Second DP into the report.

BO_Chief :us: (BOB member since 2004-06-06)

6

There is a trick to force all Orgs to appear in a report, even if your query does not return values for it:

  • create a new query with only the orgs (A,B,C)

  • use the merged object (not [Query].[Org], but [Org]) in your crosstab.

All Org values should appear. Works in simple cases, and some less simple ones.

KFonMurphi :fr: (BOB member since 2007-10-16)