Share Your Knowledge!

Come and get involved, Build a reputation and Contribute to the shape of TM1 Development Internationally – Become a TM1 Tutorials Blog Contributor!

For a limited time TM1 Tutorials is accepting contributors able to post quality and informative TM1-centric articles into the Team. So if your good with Implementation, Technical Tips and Tricks, Administration or Project Management in relation to TM1 we want to hear from you.

Note: You can apply by commenting using the form below, Please include a link to a sample article. We will not make your comments public.


  1. arun says:

    Do we have the time-based partitioning cube option in TM1 as similar to Transformer. I have a table with 360 million records (fact_revenue). I would like to create MULTIPLE REVENUE MONTH CUBES. what is the approach for this? Architect or Cognos Insight was not able to handle the load. Could you please help me on this?

  2. Greetings from the UK. A team of Cognos trainers are promoting a Cognos training site where articles can be shared. Been following TM1tutorials for a while , so would be keen with your permission to embed the TM1tutorials link on our website for users to access.

    Many Thanks


  3. Narendar says:

    Hi, I have TM1 10.2 FP1 environment. Also installed BI package connector 10.2.

    Not able to connect to BI package from Architect. Authentication namespace is blank when I select ‘Package’ in TI process.

    Not sure, If any configuration required apart from Package connector configuration.

    Appreciate your help.

  4. nguyendieu says:

    Hi All,

    – I have application Approval, contain 4 cubes. I am input data on 2014 year. When I submit level, then data in all year lock.
    I can’t input data in 2015 year.
    – I am want when i submit, data lock only in 2014 year.

    Could you please help me ?
    Thank you.

  5. Shasi says:

    Hi All,
    how to login tm1 application web with mutliple sessions and multiple servers in IE 10 Browser,as i am getting logout automatically for other sessions.

    how to set the cookies to solve the problem automatically?

  6. Please note that I need your expert advice.

    I just created new parameters for a client, company structure, account structure, form structure, building up my balance sheet and P&L format, defining layouts and also imported the data on the client’s Excel Environment to Cognos where I got a message saying ““All xxx values were successfully exported and the data has been saved”.

    But when am going in Group/Reports/Trial Balance Drill Down, when its asking me to select the Group, nothing is appearing and its stating “Group Missing”- how can that be according to you? I checked my group structure and also verified the company structure and no error message found.

    Am a bit lost as until this is resolved, am not able to either extract my TrialBalance, nor generate my Consolidated BSheet and P&L.

    Can you guide me and assist me thru’ this please.

    Thanks in advance for all your efforts and time.

    Look forward to hear from you soon.

    Warm regards

  7. Ian Digby says:

    It doesn’t appear in the TM1 documentation but, to get values in a cube to align in an accounting style, with negative numbers aligned correctly, you can use this custom Excel format:


    It works fine in TM1.

  8. TK says:

    I have been working on trying to move data from TM1 to a SQL server database. The process runs successfully, however the only data that shows up in the SQL table are numerics. I cannot get any string data to show up in the SQL table. Here is a look at my Advanced Data Tab.

    IF(Appian_m @=’Region Code’);

    ODBCOutput(DSN, ‘INSERT INTO dbo.EV_APPIAN ([dimension_1_number], [exportvalue_region]) VALUES ( ”’ | APC_Line | ”’ , ”’ | Value | ”’ ) ‘ );


    The only thing I can think of is there must be an issue with the syntax. It is only a 2 dimensional cube and there is no numeric data in the measure dimension. Please provide any knowledge you might have on this issue or topic. Thanks.

Leave a Reply

Your email address will not be published. Required fields are marked *