Data error in OBIEE ?? Qucik Fix


If you ever suddenly have a case where NULL dates are formatted as 0/0/0 in your report within OBIEE, it’s most likely because you forgot to check the “Nullable” flag on the column in the physical layer.

When you use the import wizard, it does this for you automatically. When you make columns by hand it’s only populated if you remember to do it.

Just a quick note that may help save some time!

Thanks,
~KKT~

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s