Dynamic Alias?

[Willi]

Hello,

I inherited an old model where the main-cube has a bad design in my opinion. The cube has 5 dimensions:

- Year
- Company
- Position
- Version
- Measure

"Year" contains just the years and Company the Hirachy of the Company with the Departements etc. "Version" contains names of Versions like "Plan", "Budget", "Approved", ... and MEasures some Measures.

My Problem is the Dimension Position where some Information of the other dimensions are doubled. The Element-Names have the following structure:

Code: Select all

304-2015
    Sammelposten (304-2015)
        304-2015-GWG
    <kein Projekt> (304-2015)
        304-2015-001
        304-2015-002
        304-2015-003
    Zugänge < 10 TEUR (ohne Behälter/Container) (304-2015)
        304-2015-050
        304-2015-055
        304-2015-062
    Budget Jade Stahl (304-2015)
        304-2015-063
        304-2015-066
        304-2015-067
    Behälter, Container, Mulden WHV (304-2015)
        304-2015-072
        304-2015-085
    Behälter, Container, Mulden Rostock (304-2015)
        304-2015-082
    Budget Jade Stahl - Übertrag aus 2014 (304-2015)
        304-2015-086

Where "304" is an element of "Company" and "2015" an element of "Year". The structure differs from comany to Company and from year to year. The 3-digit-numbers are just numbers to differ the elements. There are also alias-names to make it more human-readable.

I Need a hint how I can remodel the cube. If I'm honest I have no idea how I can manage the different alias-names and sructures.

Thanks and regards

[paulsimon]

It looks like someone was trying to represent alternate hierarchies for different years. Sometimes it's necessary. It depends what the client wants. Most clients when they think about it are happy to just have the current hierarchy and to save a copy of the cube directory at year end for the auditors.

Regards

Paul Simon