Problem: After OBI up-gradation our project from OBIEE 10g to OBIEE 11.1.1.6.0 or later, you can face one issue at Dashboard prompt level.
If you create Dashboard prompt on a column, its giving "NULL", "Unspecified" additionally. But, in 10g there were no extra values.
Answers:
1) Go to Admin Tool > Physical Layer.
2) Select Properties of column on which you are going to apply prompt.
3) Uncheck the check box which says "Nullable" as shown below.
4) Save the repository.
5) Check the changes are applied on dashboard. i.e. Null value is disappeared.
Note:
If you are making the changes in Online mode and saving it, don't forget to clear the cache.
If you create Dashboard prompt on a column, its giving "NULL", "Unspecified" additionally. But, in 10g there were no extra values.
Answers:
1) Go to Admin Tool > Physical Layer.
2) Select Properties of column on which you are going to apply prompt.
3) Uncheck the check box which says "Nullable" as shown below.
4) Save the repository.
5) Check the changes are applied on dashboard. i.e. Null value is disappeared.
Note:
If you are making the changes in Online mode and saving it, don't forget to clear the cache.
No comments:
Post a Comment