Dimension changing in Time

[Motyl]

Hi

I have problem,
There is cube Cube1 that cotnains 3 dimensions:
dim1 is static
dim2 is static
dim3 can change in time.
How to keep historical structure's of dim3 in Cube1?

[jim wood]

A couple of ways that you do this:

1) Use a set of TI processes to create an archive version of cube, data and dimensions. Only really possible with small cubes.
2) Use a TI to create an alternate hierarchy within the moving dimension date stamped. (Every parent)
3) Keep the historic data in DB and just TM1 for the latest and greatest picture.

My recommendtion is option 3,

Jim.