Thursday, 8 May 2008

Description field in the Time dimension in Performancepoint 2007

What do you do when you want to use the description field in the time dimension in Performancepoint Server 2007?
The reason for this question is that I need to be able to show in an Excel input form which days are Easter each year, when is summer vacation and so on. They need this information to do better planning. The most logical answer would be to add this information to the Time dimension as it is information that is closely related to the dates in the Time dimension. You can't add a new field to the Time dimension, so I thought I use the description field which is already in the time dimension. The only problem is that you can't change the description field in the Planning Business Modeler.
I tried to change the table directly in the SQL Server and then did a Deploy Model Site in the Planning Business Modeler. You can see the result here:

This isn’t supported by Microsoft as you go and change something that isn’t change with the normal API or user interface.

Random posts: