Hello all I have an account parent-child (pc) dimension I would like to use the following fields of my relational table AccountId (INT): the id is also present in the fact table => measure group (optimal choice for performance) AccountName: the name (description) of the account (user friendly name). The description can vary over time. AccountCode: I would like that the code is used to build the uniquename of the member [Account].[CoA].&[NET_ENG_REV]. Code does not vary over time. It would be very nice to have the code of the account in the uniquename to make the calculation more understandable Currently we are using KeyColumns: AccountId NameColumn: AccountName It displays the user friendly name (which is good) but the unique name is not "smart" since it is in the format [Account].[CoA].&[Integer] KPI calculation therefore are impossible to understand without comment. I would like to have uniquename consisting of [Account].[CoA].&[Code] which understandable and since the code can't vary, it will not break. User though would not be satisfied with the code. I could not find a way to set the above properties in order to cover all these needs Displayed field: AccountName id: AccountId Account uniquename: [Account].[CoA].&[Code] Can someone help me out Regards Stefan

Hi Stefan, Please refer to http://msdn.microsoft.com/en-us/library/dd207040.aspx to use extended field properties to get the field data. For example, Value Object Specifies the data value of the field. IsMissing Boolean Indicates whether the field was found in the resulting data set. UniqueName String Returns the fully qualified name of a level. For example, the UniqueName value for an employee might be [Employee].[Employee Department].[Department].&[Sales].&[North American Sales Manager].&[272]. BackgroundColor String Returns the background color defined in the database for the field. Color String Returns the foreground color defined in the database for the item. FontFamily String Returns the name of the font defined in the database for the item. FontSize String Returns the point size of the font defined in the database for the item. FontWeight String Returns the weight of the font defined in the database for the item. FontStyle String Returns the style of the font defined in the database for the item. TextDecoration String Returns special text formatting defined in the database for the item. FormattedValue String Returns a formatted value for a measure or key figure. For example, the FormattedValue property for Sales Amount Quota returns a currency format like $1,124,400.00. Key Object Returns the key for a level. LevelNumber Integer For parent-child hierarchies, returns the level or dimension number. ParentUniqueName String For parent-child hierarchies, returns a fully qualified name of the parent level. thanks, Jerry