Show TOC

Example documentationImport Master Data Descriptions from a Data File Example Locate this document in the navigation structure

 

Prerequisites

The target cube contains the Account, Category, and Time dimensions.

The target data is aggregated prior to the copy process.

Process

If the source description record already exists in the dimension member’s description table, the record in the table is overwritten by the record in the data file. Otherwise, the system inserts the description record in the data file as a new record.

Example Format

In this example, the dimension is Account and the member is ACCPAY.

Pre-Import Descriptions

ACCPAY E Account Payable

ACCPAY F Account Payable in French

Data File Descriptions

ACCPAY E Account Payable in English

ACCPAY C Account Payable in Chinese

Result

Post-Import Descriptions

ACCPAY E Account Payable in English

ACCPAY F Account Payable in French

ACCPAY C Account Payable in Chinese