Bedrock.Dim.Export

This Bedrock TM1 TI exports information about the the elements of a dimension to a file. This information can be read by Bedrock.Dim.Import to rebuild the dimension.

Parameters

Parameter

Data Type

Default

Explanation

pDimension

String


The name of the dimension.

pExportPath

String


The file path were the output file is to be created.

pExportFile

String


The name of the file to be created. If no file name is provide then the default file name is the name of the dimension with '.csv' appended to the file name.

pTitleRecord

Numeric

1

The file is to contain a header.

pDebug

Numeric

0

The debug mode.


Example

ExecuteProcess('Bedrock.Dim.Export',

    'pDimension','Cost Centre',

    'pExportPath','D:\Landing_Zone\Export',

    'pExportFile','Cost Centre Backup.csv',

    'pTitleRecord',1,

    'pDebug',0

    );


Output file 

The output file will follow the following format.


Header

If the pTitleRecord parameter is 1 then the header will contain the following information.


Parameter

Data Type

Line 1

Control data about the export file.

Line 2

The name of the source dimension.

Line 3

The dimension sort order of the source dimension.

Line 4

Reserved for future requirements.

Line 5

Reserved for future requirements.

Line 6:

Column headings.


Output file columns

Line_Type

The type of information been provided.

E is element information.

A is attribute information.

P is an element's parent information

V is an element attribute information.

Element

The element in the dimension

Value_1

The value that appear depends on the Line_Type.

Value_2

The value that appear depends on the Line_Type.

Value_3

The value that appear depends on the Line_Type.


Copyright 2011, bedrocktm1.org Tested on: TM1 Versions 9.1 to 10.2.1 / Cognos Express 9.0 to 10.2