TM1 Simple Replicate

[Ricky Marwan]

Replicate cubes, rules and other TM1 Objects from development to production?

TM1 Simple Replicate

tm1 simple replicate.JPG (28.34 KiB) Viewed 26649 times

Tested with TM1 9.4.1 and 10.1.

Read ReadMe.txt for installation instruction

TM1 Simple Replicate.rar

TM1 Simple Replicate 2.0

(128.88 KiB) Downloaded 1678 times

[Ricky Marwan]

Latest version..

Tested using TM1 10.1

[JDLove]

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 !

[David Usherwood]

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.

[Ricky Marwan]

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.

[lotsaram]

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?

[Ricky Marwan]

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

[Paul Segal]

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

[Ricky Marwan]

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.

[Ricky Marwan]

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

[mw20000]

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

[Ricky Marwan]

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

[Olivier]

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

[Ricky Marwan]

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

[Olivier]

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

[mw20000]

Ricky, great tool. I really like!! Thanks

[David Usherwood]

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.

[Ricky Marwan]

Good to hear that the tool useful out there

[iansdigby]

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

[abcuser]

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?