Invalid Member Property names in PerformancePoint Server 2007 Planning and Budgeting

I would like to mention about issue in PerformancePoint Server 2007 Planning module.
The problem concerns to adding new attributes (member properties) to dimensions used in our business model.
As you know business models in PPS are based on SQL Server Analysis Services (SSAS) technology. SSAS does not allow to use in OLAP structures some words in object names, e.g. ‘ID’.

Unfortunately, PerformancePoint Server 2007 with SP1 (version 3.0.3917.00) does not prevent users from adding dimension attributes which are invalid in SSAS, such as ‘ID’. The result of this fact is very important and potentially dangerous. When you add in your Business Modeler new Member Property with Name=’ID’ and save your changes to the model, PerformancePoint Server does not tell you that something is wrong with your new property.
To apply your changes you need to save it and deploy to the Model Site. Save operation works well.
But when you are going to deploy your Model Site, you will receive the following deployment error:

 Total time elapsed: 13.23 seconds
The attempt to deploy, test1, to the model or model site failed. (Error code: PerformancePoint_1050200270)
Failed generate and process of Olap object(s): Errors in the metadata manager.
The ‘Entity’ dimension contains a member property with invalid name: ‘ID’ is one
of the reserved words.

So, in this situation the solution would be very simple.
Change name of this new property or delete it. Unfortunately, it is not as simple as it looks.
Business Modeler application does not provide option for delete or rename member properties.
So, in this case you will need to create new application from scratch or recover it from your backup.
Please keep in mind this issue.
I hope with next SP2 this problem will be solved.

Advertisements
This entry was posted in PerformancePoint Server 2007 and tagged . Bookmark the permalink.

Leave a Reply

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