Add custom field into OLAP cube

[jpa]

Hi
(PS2007, SP1 + PIU)
I created a Lookup Table "TASK" custom field whose name is
"T_TD-ActivityCode_Task" (LT is made of 10 possible values).
Then I'd like to add this field as new dimension for the OLAP cube.
Within Cube Configuration page, in the Cube Dimensions part, I selected Task
for the Cube, then I can see among the Available Fields my custom field, then
I select it and press Add button but I have following error message saying
"Failed to save your cusom field and calculated measure configuration
settings.
Ensure the following rules are met:
a) the number of custom fields added as dimensions does not exceed 100 in
each cube
b) Each custom field name is valid for OLAP
c) The custom field, calculated measure and Project Server built-in object
names are distinct from each other"
I really don't see what I did wrong...
This is the 1st custom filed I add into the cube, so I don't think a) is the
cause.
What means b)?
There is no calculated measure associated to my custom field... How to check
c)?

thanks for any help
jpa

 

[Ben Howard]

Rename the custom field to remove the "-" and see if that works.

 

[jpa]

Thanks Ben for your feedback. Indeed it solves my problem!
But now I added a new post regarding the process to follow when we change
the name of an enterprise custom field...
Let's move forward step by step...
jpa

 

[Ben Howard]

OLAP disallows some characters. Always best to stick to 0...9 and a...Z,
plus an _


--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/