NULL and Unspecified in Dashboard prompts after upgrading 10g to 11g OBIEE

Hi All,

We are working on OBI upgradation project from 10g to 11.1.1.6.5. We are facing one issue in Dashboard prompt level. If we can create Dashboard prompt on a column, its giving “NULL”, “Unspecified” additionally. But, in 10g there are no extra values.

And the 10g, 11g instances are pointing to the same database and there are no NULL, Unspecified values in Database level.

Through some  articles we found some solutions n are below.

To remove NULL:

–>Go to the Physical Column properties in Physical Layer and Disable the Nullable option by uncheck the box.

–>Go to Edit Dashboard Prompt, in Choice List Values drop-down list select SQL Results.

To remove Unspecified:

–>Go to Edit Dashboard Prompt, in Choice List Values drop-down list select SQL Results, then write the SQL statements as columnname is not equals to “Unspecfied” ( In this way we can able to remove Null’s also.)

–>Go to Content tab of LTS, in Where clause write an SQL query to restrict Unspecified values.

Note: CHeck with ETL, because if they maintains the Default value is Null when the Datatype is Character and they can maintain 9999 or #### if the datatype is Numeric. And check the Physical query and debug it carefully.

But, we have very big Repository and we have huge no.of Dashboard prompts. So, its not an easy thing to manage by using above solutions. Correct me if there are any mistakes in above.  But, as of now we didn’t get any other solution and follwed the Nullable Option to remove NULL values.

And please let me know if there are any alternative ways to simplify this issue are appreciated here.

Best Regards,

Raghu Nagadasari

Advertisements

About raghunagadasari

Working with a MNC on BI Applications 7.9.6x, OBIA 11.1.1.7.1. Having work exp on EBS, Oracle Apps, ODI, Informatica, OBIEE, Pl/sql,
This entry was posted in OBIEE. Bookmark the permalink.

1 Response to NULL and Unspecified in Dashboard prompts after upgrading 10g to 11g OBIEE

  1. heena goyal says:

    Hey,
    Its a cool stuff
    And for people who like learning online http://www.wiziq.com/course/22309 can be useful .

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s