In one of my cubes I have a customer dimension the dimension is
currently just the customer numbers. Our users also want the customer
names to be displayed not sure how to do this I created a member
property on the customer dimension called as custName and then defined
a virtual dimension on the member property of customer called Custname
and added this virtual dimension to the cube.

Until I add the virtual dimension the numbers in the cube are OK after
adding the virtual dimension all my data in the cube is distorted or
wrong and if I removed this new virtual dimension the data is OK.

Please help how do I get the customer names back in the cube without
causing loss of data in the cube.

Thanks
Karen

Hi Karen,
Welcome to Analysis Service.
In the dimension you can have a level have a key field which in this case
would be your Customer number, and then have a Display Field, which would be
the field for the name. You can concatinate the name field for Last and
First name in the Display Field so it looks the way you want to. This way
when you use the dimension you will only see the customer names instead of
the numbers. You could also concatinate the customer ID with the Customer
name for this Display name.

As far as the Virtual Dimension goes I would look to see if you have
duplicate names in the dimension.

Most users would like to see the name instead of the ID, so you could use
either as a member property, but the front end and MDX query would have to
specificly ask for the member property to be shown as well.


"Karen Middleton" <karenmiddleol (AT) yahoo (DOT) com> wrote