Dimension Reorder Deletes Data

Post Reply
User avatar
George Regateiro
MVP
Posts: 326
Joined: Fri May 16, 2008 3:35 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2007 SP3
Location: Tampa FL USA

Dimension Reorder Deletes Data

Post by George Regateiro »

I just ran across this on 9.4 MR1 FP1.

I was reordering dimensions in our test system. I knew the order that I wanted, since I went through it in dev, so I changed the order and clicked ok. When I went and checked the cube I got no data. After researching I realized that this is a cube that was set to load on demand. I restored everything and tried it again watching the file system with the following results

1) Starting size 104 meg
2) Reorg without a Test
3) Save Data
4) New Size on File System 3 meg

When I tried it again, but with calculating a view before I started, everything went as expected. I did not notice anything in the docs that warned against reorging cubes that were load on demand. I thought at worst TM1 would have loaded the data as a result of doing the reorg. Has this been experienced by anyone before?
User avatar
George Regateiro
MVP
Posts: 326
Joined: Fri May 16, 2008 3:35 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2007 SP3
Location: Tampa FL USA

Re: Dimension Reorder Deletes Data

Post by George Regateiro »

I just heard from support and this is an issue that is supposedly fix in 9.5.
Post Reply