COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => TM1 => Topic started by: krishnadixit on 12 Nov 2011 07:42:31 AM

Title: Edit TM1 Cube Structure!!! (Add Dimension, Delete Dimension, Replace Dimension)
Post by: krishnadixit on 12 Nov 2011 07:42:31 AM
Hi again CMPians,

Firstly Thanks for such great & valuable feedbacks on my last release i.e. "TM-One DoKumentor" a TM1 documenter tool.

My aim is to provide those features in my tools, which TM1 has not at all provided / directly provided.

Let us dig it further. During initial stages of development, a developer may frequenty need to redesign, recreate, or edit the model design. Sometimes the add-on requirement compels developer to add dimension, delete dimension, or replace dimension in existing cube. Sometimes its necessary to replicate cube or rename the cube for some reason. Above all requirements can be easily be fulfilled if the Model is to be developed in Cognos Planning (Analyst). But what to do in TM1? as TM1 is does not allow to edit the Cube structure. But on the other hand TM1 has provided the indirect way to achieve it, "TI Process".

So here I am providing 6 TI processes that might be useful to you. They are as follows:

1.  util_Cube_DataExport  :- This process exports all the data of mentioned cube in .csv file named with cubeName & save it in Server Directory.

2.  util_Cube_Rename (Rename the TM1 Cube) :- This process renames the mentioned cube with your desired cube name.

3.  util_Cube_Replicate (Replicate the TM1 Cube) :-  This process replicates the mentioned cube with data in it. It also, optionally, attaches rules that the source cube has.

4.  util_Dimension_Add (Add dimension to TM1 Cube) :- This process initially takes backup of exisiting mentioned cube, then adds desired dimension to the cube.

5.  util_Dimension_Delete (Delete dimension from TM1 Cube) :- This process initially takes backup of exisiting mentioned cube, then deletes desired dimension from the cube.

6.  util_Dimension_Replace (Replace dimension in TM1 Cube) :- This process initially takes backup of exisiting mentioned cube, then replaces desired dimension with the mentioned dimension in the cube.

WARNING
1.  Above process (2 to 6) are advisied to use with utmost care, should be used in initial stage of the development. Using those carelessly on Stable model might result in unstability of the model.
2.  Editing the structure of cube in any manner might result in data loss in other cube(s) if any other cube(s) is/are depending on the cube that is being edited. Please check for dependency of rules & feeders.

I hope these TI Process might help you. You can download those from
https://docs.google.com/open?id=0B4NN6xSIeeBPYzM3Mzg3YWYtOTY3Mi00MTY5LTg5MTMtOTU4M2U0MjQ2NDUy (https://docs.google.com/open?id=0B4NN6xSIeeBPYzM3Mzg3YWYtOTY3Mi00MTY5LTg5MTMtOTU4M2U0MjQ2NDUy)
or
http://www.mediafire.com/?xg7vl4c3gde27aa (http://www.mediafire.com/?xg7vl4c3gde27aa)
or
https://rapidshare.com/files/2107771453/Utility_TI_Processes.rar (https://rapidshare.com/files/2107771453/Utility_TI_Processes.rar)

Download the rar file & extract the TI process files (.pro) in your TM1 Data Server Directory & restart the server (just restart the Data server & not the TM1 Server).


Please give me your feedback. If there is anything that you are thinking to do in TM1 & its not available TM1 then do let me know. Let us see if we can do anything about it. I will definitely give a try on it.

In case if you have not tried my previous tool i.e. TM1 Documentor, you can download it from:-
https://docs.google.com/open?id=0B4NN6xSIeeBPMWVlZDdkZjAtNmM5ZC00ZDg5LTk5ZGQtNDczOWEyNzZhNTM3 (https://docs.google.com/open?id=0B4NN6xSIeeBPMWVlZDdkZjAtNmM5ZC00ZDg5LTk5ZGQtNDczOWEyNzZhNTM3)
or
http://www.mediafire.com/file/dmnd5lf71d5xnvg/TM-One_DoKumentor1.01.rar (http://www.mediafire.com/file/dmnd5lf71d5xnvg/TM-One_DoKumentor1.01.rar)
Title: Re: Edit TM1 Cube Structure!!! (Add Dimension, Delete Dimension, Replace Dimension)
Post by: OLAPBPMguy on 14 Nov 2011 06:09:20 AM
Hi Krishna,

Great initiative!  To save from re-inventing the wheel you should check out bedrocktm1.org where I am pretty sure these tools already exist but in a slightly more advanced form.