TM1 Forum

Hi All, I am using TM1 9.5.2. My security mode = 1 in the cfg. I am unable to add a client or group to the database. I get the error that navigation to the webpage was cancel. Somewhere on my desktop(part of installation) I am missing something? Has anyone ever experienced a similar issue? Any help ...

appreciate all the replies.

thank you

I found the solution: ['Stock']=N: DB('Stock Plan',IF(ellev('Date',dimnm('Date',(dimix('Date',!Date)-1))) <>0,dimnm('Date',(dimix('Date',!Date)-2)),dimnm('Date',(dimix('Date',!Date)-1))),!Version,!Depot,!Product,'Stock')+ DB('Stock Plan',IF(ellev('Date',dimnm('Date',(dimix('Date',!Date)-1))) <>0,dim...

Hi, I want to calculate the movement between days. I am using the DIMIX formula and all is working fine. What I picked up now was that for the last day in each month it takes the total for the previous month to do the calculation because for eaxmple Feb 28 dimix = 37 and Total Jan = 36 and and Janua...

Duncan,

Thank you for the reply

My rule was not correct(missed something small), but for some reason 9.5.2 FP 2 didn't mind the error and everything worked. Weird!!

But in Express 10 and TM1 10 I get the error. And there should be an error.

It is fixed now.


Thank you

Hi, Client upgraded from TM1 9.5.2 to Express 10.1 Now I get this error when opening a specific rux file: Dimension "TB Account" is referenced more than once. If I start the model in TM 1 9.5.2 the error is gone. I have done some reading on the forum and it has something to do with the tm1...

that is correct. my mistake. consolidatechildren is the bugger. will never use that again.

thank you

than you

will try that, but I know that this function is very resource intensive.

Hi, I have tried the max function ans read this post: http://www.tm1forum.com/viewtopic.php?f=3&t=4207, but cannot manage to get this working. I upload seconds per item for an invoice. I need to calculate adj seconds. For the adjusted seconds I want to put the maximum seconds per item per invoic...

Hi, I am a real beginner with VB code. I have a VB code in excel to hide rows where values are 0. This works 100% untill I close the sheet and re opens it. I save the sheet as xlsm (macro enabled). When I open the sheet my vb code to hide the rows does not work. It is still there but it does not reb...

Good Morning, I found this on the internet: Print Report function from Perspectives is useful to generate static reports in bulk for a given set of elements. Is it possible to print report from Cognos Express 10 sheets that have VB code in. For each element (employees =280) the employee letter will ...

Hi, If I use the print report function in TM1 9.5.2 I get an Microsoft Visual Basics error. It is a normal excel employee letter that prints to pdf. I have different print jobs loaded. Where I need to print 75 reports I get the error on report 18 for example. If I have a print job for 20 reports I g...

Hi, I have checked for a solution to this on the forum and other websites but cannot seem to find a simple solution. 2 challenges: 1: Is it possible to execute a print report from TI? I have three different types of reports that needs be be printed ( It is employee letters - 280 of them). My thinkin...

thanks for all the replies.

appreciated.

i took out the ConsolidateChildren function and no more issues.

iam now calculating a weighted average cost and not a weighted cost anymore.

thank you

thank you

but is there any way to control the garbage memory?

all the views that the client will open is large calculated views.

any suggestions.

to restart the server every night?

Hallo, I have this issue at a client where the memory increases till where everything hangs. My stats_by_cube = 4.85 GIG Stas_by_server = 21 GIG where the garabage memory equals 16 GIG. I have inputted the Log file to prevent garabage memory to increase above 2 GIG. See below: # # Enable INFO level ...

I managed to sort this out.

thanks

Hi,

I am using TM1 9.5.2.

For some reason I am unable to select the subset for a print report.

When selecting subset icon everytrhing just hangs.

Any suggestions?

Thank You

Hi, I need urgent help with a weighted formula. Currently I am using a ConsolidateChildren to calculate the Weighted Measure. I am aware that this has an impact on the RAM and performance and so does the client by now. I cannot get any way around this. My formulas: ## At an All Activity level it is ...