}bedrock.hier.sub.exporttofile - cubewise-code/bedrock GitHub Wiki
Description
This process will Export a subset in a Hierarchy of a Dimension to a file. Custom record delimiter (specified by a character or its ASCII code) can be used.
Format of the file:
- 1st line: File metadata contains summary information about the dimension, hierarchy, subset name, number of elements and date/time when file was generated.
- 2nd line and forth: Elements export data.
Note:
Valid dimension name (pDim), subset name (pSub), inclusion of header (pTitleRecord)
are mandatory otherwise the process will abort. Target folder (pTgtDir) must exist.
If needed, custom delimiter might be used by specifying parameter pDelim value as either exactly one character or as a 3-digit (decimal) ASCII code. For example to use TAB as a delimiter, use 009.
Process Parameters
| Parameter | Data Type | Default | Prompt Text |
|---|---|---|---|
pLogOutput |
Numeric | 0 |
OPTIONAL: Write parameters and action summary to server message log (Boolean True = 1) |
pDim |
String | REQUIRED: Dimension name | |
pHier |
String | OPTIONAL: Hierarchy name (default if blank = same named hierarchy) | |
pSub |
String | REQUIRED: Subset name | |
pTgtDir |
String | REQUIRED: Target Directory Path | |
pTgtFile |
String | OPTIONAL: Target File Name (Default Extension .csv) | |
pTitleRecord |
Numeric | 1 |
OPTIONAL: Boolean: 1 = Yes include header row |
pDelim |
String | , |
OPTIONAL: AsciiOutput delimiter character (Default=comma, exactly 3 digits = ASCII code) |
pQuote |
String | " |
OPTIONAL: AsciiOutput quote character (Accepts empty quote, exactly 3 digits = ASCII code) |
Full Process Dependencies
Process doesn't call any dependencies.