TM1 Forum

Tm1 Active form... 10.2.2, windows, excel 2013 I have an issue with a user's active form that duplicates rows. It is extremely hard to reproduce as this does not happen often. Once every 50 recalcs I can however 'fake' it by changing the TM1DATARNGx in the named ranges and then rebuild the form. =TM...

We joked that a quick way to smoke out spurious TM1 'experts' at a job interview would be to ask them to demonstrate a keyboard copy-paste in the TI Editor.

Haha we have the same one running here

Thanks gents... Not sure were I would be without this

Totally agree with declanr with his answer. Just to add what we did in terms of a data load. Instead of using the SQL (which when reading this might have been have been better) We added a nightly chore kicking out a asciioutput from each tm1 instances and and the being picked up by the consolidated ...

['Expense'] => DB(IF(ATTRS('ConsolidatedLine', !ConsolidatedLine, 'CapitalPlanningLineName')@=!Capital Projects, 'ConsolidatedFinStmts', ''), 'TM1 Cube', 'Forecast',!Month,!Year,'US',!ConsolidatedLine,'Amount'); !Capital Projects - is that a dimension in the cube? Is 'TM1 Cube' an element or a cube...

The TM1 Application you are referring to, is that in excel sheet/ Cube viewer or TM1 web?

Thanks everyone

@Nick Log files in TM1Web are located here dir\\webapps\tm1web\WEB-INF\logs. using these logs you could point out the last websheet that was the cause of the crash or the last last slice which tipped the server over. Good luck !! Yeah thats where i found that 'once a week' log I was referring to. Fo...

I thought this was the issue and already changed it before i posted the thread. Hoping it will fix the problem. Just thought I would be able to at least find a log file somewhere? I changed it to the recommended 4GB. Is there any way I can track the usages? Is it a number of users hitting it at once...

@Jim Wood I can't really restart the server as we have a worldwide audience - no real system down time. To restart the application server only takes a second so it's not a train smash, but I would just like to be able to monitor it or at least find a logfile that says, ok you ran out of memory. As i...

Gents, Ok running TM1 10.2.2 FP 2. We are running 7 application from the server and mostly use TM1web as the UI. Somewhere during the day (usually once a day). TM1 web stops working (or actually, I have no idea what happens) but users cant log into TM1web anymore. Perspectives/Architect still works ...

Thanks gents the break section worked perfectly!! Its a bit hard coded at the moment, but it works. nCount = 1; nMax = 200; WHILE( nCount <= nMax ); sSNR = Subst(sSeqNumber,1,Scan('_',sSeqNumber))|NumbertoString(ncount); IF(CellGetS('Budget Entry - Information', CellGetS('Global Control','CurrentRep...

I have to add string data to a cube. The code has to do the following - scan through cube, if the combination of location and classification exist on a line item . Then itemskip else, add the string values to the next open line item. The sequence number below is based on the following logic. Each pl...

For anyone reading this who wants to add similar functionality. I added a measures with the name Cost Activity and Cost Function I added a picklist cube to the cube. with the following two rules Cost Function = S:"Subset:Cost_Element"|CellGetS Cost Activity Cost Element= S:"Subset:Cos...

Thank you all for replying... I did manage to figure it out. @Planningdev I ended up using a excel driven, active form/hidden sheet/offset formula.But it has to work in web. So I created a massive lookup sheet. Dynamic subset with all functions as my rows and coulmns with headings 1 -100. I proceede...

Hey, I am using Tm1 10.1.1 Excel 2010 I was hoping to get some assistance. I have a 4 tier Cost Element hierarchy dimension. I have a created a planning input sheet that the user log in to to do planning. Lev 3 All Cost Element Lev 2 Cost Element Activity Lev 1 Cost Element Function Lev 0 Specific C...

@Wim Hello, I know that you can use CellPutProportionalSpread to clear cells in a cube. In fact, I wrote an article about it: http://users.skynet.be/fa436118/wim/tm1 ... ead_EN.htm Does it work when you use the normal way of clearing cells, that is using ViewZeroOut? It worked, I have no idea why - ...

Matt, Thanks for the advice will test tomorrow. #use subset to only filter out the year selected from the input view subsetdeleteallelements('Fiscal Year','TI_Year_Parameter'); subsetelementinsert('Fiscal Year','TI_Year_Parameter',PYear,1); #use subset to only filter out the month selected from the ...

My findings,

I believe the issue was caused by the fact that my .net Framework Manager got corrupted.

After re install of framework manger - and another re install of TM1 fixed the problem.

Regards,

Edward, To assist with responses and getting a resolution please check the request for assistance guidelines: I'm not leaving out any information... I wish I was :( - the reason for the lack of information is the lack of information. Does the process error? The process does not complete, it usually ...