OBIEE 12c: Column Formula May Not Match Bin Setting When Bin Created Based On the Same Column
Last updated on APRIL 04, 2018
Applies to:
Business Intelligence Suite Enterprise Edition - Version 12.2.1.2.0 and laterInformation in this document applies to any platform.
Symptoms
When you add several identical column on 'Criteria' tab and setting 'Bin' separately, all 'Column formula' of columns will be the same setting as the last setting.
Steps to reproduce:
This can be reproduced with Sample Sales Lite.
1. Create an analysis with column "Products"."Product Number" ".
2. Select the column and click 'Edit Formula.' Navigate to 'Bin' tab.
3. Click 'Add Bin' and select any value.
Ex.
Operator : is equal to /is in
Value : 1
Bin Name : A
4. Click 'OK'
5. Add column "Products"."Product Number" ".
6. Select the column and Click 'Edit Formula.' Navigate to 'Bin' tab.
7. Click 'Add Bin' and select any value.
Ex.
Operator : is equal to /is in
Value : 2
Bin Name : B
8. Click 'OK'
9. Add column "Products"."Product Number" ".
10. Select the column and Click 'Edit Formula.' Navigate to 'Bin' tab.
11. Click 'Add Bin' and select any value.
Ex.
Operator : is equal to /is in
Value : 3
Bin Name : C
12. Click 'OK'.
13. Save Analytics as name.(Ex: Bin_Test)
14. Open Analytics Bin_Test.
15. Verify 'Column formula' tab of all Column. All 'Column formula' has set as below.
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms