OBIEE 11g - Error:"Column is not compatible with the current subject area" Occurs When You Add a Column that Includes Special Character (Doc ID 2179715.1)

Last updated on MAY 01, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Symptoms

Once you create a column with special characters (ex. '素' or '怠') as the last character in Administration Tool, drag & drop it from [Criteria > Subject Areas] to [Selected Columns] will return the following error.

        Column is not compatible with the current subject area "Sample Sales Lite".
        Please check the column formula.

The issue occurs only when you use the special character as the last character of the column name; and when the character is in between other characters, there is no error.

 

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