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.

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.

Got something to add?

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s