Field Attributes for Multilingual Text
- Kavitha Thangaswamy (Unlicensed)
- Pamela Totas (Deactivated)
Multilingual entity and security text are reported with the same field attributes as used when reporting English text from the same fields. You do not have to develop a separate set of field attributes for each language you support.
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.
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 configure field type for multilingual text:
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 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.
