Example: Entity Dimension Import File

In this example, the import file loads an Entity dimension with the required header record and three data records. This example is comma-delimited. The header record specifies the member to be imported (Entity), the parent member (Parent) into which to import the member, and the Data Storage property to assign to the member.

Entity, Parent, Data Storage

e1, Entity

e2, ,

e1, e2, Shared

Using this import file would result in this outline, assuming that no other members exist:

Entity
     e1
     e2
       e1 (Shared)

The first data record (e1, Entity) imports Entity member e1 as a child under the root member Entity. Unspecified values assume the default. For example, if data storage is not specified, it assumes the default value, Never Share. The next data record (e2, ,) imports Entity member e2 under the dimension root member because no parent is specified, and sets data storage to Never Share. The last data record (e1, e2, Shared) imports a shared member of e1 under member e2, and sets the data storage to Shared.