One Dimension - Several Hierarchies - For each hierarchy an own UNKNOWNMEMBER name

Hi,

it is possible to set for each hierarchy, of them that belongs

to one dimension, different names for the Unknown Member?

Perhaps under calculation tab for each cube?

How wuold be here the right syntax?

Thank you in advanced,

Mastroyani

Unfortunately not, as far as I know. If you really need this you should probably handle the missing members in your ETL and assign them different names there. There are several dimension properties which I'd like to see made attribute properties; the AttributeAllMemberName property is another one:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=144234

Chris

|||Thank you!

One Date Hierarchy - In several cubes, but with different captions

How I can model cubes that use one hierarchy, but

for each cube I want determine an own caption (AS2005).

How I can realize it?

Thank you in advanced for your answers.

Have you checked the translations tab in the dimension editor in BI-Dev Studio?

You can laso add columns to your dimension table in the RDBMS or in the data source view(named calculation) and make this additional rows member properties of dimension key or user hierarchy level attribute.

You will need a tool that supports translations or the change of a member name to an alternative member property. Excel 2007 and ProClarity Professional 6.2 also show member properties as information boxes when you put the cursor on a member.

HTH

Thomas Ivarsson