PerformancePoint Server Consulting

Dimension import using .csv file

Nov 11

Written by: Kevin Jobe
11/11/2007 8:39 PM

Dimensions

Load dimensions via .csv files:

The .csv file must adhere to the following format.

Cell a1 = ! dimension = dimension name
Cell a2 = ! hierarchy = All Members
Cell a3 = Label (value required)
Cell b3 = Name (value required)
Cell c3 = Description (value optional)

Values in the Label and Name columns are required. Values in the Description column are optional, but the header is required in the template.

Also, you can include other columns with headers and data. These will import directly into PPS with the .csv file and will become dimension properties. These are useful for creating member views.

Trackback Print

Location: Blogs

PerformancePoint and Business Performance Management

Planning

Tags:

2 comments so far...

Re: Dimension import using .csv file

Hello,
What about role of creating .csv files, for example, can i load this csv file for Scenario dimension?

! dimension = Scenario
! hierarchy = All Members
Label,Parent,"MemberId:Int64","Description","Name","SequenceNumber:Int64","SourceMemberID:Int64"
Actuals,,"1","Actuals,"Actuals","1024","1"
Forecast,,"2","Forecast","Forecast","2048","2"
Budget,,"3","Budget","Budget"3072","3"
BaseCase,,"4","BaseCase","BaseCase","4096","4"

By Aigul on 5/13/2008 8:45 AM

Re: Dimension import using .csv file

You should be able to load this, however, you will need to have Label, Name, Description listed as the FIRST columns in your .csv file, followed by the additional properties you are including.

By ppgcAdmin on 5/13/2008 9:09 AM

Your name:
Title:
Comment:

Add Comment Cancel