D_FSAVE

D_FSAVE lets you create or update very large dimensions whose dimension worksheets would exceed the row limit of an Excel worksheet.

To use the D_FSAVE function, create a delimited ASCII file called dim.dit, where dim is the name of the dimension you want to create or update. This file must reside in your local server data directory.

The structure of the ASCII file must match a dimension worksheet, as follows:

  • Include three fields per line.
  • In the first field, specify the element type (C for consolidated; N for numeric element; S for string element; blank for consolidation component).
  • In the second field, specify the element name.
  • In the third field, specify the weight, if needed. The default weight is 1.0.

Separate the fields using the delimiter defined in your operating system. In Windows, this delimiter is defined by the List Separator entry in the Regional Setting Properties dialog box.

If there are errors in the structure of the ASCII file such as misplaced or undefined elements, an error message displays.

This TM1® macro function is valid in Excel macros and VBA modules only.

Syntax

D_FSAVE(file)

Argument

Description

file

The name of a delimited ASCII file that has the file extension .dit. Do not include the file extension. This file must reside in your local TM1 data directory.

Example

=D_FSAVE("Region")

This example reads an ASCII file named Region.dit and creates or updates the Region dimension.

Note: D_FSAVE can be used to create or update dimensions on remote servers. However, the function always looks for the .dit file in the local data directory (as defined in Tm1p.ini). You must be sure that the .dit file for the dimension you want to create/update resides in your local data directory, then specify the server on which you want to create/update the dimension by prefixing the .dit file with the server name.
=D_FSAVE("TM1Serv:Region")

This example looks for a file named Region.dit in the local server data directory, but writes the Region dimension to the data directory for the TM1Serv server.