TM1 Forum

Hi :) REQUIREMENT: BULK COPY FROM ONE NORMAL EXCEL TO TM1 TEMPLATE EXCEL WHICH INTURN SHOULD SAVE IN TM1 DATABASE . Below pasted code (from bihint site) creates a macro command bar "TM1 freeze" and deletes all tm1 formulae but can anyone help me in modifying or completing this code such th...

Hi all, Thank you for this nice forum. Even though I am a pretty new to TM1 and most of the information here is very advanced for me, I have learned a little bit by reading various topics. My question is, can anyone point me to a guide or tutorial that explains how to upload data into a cube with a...

It can't calculate what it doesn't have :) A + B = C. If A and B are both zero, TM1 will ignore the rule because it knows it has nothing to do. If you put data back in to A or B then it should look and behave like normal again :) Ohhh ! Steve there you are :idea: its workin now. Thanx (Steve & ...

I suggest you check what your setting in your tm1p.ini file is; see whether AdvancedRulesEditor=T is in there. If it's not, add it in and see whether it makes a difference. If that doesn't work try setting it to F instead of T and see whether you at least get the "Classic" Rules editor to...

I suggest you check what your setting in your tm1p.ini file is; see whether AdvancedRulesEditor=T is in there. If it's not, add it in and see whether it makes a difference. If that doesn't work try setting it to F instead of T and see whether you at least get the "Classic" Rules editor to...

Reddy The rules themselves do not vanish. According to me, what happens is that the code clears cells, that are input cells to other cells calculated with rules. Hence, the rules could return 0, or the cells are not fed. Wim Hi Wim Before executing the TI process, I see the element values are rule ...

Alan, answering to your first question, I did not get any error message while opening the rules editor, when I try to open the rules editor, it remains idle without any error message.

Hi Alan

I see some error messages (pls find attachment) but no error messages logged with todays date.

Hi My machine is pre-installed with .net framework (versions 1.1, 2.0 SP1 etc) and I have also successfully installed Applix 9.1 SP2 as a stand alone application (TM1 perspectives). In tm1 server explorer, I can perform all operations other than opening a rules editor. I tried second time by re-inst...

Reddy, beware that Wim's code will clear out the entirety of each cube except for control cubes! You probably don't want to do this in practice. Depending on the cube(s) you are clearing you can use TI to build quite specific subsets/views to clear out only what you want. You could also use an attr...

Thank You Wim and Lotsaram :) First I copied codes given by Wim in Prolog and epilog procedures and executed the process without any modification, then almost all the data is cleared except some data here and there but then I ran a new process with Lotsaram codes in prolog procedure which resulted i...

Thank You Wim and Lotsaram :) First I copied codes given by Wim in Prolog and epilog procedures and executed the process without any modification, then almost all the data is cleared except some data here and there but then I ran a new process with Lotsaram codes in prolog procedure which resulted i...

Thanks Steve :D This has solved my problem, now I can initialize the entire db 'as and when required' by simply running a single TI process (though only one view can be initialized in one command like ('cube1', 'view1'), but can include one more line for another view as this is far better job than m...

Hi, My TM1 system is loaded with data for around 40 cubes, is there a way to clear or initialize the data in all these cubes by writing and executing a 'single' TI process. It is little laborious to do manually one by one in each cube using data spreading method "clear" . Thanks in advance...

Thanks Alan, highly appreciated .

Hi, Sorry, I have a very basic question which needs your knowledge; I hav an excel template (input) which is sliced from TM1, when I tried to copy values from one source to this sliced template sheet all the DBRW formulae are overridden with these values hence values are not updated in the cube. But...

Hi Iseak,

Assuming "Delete" is disabled, how about choosing "Clear" option from TM1 data spreading methods (by clicking the icon "Clear" from toolbar).

Thanks
Reddy

Hi, Appreciate your possible solutions for this below mentioned requirement: TM1 version:9.0; Excel:2003; There are 3 different users namely U1, U2 and U3 can log into TM1 server. Each User are assigned with their respective accounts (Account dim: A1, A2, A3, A4..A10 are elements in account dim)So, ...