Datacolumn Settings

Datacolumn settings are divided into datacolumn generation settings, headers, hierarchy year settings, dimension settings, other datacolumn settings, and datafield settings. The following tables and topics describe the elements, attributes, and possible values in more detail.

Datacolumn generation settings

Element	Attributes	Possible values
<datacolumns>
<generates>
<generates>	reportsheet	dynamic, static
<settings>
	fittopages	true, false (default)
	pagebreakblocks	true, false (default)
	removeemptyblocks	true, false (default)
<generateitem>
	dimensiontype	dim[nn], codim00, account, datatype, finyr, finper, documentseries
	generatetype	next, input, selected, branch, all
	level
	hierarchy	Hierarchy ID, variable %DIMnn HIERARCHY%
	sourcedatatype	Data type code, Variable %DATA TYPE CODE%, Empty or not defined
	sourceyear	Year code, Variable %YEAR CODE%, Empty or not defined
	generateorder	parentfirst (default), childfirst
<settings>
<settings>	showselectedunit	no, first, last
<udid>

For details about elements, attributes, and possible values, see Datacolumn Generation Sub-Elements.

Datacolumn header settings

Element	Attributes	Possible values
<datacolumns>	-	-
<headers>	-	-
<header>	-	-

For details about elements, attributes, and possible values, see Datacolumn Header Sub-Elements.

Datacolumn hierarchy settings

Element	Attributes	Possible values
<datacolumns>	-	-
<settings>	-	-
<hierarchyyears>	-	-
<hierarchyyear>	-	Any year udid found in the database, %USERFINYEAR%, %YEAR CODE% (and %YEAR CODE-n%)

For details about elements, attributes, and possible values, see Datacolumn Hierarchy Year Sub-Elements.

Datacolumn dimension settings

Element	Attributes	Possible values
<datacolumns>
<datacolumn>
<datacolumn>	id
<account_statement>		true, false (default)
<headers>
<header>
<header>	language	Languages used in the system, %COLDIMnn CODE%
<dimensions>
<dimension>
<dimension>	type	datatype, account, finyr, finper, document, documentseries, position, dim00 ... dim09, codim00, oid, inputtype Not in use: datatypever, coaccount
<hierarchy>		Hierarchy ID, %DIMnn HIERARCHY%
<level>
<dimensionudids>
<dimensionudid>		ID for the option, %parent_n%, manualentry, autocalculation, calculated, NCI, reconciliation

For details about elements, attributes, and possible values, see Datacolumns Dimension Sub-Elements.

Other datacolumn settings

Element	Attributes	Possible values
<datacolumns>
<datacolumn>
<datacolumn>	id
<settings>
<save>		yes, no, saveonly (not in use)
<scaling>
<currency>		Identifier of the currency,%USERCURRENCY%
<periodizing>		sum, pattern, periodizable
<generalcolumnsettings>
<selector>	.
	type	none, dim[nn], account, documentseries, document, datafield, finyr, finper, datatype
	generatetype	branch, all, input, selected, none
	hierarchy	%DIMnn HIERARCHY%, ID of a specific hierarchy
	sourcedatatype	%DATA TYPE CODE%/%USERDATATYPE%, empty value or missing attribute, ID of a specific data type
	sourceyear	%YEAR CODE%/%USERFINYEAR%, empty value or missing attribute, ID of a specific financial year
<udid>

For details about elements, attributes, and possible values, see Other Datacolumn Sub-Elements.

Datafield settings

Element	Attributes	Possible values
<datacolumns>
<datacolumn>
<datacolumn>	id
<datafield>
	datasource	report, input, celldrilldown, tr
	type	numeric, extra, formulas, comment, trlink, invdata
	presentationtype	formulas
<invdata>
<invdata>	field	amount, margin, taxpcent0, taxpcent
<extra>
<extra>	field
<formulas>
<formula>
<formula>	type	all
<numeric>
	amount	unit, group
	period	periodical, cumulative, %PERIOD REPRESENTATION%

For details about elements, attributes, and possible values, see Datafield Sub-Elements.