Wednesday, March 28, 2012

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

No comments:

Post a Comment