TM1 Forum

Hi Tomok, Thanks for your hints. But I don't understand the logic in your code very well. Your feeder will do: Feed current month of ['A'] to current month of ['B'] Then feed the current month of ['A'] to next month of ['B']. ['A','01'] => ['B','01']; ['A','01'] => ['B','02']; ['A','02'] => ['B','02...

Hi Declan, Sorry, I didn't describe the complete situation. There is a rule for this issue, following the feeder. Rule: ['B'] = N:DB('A',AttrS(..,'Month')); Feeder: ['A','01'] => ['B']; ['A','02'] => ['B']; ... Now we want to change the Rule/Feeder, that with the condition that if previous month has...

Hi declanr, Thanks for your detailed explanation. It sounds that [..., {'02','03'}, ...]=>DB(...) won't meet my requirement. May I use the workaround that not using feeders, instead, using normal Rules to solve my problem: DB(...) = N: if (DB[..., {'02'}, ...]@<>0,DB[..., {'02'}, ...],DB[..., {'03'}...

Hi tomok, Thanks for your reply. Do you mean if I write the feeder as: [..., {'02','03'}, ...]=>DB(...) It will feed one of these two month, which has the number. And if the both month has numbers (the two numbers might be different), feeder will choose the number in the first month. Is it correct? ...

Hi ioscat, Thanks for your reply. I only want to feed the number from one month. If there is a number in previous month, then feed it. Otherwise, feed the current month. So there should be one condition to decide which month to feed. Could you please tell me how to write such condition? Best regards...

Hi all, I need your help to modify the Rules in our TM1 system, it is under feeders: ['dim1_elem1', 'dim2_elem1','dim3_elem1', 'final', {'PR01-1601','PR01-1602','PR01-1603','PR01-1604','PR01-1605','PR01-1606'}, '03', {'FC1','FC2','FC3', 'FC4','FC5', 'FC6', 'FC7', 'FC8','FC9', 'FC10', 'FC11', 'FC12'}...

Hi Alan, Thanks for you reply. The backgroud for my question is that we need to copy the subset of the cube to the other subset of the same cube. Say, cube O, dimension A, we want to copy A->elem1 to A->elem2. But there are some figures in A->elem2 subset. These figures should be deleted before copy...

Admin Edit: Split from this thread since it's more in the nature of a general query than an enhancement request. Hi Alan, Your reply for CellsUpdateable is intersting. Now I met the same problem here: ElseIf ( l_Writeable = 0); # Bang user on head with frying pan and tell them to stop trying to wri...

Hi all,

Could you please recommend me some good tools, which can help the TM1 development? Currently I am working directly on Cognos TM1 9.4. The user interface is not so friendly. Especially Rules editor and TI editor.

Thanks.

LP_user

Hi tomok, Thanks for your reply. I used your steps to do the copy. It works! Now the Dev and Prod have the same figures. The difference between your method and mine is that "Run SaveDataAll on Dev". I don't understand your comment "this is to get rid of any open log items". What ...

I agree that from last night until this morning when I did copying, there might be something being changed. But I saw there is big difference. And I tried 3 times the same copy procedure since last week. There is always same big difference between prod and dev. I really checked very details in the c...

The SaveDataAll process will run in prod nightly. You are right. I didn't run SaveDataAll explicitely when doing copy. But at least, I copied the data from last night. Is it correct?

Dear all, I met very strange problem. We have two TM1 systems, one is production, one is development. I want to copy prod to dev so that dev is same as prod. So I just do the following steps: 1. stop TM1 service in dev server. 2. copy the whole TM1 folder from prod server, to dev server 3. start TM1...

Hi Alan, As I said in my last post, the VBA code sets the fixed path to access TM1 Excel Add-in. But different user has his own TM1 install path. I just changed the path to my TM1 install path. And the excel file worked for me at the moment. But if other user wants to use this excel file to get info...

Hi Alan,

Thanks for your reply. I checked the VBA code again, and found it assigned the wrong path to TM1 add-in. That is why not connecting to TM1 server. And the error message is not standard message. Instead, it is our own VBA code.

Best,

LP_user

Dear all, The former developer created one excel file, which uses VBA to draw one button in the excel sheet. Click this button will call some TI process in our TM1 server, and show the result in the excel sheet. I got the excel file. But when I click the button, there is error message: Please check ...

Thanks for all replies. Through the discussion, the problem is clear. Yes, my question is to change N element to C element, the data is lost. In conclusion, the solution is do the snapshot of the server folder to backup the data, before changing the dimension structure. How does a good TM1 system do...

Dear Cognos TM1 users, I have one general question about the concept of cube and dimension. The data of the cube will be lost when changing the structure of dimension. How to prevent it? Here is one example: product dimension has the following structure: product--red(r1,r2,r3) --blue(b1,b2,b3) --gre...

Hi declanr, Thanks for your answer. It is good idea to write one TI process to control the chore job. Could you please give me the code example how to justify if the "NOW" is the last day of the month? With best regards, LP_user Presumably you mean that you want a chore to run on the last ...

Hi,

I want to schedule one chore job monthly. But TM1 doesn't support schedule monthly. How can I do it?

With best regards,

LP_user