Cascade Skyline - with Microsoft Logo and Project Support header - author Brian Smith

Project Server 2010: Take care changing custom fields to allow multiple values

Project Server 2010: Take care changing custom fields to allow multiple values

  • Comments 3

One of the options when setting up a custom field is to allow it to have multiple values selected from the lookup table.  There are however some downsides to this, and a recently discovered bug makes one of these downsides a higher risk than it should be.  This relates to OLAP cubes – and the fact that custom fields with the ability to select multi values cannot be added to cubes.  First a reminder of where this value is set:

 

image

Problems begin when you wish to change this later to a multiple value option custom field – and it is already in a cube configuration.  The exact nature of the problem will depend on whether your data was migrated to Project Server 2010 from an earlier version or not – and if so, if the custom field was already added to the cube. 

I’ll deal with the case of migrated/upgraded data first.

If you select the check-box for a field that was included in a cube before you upgraded to 2010 then try and save you will get the following message – regardless of whether the field is in a cube currently or not.

The custom field could not be saved due to the following reason(s):

  • "The selected custom field is currently part of one or more Project Server OLAP cubes and the change requested is not supported by the cubes. Select a valid setting or remove the custom field from the OLAP database(s)."

There is no way to make the change, as the validation checking that it isn’t in a cube is not working correctly in 2010.  If you are in this situation and really, really want to make this change then best open a support incident.  Remember – the change from single to multiple value selection is NOT REVERSIBLE!  So please be very sure you want to make the change.  In this case even deleting the cube will not help.

For brand new 2010 installations the root of the problem is the same, but with different results.  If your custom field has been added to a cube configuration and you then choose to allow multiple values then the validation will think everything is OK, and that your field is not in a cube when it actually is.  This will mean that the save of the change will succeed.  If you view the cube configuration it will look like the field has been removed – whereas in fact it has just been filtered out as it is now multi-value.  The end result is that you never got the warning – you didn’t get the chance to reconsider if you could live without this field in the cube – or if you really needed multi-value – and to top it all your cubes will no longer build.  The error will be something like

Failed to build the OLAP cubes. Error: InitCustomFieldDimensions cannot process the Project custom field 'ProjectColours'

There are a couple of workarounds though, depending if you are reading this having hit the problem – or lucky enough to see it while still thinking about making such a change.  If the field is removed from any and all cubes that it is included in BEFORE making the change to multiple value then all will be OK (but as mentioned – only for new 2010 systems – upgraded ones will get the error above).  If you already hit the issue then the easiest option would be to delete the cube and build a new one – but this doesn’t help if you really decided you couldn’t live without this data in the cube...  Also you can’t delete the default cube – so you may need to create another cube – delete the first one and then rename the second one back to the same name as the first.

Another option in either case would be to create another custom field and let that one have multiple values – leaving the original one exactly as it was.

No current dates I can give you for a potential fix, but as mentioned earlier – log a call with support if you have run in to this – no charge as it is a bug.

Leave a Comment
  • Please add 6 and 8 and type the answer here:
  • Post
  • Brian, I am dissapointed that Microsoft still haven't managed to fix this properly in 2010. It is a feature that has not worked properly in 2007 and we now have to go through the hassle again to try and 'patch' it up in 2010 :(

  • Hi Megan, As far as I am aware there was nothing 'broken' in 2007.  If you mean that you could not add multi value fields to the cube then that is never going to change.  How would you expect this to work?  If you had a project 'tagged' with two different values (or more...) should it show it two different places in the report?  Which totals should the values from that project display in?

    If I am missing your point please let me know.

    Best regards,

    Brian.

  • We unfortunately "already hit the issue "  Can I just delete the custom field that is flagged as multiple and add a new one for a single value  and rebuild the cube

Page 1 of 1 (3 items)