วันศุกร์ที่ 24 สิงหาคม พ.ศ. 2555

Null value in Dashboard Prompt (select list) OBIEE 11.1.1.6

When I migrated RPD and Catalog from OBIEE 11.1.1.5 to 11.1.1.6 (cause of sync AD bug).
Some part in report changed , in dashboard prompt has more 1 choice is Null.
The Null value not exist in my dimension table but it shown in dashboard.

How to solve it? I found the method from http://www.rittmanmead.com/2012/03/obiee-11-1-1-6-new-dashboard-analysis-and-reporting-features/  from Khun Scott reply.

Step that I already test and it work
1. My problem

2. Go to OBI Admin and go to column in Physical layer, deselect Nuulable


3. Result No Null

I don't sure Khun Scott is the same with Scott at Oracle education or not , but thanks for your your reply and thanks for Rittman Mead!



ไม่มีความคิดเห็น:

แสดงความคิดเห็น