TM1 Forum

Replicate cubes, rules and other TM1 Objects from development to production?
Tested with TM1 9.4.1 and 10.1.

Read ReadMe.txt for installation instruction

Latest version..

Tested using TM1 10.1

Hi Ricky,

Thanks for providing these tools, I downloaded and installed the TM1 Simple Replicate and it works as I expected.
I can see the ease of transferring files between servers as being very handy for consultants and developers, very simple and no need to bring a server down it seems.

I guess you need to be very careful and know what you are doing, but in the right hands and in a managed process this really does help.

Keep em coming !

Still yet to test fully, but at first glance I was pretty happy with it !

Just tried this out. Some feedback:
a Suggest you add a readme.txt explaining that the server settings are changed via the File menu
b Although you have a pair of path settings in the config setting for the bin and the api folders, I think the exe file expects both to be in the
default install (the parameter is greyed out) - and mine is on the d: drive.
Thus I'm stuck at present.
Looks a good idea though, given what a pain object transfer normally is.

David,

Thanks for your feedback.

Updated with readme.txt and run.bat inside archive file

Path setting in Properties window still grayed out, ignore this.

Hi Ricky, we are using Vizier for object promotion and syncing between servers. I'm wondering does your tool also use the replication API? The Vizier sync has 2 limitations 1/ it doesn't allow for control objects which is annoying when there are drill processes and cubes to sync and 2/ it doesn't allow for syncing of cube data, only cube structure (with the exception of attribute values). How does your tool handle this?

Hi Lotsa,

Not using replication API. 1/ haven't test the tool to sync control cubes myself, my goal only need to sync cube data such as }ClientGroups or }CubeSecurity. looking to add sync security feature in future but not urgently needed for now. 2/ Syncing cube data, simply by extracting cube data with skip zeroes, rule and consolidated values followed by standard cellputn to destination cube. Same logic for others retrieve all objects from left server and put on right server

Hi Ricky,

I've tested this, and it seems to work fine - and a very handy tool. What would be useful (at least from my point of view) would be to have a "star" and "planet" configuration, where you could synch from the "star" to several "planets".

Regards

Paul

Hi Paul,

Good idea!
What comes in mind is having multiple server config and able to select server to sync. will update in next release.

New Version 2.0

Added new features:
~ Star to Planet selection
~ Sync Client Groups with limitation only Client without password
~ Sync Cube Security Assignments
~ Sync Dimension Security Assignments
~ Sync Process Security Assignments

nice tool, i want to try it, but cannot select CAM or integrated authentication. What do I have to do to turn it on?

Sorry, currently only supported for basic connection.
I can turn it on but i don't have any servers using CAM security to test the connection.

So, come back in near future

Hi Ricky,

I just had a chance to test this promising application for promotion between servers.

I have some success in moving objects around but I stumped on this particular error several times.
( see attachment).

I believe I have set up everything as indicated in the text file.

Any idea why this occur ?

Thank you,

Kind Regards,
Olivier

Hi Olivier,

Which TM1 version you use?

You may check tm1api.h for function
TM1DimensionAttributesGet( TM1P hPool, TM1V hDimension );

It shouldn't be a problem if function exists, did a test with TM1 version 9.4, 9.5.2 and 10.1

Hi Ricky,

Thanks for the feedback.
I checked the function and it was not there in my tm1api.h file.

The 9.4MR1 client I was testing with was not updated with FP3 / HF12...

I checked again after updating the client and the function is now referenced.

I will do some more tests on promotions and post if any issue.

Thanks again.

Kind Regards,
Olivier

Ricky, great tool. I really like!! Thanks

Just to record that I have been testing out using TM1 on Ubuntu -see
http://www.tm1forum.com/viewtopic.php?f=3&t=8222
and found that copying a Windows-based server failed because of case sensitivity. IBM advise using TM1XFER, but ( ) don't actually appear to supply it with the main installs! So I had an idea and used your tool instead - which worked rather well (admittedly on quite a small server). Thanks.

Good to hear that the tool useful out there

How does he do it? I didn't even realise that processes could be copied/replicated in that way. A masterful performance Mr Marwan!

Both of my TM1 servers (test and production) are using Cognos BI integrated security. So is there a plan to support CAM in this application?