Bedrock.Cube.Data.ViewExportToFile

This Bedrock TM1 TI will export the data from a view within the cube. Options to include or exclude consolidated elements, rule calculated data, and null data points can be specified.

Note: If you wish to export all data for a single element in a dimension use Bedrock.Cube.Data.ExportToFile

Parameters

Parameter

Data Type

Default

Explanation

pCube

String


The name of the cube where the view exists.

pExportPath

String


The directory where the file is to be saved. If no file path is provided, the ASCII file will be saved to the TM1 logging directory.

pExportFile

String


The file name of the ASCII file. If no file name is provided, a combination of the cube and view suffixed by the word “export.csv” will be used.

pView

String


The name of the view to be exported to the file. If no view is provided then the whole cube will be exported to the file.

pSkipRuleValues

Boolean

1

To include (0) or exclude (1) rule calculated data from the export file.

pSkipCalcValues

Boolean

1

To include (0) or exclude (1) consolidated data from the export file. 

pSkipNullValues

Boolean

1

To include (0) or exclude (1) data points that have no data in the export file.

pTitleRecord

Boolean

1

To include (1) or exclude (0) a title row in the export file.

pDebug

Numeric

0

The debug mode.


Example

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

    'pCube','General Ledger',

    'pExportPath','C:\FinancialData',

    'pExportFile','2011 Actual Data.txt',

    'pView','2011 Actual Data',

    'pSkipRuleValues',1,

    'pSkipCalcValues',1,

    'pSkipNullValues',1,

    '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