Load Control Tags—Application-Specific

Financial Management, Hyperion Enterprise, Essbase, and Strategic Finance use specific sets of load control tags in specific ways.

Financial Management Load Control Tags (Multiload Excel Files)

Financial Management does not use tags 4, 5, 6, and 9. For the unused tags, you must insert commas as placeholders.

If a Financial Management load control tag (2, 3, 7, 8, or 10) is missing, FDM defaults to the data-load options defined in Integration Settings. The default value for tag 1 is Replace, and the default value for tag 10 is YTD.

Tag 1: FDM Load Method	Tag Value
Append	A
Replace (default)	R
Append—zero suppress	AZ
Replace—zero suppress	RZ

Tag 2: Financial Management Load Method	Tag Value
Merge	M
Replace	R
Replace by security	RS
Accumulate	A

Tag 3: Financial Management Load Process	Tag Value
Load	0
Scan	1

Tag 7: Accumulate in File	Tag Value
Yes	Y or T
No	N or F

Tag 8: File Has Share Data	Tag Value
Yes	Y or T
No	N or F

Tag 10: Data View	Tag Value
Year-To-Date (default)	Y or YTD
Periodic	P or Per
Qtr year-to-date	Q, QYTD, or Qtr
Half-year	H or HYTD

Note:

In row 5 (Excel template) or row 6 (text template), you can specify creation of a Data View column so that each data row can have a Data View tag. If no Data View tag is defined in the header and no Data View column exists, the default Data View (YTD) is used.

Financial Management Load Control Tag Examples (Multiload Excel Files)

Example 1—A value for each tag. Commas are required as placeholders for unused tags (4, 5, 6, 9):

R,M,0,,,,Y,N,,YTD

Example 2—A value for only the FDM Load Method tag. The other tags default to the values specified in Integrations Settings. The Data View tag defaults to YTD. Commas (placeholders) are not required after the last (in this case, only) value.

Example 3—A value for only the FDM Load Method and HFM Load Method tags. The other tags default to the values specified in Integration Settings.

R,M

Hyperion Enterprise Load Control Tags (Multiload Excel and Text Files)

Hyperion Enterprise does not use load tags 5, 6, 8, 9, and 10. For the unused tags, commas are used as placeholders. If a Hyperion Enterprise tag (2, 3, 4, 7) is missing, FDM defaults to the data-load options defined in Integration Settings. The default value for tag 1 is Replace.

Tag 1: FDM Load Method	Tag Value
Append	A
Replace (default)	R
Append—zero suppress	AZ
Replace—zero suppress	RZ

Tag 2: Enterprise Load Method	Tag Value
Merge	M
Replace	R
Accumulate	A

Tag 3: Data View	Tag Value
Category	C or Cat
Periodic	P or Per
Year-to-date	Y or YTD

Tag 4: Scale	Tag Value
None	N, 1, or “None”
Units	U, 0, Units
Tens	T, 1, Tens
Hundreds	H, 2, Hundreds
Thousands	TH, 3, Thousands
Ten thousands	T-TH, 4, Ten Thousands
Hundred thousands	H-TH, 5, Hundred Thousands
Millions	ML, 6, Millions
Ten millions	T-ML, 7, Ten Millions
Hundred millions	H-ML, 8, Hundred Millions
Billions	B, 9, Billions

Tag 7: Zero No Data	Tag Value
Yes	Y, Yes, True, T
No	N, No, False, F

Hyperion Enterprise Load Control Tag Examples (Multiload Excel and Text Files)

Example 1—A value for each tag. Commas are required as placeholders for tags that are not used (5 and 6). A comma is not required after the last tag value:

R,M,C,N,,,Y

Example 2—A value for only the FDM Load Method tag. The other tags default to the values specified in Integration Settings.

Example 3—Values for only the FDM Load Method and Oracle's Hyperion® Enterprise® Load Method tags. The other tags default to the values specified in Integration Settings.

R,M

Essbase Load Control Tags (Multiload Excel and Text Files)

Essbase does not use load tags 3, 4, 5, 6, 8, 9, and 10. For the unused tags, commas are used as placeholders. If an Essbase tag (1, 2, or 7) is missing, FDM defaults to the data-load options defined in Integration Settings. The default value for tag 1 is Replace.

Tag 1: FDM Load Method	Tag Value
Append	A
Replace (default)	R
Append—zero suppress	AZ
Replace—zero suppress	RZ

Tag 2: Essbase Load Method	Tag Value
Merge	M
Replace	R

Tag 7: Zero No Data	Tag Value
Yes	Y, Yes, True, T
No	N, No, False, F

Essbase Load Control Tag Examples (Multiload Excel and Text Files)

Example 1—A value for each tag. Commas are required as placeholders for tags that are not used (3, 4, 5, 6). A comma is not required after the last tag value:

R,M,,,,,Y

Example 2—A value for only the FDM Load Method tag. The other tags default to the values specified in Integration Settings.

Example 3—Values for only the FDM Load Method and EssbaseLoad Method tags. The other tags default to the values specified in Integration Settings.

R,M

Strategic Finance Load Control Tags (Multiload Excel and Text Files)

Strategic Finance does not use load tags 4, 5, 6, 8, and 9. For the unused tags, commas are used as placeholders. If a Strategic Finance tag (1, 2, 3, or 7) is missing, FDM defaults to the data-load options defined in Integration Settings. The default value for tag 1 is Replace.

Tag 1: FDM Load Method	Tag Value
Append	A
Replace (default)	R
Append—zero suppress	AZ
Replace—zero suppress	RZ

Tag 2: Strategic Finance Load Method	Tag Value
Replace	R

Tag 3: Data View	Tag Value
Category	C or Cat
Periodic	P or Per
Year-to-date	Y or YTD

Tag 7: Zero No Data	Tag Value
Yes	Y, Yes, True, T
No	N, No, False, F

Strategic Finance Load Control Tag Examples (Multiload Excel and Text Files)

Example 1—A value for each tag. Commas are required as placeholders for tags that are not used (4, 5, 6). A comma is not required after the last tag value:

R,M,C,,,,Y

Example 2—A value for only the FDM Load Method tag. The other tags default to the values specified in Integration Settings.

Example 3—Values for only the FDM Load Method and Oracle Hyperion Strategic Finance, Fusion Edition Load Method tags. The other tags default to the values specified in Integration Settings.

R,M