...
However, you must select Wide Character as the Field Type. A Wide Character field, when reported using a non-English language selection in an OLAP report profile or a Data Mart model, looks to the appropriate _ML table for its data. Wide Character Field Type shows a field attribute against ENTITY_NAME that looks for data from ENTITY_ML or ENTITY_ML_HIST when local-language reporting is enabled.
| Info |
|---|
The Wide Character Field Type is also required for an entity or security field attribute that has a local-language translation of a code value, or is a rollup or inference field based upon such a field. |
To set field type for an entity or security:
- In Reporting Center, from the left navigation, select Data Management Reports > OLAP Reporting > General Reporting.
You see the General Reporting workspace. - In the Components tab, expand Fields menu and select Entity or Security folder.
You see the fields for the respective type gets listed. - Right-click on the field and select Edit.
You see the Editing Regular Field dialog box. - In the Field Type list, set the field type as Wild Character.
- Click OK to save the changes.
...
