TM1 Forum

suceeded to restore by changing the name,
thanks for great explanation

try this:
http://www-01.ibm.com/support/docview.w ... wg21608271

Hi,

Today I've opened tm1 model and noticed that one of the cubes was disappeared,
I looked in data directory and saw the the cube file (cube_name.cub$),
I know that extension with "$" in an error, how can I recover it?
why it happened?

Thanks

it works, I guess I tried to register the file in the wrong path

Hi,

Im trying to open tm1p.xla as usual and "automation error" message pop up, tried to use ibm solutions like register mscomctl.ocx

but with no success, does anyone know this error?

thanks

Hi, just to inform you the action I choose, "viewconstruct" in ti consuming lots of memory and therefore cant run on big cube in 9.5.2 version, one of the IBM solution is to update version, I developed a VB code which connecting to tm1 and openning all users heavy excel files one by one, t...

Hi All, the users are openning tm1 model via the terminal server, when one of the users is trying to open tm1 appliccation, he is getting "error accessing the system registry" - visual basic message This user is a part of users group in the terminal server and the all other users which on ...

Hi, I have 38 giga of ram in my server and the available ram before launching the process is something like 20-25 giga, when the process is running there is still enough ram available but the cpu reaches 100%, maybe there is a way to split the cpu consumption to several processors (there is 8). when...

Hi, I have a big cube in my model and it takes 3 min to calculate a view for the first time, therfore I'm trying to store stargates views on memory, I tried to use "viewconstruct" function in the ti but it failed on memory (I get WARN mesaage - OUT OF MEMORY in the message log), I tried to...

must do it in process,
create a view -->need to accumulate the values for the desired intersaction with cell get and cell put, for example:
vtotal = cellgetn(from source cube/view)+vtotal
cellputn(vtotal, target cube),
then you will have the total for each category,

good luck,

Hi, Im using office 2007, tm1 9.5.1 version, when I opening an excel file from application (not as reference) it opened with generic name like TM1A.xlsx, TM12.xlsx etc, the users complains about it, they got confused when many files are opened, can't it open with the real name and not with the gener...

finally I found a solution,
I've created excel file which reads data from the csv file (in excel tool bar-->data-->text) and refreshing in openning,
not ideal solution but it works.

it's off

thanks

Hi, I have 2 tm1 files (excel environment), the first file is a big file with lots of sheets and second file is small csv file, when Im openning the csv file (and the first file is already opened) it trying to calculate the first file, it seeems that openning csv file affect on the excel calculation...

Thanks for your reply, I will explain myself again.. when you allocating pick list to some intersection it can takes a long time to open the list if there are lots of members inside (the picklist is period dimension, there are hundrands of elements in this dimension), the strength of the picklist is...

Hi All, I cancelled the pick list rule in one of the elements (date) and now this intersection is not restricted by list - I cancelled it because it takes time to refresh the list evertime, however I want to restrict it (not by list), if a user will insert wrong value I want him to get an error mess...

I have to run process after the calculation but it's a nice solution,
thanks

the calculate via action button is becoming slower when other excel files are open

Im trying to run a process via action button, in calculate tab (action button) I choose "automatically recalculate sheet", it seems that
it trying to calculate the all workbook and it takes long time, does someone know this issue?
thanks,
Yuval