PerfomancePoint Server 2007, want to create dimensions from a csv file

When you create dimensions in PerformancePoint Server you have an option to create a dimension from a csv file.

This sounds like a great way to kick start your dimensions because you can take a csv file with data and upload it to create a dimension and  have it populated with some data.

Great idea, but only if you know the format of the csv file.
The first 2 rows are header records that must be there to define the dimension and hierarchy before you list the column headers.

See the screen shot below.

image
If you have data, go ahead and add it in, so you create the dimension you can also have it import your data to give you a head start.

Advertisements

Got something to add?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s