Bedrock.Dim.Sub.ExportToFile

This Bedrock TM1 TI will export the members of a subset to a file. The file columns are:-

Column

Header

Description

1

Index 

The dimension index of the element.

2

Element

The principal name of the element.

3

Alias: [Alias Name] 

The first alias of the dimension.

4

Level  

The level the element is in the dimension.

5

Parent 1 

The first consolidation for the element.

6

Weight 1

 The weight of the element to the first consolidation.

7

Parent 2 

The second consolidation for the element.

8

Weight 2 

The weight of the element to the second consolidation.

9

Parent 3 

The third consolidation for the element.

10

Weight 3 

The weight of the element to the third consolidation.

11

Parent 4 

The fourth consolidation for the element.

12

Weight 4 

The weight of the element to the fourth consolidation.

13

Parent 5 

The fifth consolidation for the element.

14

Weight 5 

The weight of the element to the fifth consolidation.

Up to five consolidations can be specified in the output file.

Parameters

Parameter

Data Type

Default

Explanation

pDimension

String


The name of the dimension where the subset exists.

pSubset

String


The name of the subset that the elements are to be excluded from.

pExportPath

String


The file directory where the export file will be saved.

pExportFile

String


The name of the export file. If no export file name is provided then the default export file is '[dimension name].[subset name].export.csv'.

pTitleRecord

Boolean

1

1 – The first row of the file will include metadata about the dimension. The second row of the file will be the column headings.

0 – Do not include a header row in the output file.

pDebug

Numeric

0

The debug mode.


Example

ExecuteProcess('Bedrock.Dim.Sub.ExportToFile',

    'pDimension','Business Unit',

    'pSubset','Regional',

    'pExportPath','C:\Financial Data',

    'pExportFile','Regional Subset.txt',

    'pTitleRecord',1,

    'pDebug',0

    );


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