Exportdimension: Planning Command Utility operation

PerformancePoint Server 2007

Updated: 2009-04-30

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


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


ppscmd exportdimension [switches] <path>

Command switches


Parameter Required? Description

/server <ServerUri>


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

/application <AppLabel>


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

/site <SiteLabel>


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

/dimension <DimLabel>


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

/hierarchy <HierarchyLabel>


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>


Specifies file encoding for the CSV file. The default is UTF8. The list of encodings is available from the online Help for Planning Command Utility.


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

Flag Description


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


Export Member ID of the member.


Export Sequence Number of the member.


Export Source Member ID of the member.


Do not include column data type in the output.


Export the dimension structure only, not the members.

Return value



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.


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.


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

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


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

Download this book

This topic is included in the following downloadable book for easier reading and printing:

See the full list of available books at Downloadable content for PerformancePoint Planning Server.

See Also