TM1 Forum

I have 1 server each on 3 different admin hosts. They represent a DEV server, UAT server, and a PROD server. In order to update each environment it requires us to stop the services, copy the "background files", and restart the services. But the issue that I have is it overwrites the data on any cubes that have been updated. An example is we have a process that loads actual Production data from the G/L to a cube to compare against budget. That cube is overwritten when PROD is updated from UAT. So what I want to do is dump all of the data in the cube to a text file and then reload that data once the update is done. The first question is, is there something that I am missing and we should be updating it another way? The second is, what kind of process do I need to create in order to acheive this? I have found instructions for a cube that only has 2 dimensions but ther one that I have has 6 dimensions.

Thanks in advance.

It sounds like there is something wrong with your promotion process or maybe your understanding of what a DEV > TEST > PROD promotion process should involve for a TM1 database?

It would be highly unusual to be promoting data. Unless you are promoting a new cube or the structure of a cube has changed in some fundamental ways you would never normally include a cube file in a promotion. Rules yes, processes certainly, views and subsets sure, dimension structure for manually maintained dimensions of course, but data?

If you don't want your cube data on PROD to be overwritten then the answer is simple, don't promote the .cub files!

Thanks for the response. We are realatively new to TM1 still and are still creating these new processes. This is definitely a lot of help.