TM1 Forum

I'm a novice in TM-1 so don't be strict of my question.

I have a cube where data are calculated using rules. I want to save these data in purpose to move the cube with them to another server using replication. So can you help me with methods to save data.

When I replicate cube with rules I receive empty cube to another server.

One way which works is Save the copy of the cube with rules using TI and replicate the copy to another server. May be you can hint me simplier ways of saving data from cube with rules?

Hello there,

I'll try to help you but, I'm a novice who had to learn TM1 without training in one month AND my english is not perfect so I hope I can at last give you some ideas :]

I don't know anything about Replications, but you can create a process to export data to text files (.cma, .csv, .txt, etc...) there are 2 ways to do it:

TextOutput
and
AsciiOutput

Don't forget to create the view to be exported IN THE TURBOINTEGRATOR and clear the checkboxes "SKIP CALCULATED ITEMS" and "SUPRESS ZERO/BLANK VALUES"

Using the file you can make a process on TM1 to Import everything, creating the dimensions, the cube and copying the data. I really don't know how to EXPORT rules, BUT in the data files folder of your application you can find the .rux file and it can be imported the name of the file is the name of the cube with format .rux

I hope I could help.

See you.

EP_explorer wrote:When I replicate cube with rules I receive empty cube to another server.

In that case you didn't replicate everything that needed to be replicated. Where is the original data the rule calculations are based on? Is it in the same cube or a different one?. If the data is in the same cube it will be copied during the replication process. If it is in another cube, i.e., your rules pull it in via DB formula, then you have to replicate the source cube too.

...and ensure the rules for each cube are also replicated, unless you wish to maintain them seperatly in the destination server.