Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE RPD 12.2.1.2 How to disable certain Consistency Check Warnings

Received Response
25
Views
4
Comments
1322506
1322506 Rank 3 - Community Apprentice
edited Aug 13, 2024 5:57PM in Oracle Analytics Cloud and Server

Since we upgraded to 12c, there are additional RPD consistency check warnings and it is cluttering up the warnings I can't do anything about.  E.g.

[39099] Level "ABC"."XYZ" has at least one display key that contains multiple columns. Only the first column of a display key is displayed when drilling.

[39100] Logical column "abc"."D"."c" has CLOB/BLOB data type but has no sort order column and/or description ID column assigned. This will cause slower query performance.

How can I disable those checks at least the 39100.  We actually caused issues trying to solve for this.

Earlier versions seemed to have a way to do this based on what I read on blogs.  But don't see how to do this in 12c. 

Help.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod 
    1322506 wrote:...I can't do anything about. E.g. [39099] Level "ABC"."XYZ" has at least one display key that contains multiple columns. Only the first column of a display key is displayed when drilling.

    This one is simply fixed by unchecking the "display" checkbox on the current logical level key and add a new key only for display selecting only 1 column.

  • 1322506
    1322506 Rank 3 - Community Apprentice

    Actually what is happening when I did add the additional single Key and uncheck the display flag on the multi-key and apply it to the single key.  It removes the warning after saving.  However, once I close the RPD and reopen it.  And recheck consistency. The display flag now is checked on both keys and 2 warnings are now for this issue.  The old warning is back and the new one added....  I did this change online.  Have not yet tried to do this offline to see if this does not happen that way.

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    Looks like a bug, if you have test case then log a Service Request with Oracle with steps to replicate the issue, below Bug has already been logged but it is for Admin Tool 12.2.1.0.0 as it was with respect to RPD uploaded in BICS environment for which the only supported Admin Tool is 12.2.1.0.0

    Bug 26102738 : BICS 12C ADMINTOOL REPORTS MULTIPLE CONSISTENCY ISSUES FOR KNOWN GOOD 11G9 RPD

  • 1322506
    1322506 Rank 3 - Community Apprentice

    Thanks - yes, this seems pretty buggy to me as well.  Will do