Bedrock.Cube.Data.ImportFromFile

This Bedrock TM1 TI imports data from a file to a cube.

Limited to a cube with a maximum of 27 dimensions.

Parameters

Parameter

Data Type

Default

Explanation 

pSourceDir

String


The directory where the file is saved. 

pSourceFile

String


The name of the file to be loaded into the cube.

pCube

String


The name of the cube where the data is to be loaded.

pDimension

String


(Optional) The name of the dimension within which to copy data from source element (exported element) to target element.

pSourceElement

String


(Only required if pDimension is used.) Exported element to copy data from.

pTargetElement

String


(Only required if pDimension is used.) Element to copy data of exported element to.

pTitleRows

Numeric

1

The number of title rows in the file that will be skipped by this Bedrock TM1 TI.

pDelimiter

String

,

The character separator of the data.

pQuote

String

The quote character used in the source data.

pAccumulate

Numeric

0

Use 0 to not accumulate amounts when importing.

Use 1 to accumulate amounts when importing.

pDebug

Numeric

0

The debug mode.


Example

ExecuteProcess('Bedrock.Cube.Data.ImportFromFile',

    'pSourceDir','C:\FinancialData',

    'pSourceFile','Actuals.txt',

    'pCube','General Ledger',

    'pDimension','Version',

    'pSourceElement','Budget',

    'pTargetElement','Budget_v2,

    'pTitleRows',1,

    'pDelimiter',',',

    'pQuote', '"',

    'pAccumulate',0,

    'pDebug',0

    );


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