Bedrock.Dim.Attr.ImportFromFile

This Bedrock TM1 TI will create attributes to a dimension from a file.

Parameters

Parameter

Data Type

Default

Explanation

pDimension

String


The name of the dimension on which the process is to run.

pSourceDir

String


The file directory where the data file exists.

pSourceFile

String


The file name that contains the attributes to be loaded.

pTitleRows

Numeric

2

The number of title rows in the file to be skipped

pDelimiter

String

,

The delimiter used in the file.

pQuote

String

Quotation character.

pDebug

Numeric

0

The debug mode.


Example

ExecuteProcess('Bedrock.Dim.Attr.ImportFromFile',

    'pDimension','Account',

    'pSourceDir','C:\FileData',

    'pSourceFile','attributes_account_dim.csv',

    'pTitleRows',0,

    'pDelimiter',',',

    'pQuote','"',

    'pDebug',0

    );


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