TM1 Forum

Hello all

I need to export data from 2 cubes on the same file.
I used 2 TI processes with ASCIIOuput to export data from my 2 cubes but I get 2 files.

Is there a way to feed an existing file with ASCIIOuput ? Or concatenate 2 files in TI process ?

Thank you for your help.

StoneDX

Thank you Steve for your clear answer.
I'm going to try with your idea.

Thank you again

Hello to all My users wants to have access to their TI ProcessLog files, but ITs don't want them to have access to other logs such as TM1s.log Do you know a way to do it ? I tried using LoggingMessage in TM1.cfg, but it set all logs directory, not only ProcessLog. Maybe I should add some lines on al...

Thank you belair22 for your response. I understand what you mean, but I think I don't explain very well what I want (sorry, i am not an native english speaker). What I want is to have on my TotalYear element the last non zero month of my accounts which have the 'stock' value on their 'type' attribut...

Hello, I have to use stock accounts (ie : amounts of money) in a TM1 cube but I don't really know how to aggregate them on TotalYear. The only way I found is to use a numeric attribute on my Period dimension called 'CurrentMonth'. On this attribute I put 1 on the CurrentMonth, then I can calculate T...

I found why it was so long.

Execution plans in TM1 are not the same than in SQL Server.
That's why my SQL requests were so long in TM1 and not in SQL Server.

Have to work now to optimize my SQL requests

Thank you.

Hello, I am currently working on dimensions using TI with ODBC SQL query on a SQL Server Database. My problem is that all my requests on TI are extremely long compared with SQL query directly on the database. For example my 20 seconds query becomes more than an hour on TI. I don't really understand ...