DE.ADD

This enables you to create dimensions with the Process Data function together with an import file.

SeeImporting new elements with Microsoft Excel.

This is a powerful tool when generating large or dynamic dimensions from an ASCII file.

Note: DE.ADD can only be used with the Process Data function.

Syntax

DE.ADD(Database
                           		  alias,Dimension,Type,Element,Parent,Weight,Clear,Description)

Example

Dimension is the name of the dimension to be created or appended. Type is the element type ("N" or "C"), Element is the name of the element to be created and Parent is the name of the parent the element should be consolidated into. Weight is the weighting factor to apply to the element.

DE.ADD cannot change existing relations between elements and their parents. Clear specifies whether the dimension is to be deleted and recreated, or appended to the existing dimension.

If Clear is set to TRUE, the dimension will be cleared, and recreated.

If Clear is set to FALSE, the existing dimension will be appended.

With the Description argument you can enter a description for the dimension. If no description is specified, the dimension name is used.

Note: The Clear and Description parameters are only read when the first record is imported. The value is then used for the rest of the records.

Example

DE.ADD("Tutor","Products","N",$A$1,$B$1,1,FALSE,"Products and product groups") inserts the content of the import file as a new element rolling into "Total Litenotes" in the existing dimension.

Example of the import file:

Litenote P166 TFT 11.4 Total Litenotes
	 Litenote P166 TFT 12.1 Total Litenotes

Use one DE.ADD formula for each hierarchy level. The parameters for Element and Parent may be strings or references to cells containing strings. Strings must be enclosed in quotes.

Importing dimensions and importing the data should be performed in two separate steps.

Adjustment of the dimension elements.
Data import based on the updated dimension.

Note: If you choose "Del" as the type, you will delete the specified element. For example DE.ADD("Tutor_EN","Products","del","Ultraview VGA 21+","Total Monitors",1,FALSE,"Products and product groups")