TM1 Forum

Hello, Please help if you can. I have data in a source data in operating unit#555 and team #12222 that I would like to transfer to a target data in operating unit#802 and team #14444 in attached sample. I been doing this by first zeroing out source data then using DBSend to load to target ( a pain t...

From your posts it sounds like you are using Perspectives. Have you not heard of the Print Report functionality in Perspectives that can take a report and generate either a PDF or range-valued Excel file out of it? Hello Tomok, With the print report features in TM1 and PAX , I would still end up wi...

Hi, I was thinking in the lines of not having to paste values to begin with. What if we send out an ad hoc excel file (not a snapshot) , the receipient opens file, the macro run in background to values formulas, then the recripient makes changes to file and send it back to us for corrections? but no...

Thank You paulsimon. I'm referring to Ad-hoc Excel spreasheet files on desktops and laptops, not TM1 cubes/views that can be exported as in inspreadsheet browser..so option 1 or 3 would not work. I'm sure everyone here knows the PAIN of having to save many files on a daily /weekly basis as paste val...

Any update on how to get around not having to paste values every excel workbook we send out that contains TM1 formulas? This happens who user open files they see *KEY_ERR error. What are the latest options below or other optiond?: 1) Use existing VBA macros? some end users don't like to use macros o...

Hello All, I know this an old post but any update on how to get around not having to paste values every excel workbook we send out that contains TM1 formulas? What are the latest options below or other optiond?: 1) Use existing VBA macros? some end users don't like to use macros or click on macro bu...

DBS, DBSS, DBSW formulas are a bit of a hanglover from the 80s & 90s. Back in the days when TM1 didn't have any ETL capability this was the only way to send data to the TM1 database. These days they aren't used that much. Why is TM1 using the F9 to send? the F9 serves its own purposes and that ...

Some people like in this thread below would put data in one excel sheet tab and DB formulas in separate sheet tab with if statements, if yes, then send to DB. http://www.tm1forum.com/viewtopic.php?t=9317 But isn't this a headache? What if you have 20 divisions? you would have to duplicate each divis...

Jean, DBRW formulas on their own will not write data to a cube. Not in manual calc mode, not in automatic calc mode. So it has to be the case that you or the user enters a value over a DBRW. Or do you use a DBS function ? A DBRW formula will only show what is currently in the cube, if you do not en...

Hello. Help. I accidentally wrote to TM1 database when my excel file containing DBRW functions was simply opened to review. Currently , unless I manually tell Excel to not automatic calculate, when I open a file, it writes to database if DBrw functions exist. Or if you have many files open and meant...