Compartilhar via

  • Artigo

Exportdimension: Planejamento de utilitários de comando

Atualizado em: 2009-04-30

Use the exportdimension command to export dimension member data or hierarchy data to a CSV file.

ObservaçãoObservação:

You must be a member of the modeler role to use this command.

A sintaxe

ppscmd exportdimension [switches] <path>

Command switches

Parâmetros

Parâmetro Necessário Descrição

/server <ServerUri>

Não

Specifies the server URI to connect to. The defaults are those used by Planning Business Modeler.

/application <AppLabel>

Não

Specifies the application to open. The defaults are those used by Planning Business Modeler.

/site <SiteLabel>

Não

Specifies the model site to open. The defaults are those used by Planning Business Modeler.

/dimension <DimLabel>

Não

Specifies the dimension object to be imported. If /dimension is not specified, the whole model site dimensions will be exported.

/hierarchy <HierarchyLabel>

Não

Specifies the hierarchy object to be imported. If /hierarchy is specified, the path must be a file name. If /hierarchy is not specified, the flat dimension members and all hierarchies will be exported.

/encoding <FileEncoding>

Não

Specifies file encoding for the CSV file. The default is UTF8. The list of encodings is available from the online Help for Utilitário de Comando do Planning.

Flags

The following flags provide additional instructions to the server when used with the exportdimension command.

Flag Descrição

/AllIds

Export Member ID, Sequence Number, and Source Member ID.

/ID

Export Member ID of the member.

/Sequence

Export Sequence Number of the member.

/SourceId

Export Source Member ID of the member.

/NoDataType

Do not include column data type in the output.

/StructOnly

Export the dimension structure only, not the members.

Retornar valor

Nenhum

Comentários

To use the default Planning Business Modeler setting, you must first connect to Planning Server, and then make a connection to an application and a model site. In the Connection window, select the Select as Default check box for the application.

The folder path you indicate to export to must already exist; this command will not create a new location for you. The dimension and the hierarchies of a dimension will be exported as a separate CSV file. Member views on a dimension will not be exported as CSV files.

ObservaçãoObservação:

When the user imports the exported CSV file by using the importdimension command or Planning Business Modeler Load Members task, all members of dimension properties will be created as a string property unless the member property was previously created as "member of dimension" type.

The workaround, and the best practice, is to create all the properties in the dimension by using Planning Business Modeler. Then load the members by using Planning Business Modeler or by running the importdimension command.

Exemplo

The following command-line example shows the use of the exportdimension command.

ppscmd exportdimension /app myapp /site mysite /dim mydim “c:\PPS2007"

Requisitos

File encoding can be ISO-8859, UTF8, UNICODE, or ASCII. Use ISO-8859 for 8-bit character encoding.

Consulte Também