Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only

  • 1.  import Excel file

    Posted 10/07/22 04:32 PM
    Edited by System Admin 01/20/23 04:20 PM
    hi, 

    i have an client who want import excel file to TM1 and even chose what worksheet to import. 

    i just wondering that TM1 work well with excel since beginning with Macro Perspective and they have surely a client who want to import Excel file. 

    But why they dont make that? 

    As i know, TM1 contributor can import Excel file, why not TI ? 

    i found a video on Youtube show they can make something work with TM1 web, any idea how they do it? 

    https://www.youtube.com/watch?v=r2COAA8Rq78

    I just very curious! thanks any help !!

    same post on TM1 forum 
    https://www.tm1forum.com/viewtopic.php?t=16321

    ------------------------------
    Duong DAU
    Consultant EPM Finance Transformation & Performance - Micropole


    M +33 (0)7 62 61 85 33
    F +33 (0) 4 26 99 60 81
    131 Boulevard Stalingrad / 69100 Villeurbanne
    ------------------------------
    #PlanningAnalyticswithWatson


  • 2.  RE: import Excel file

    Posted 10/10/22 05:42 AM
    There are many ways to achieve this, the common challenge is finding a solution that fits within the client infrastructure. 

    You can use any number of tools; excel macros, excel scriptlab/ Microsoft Office API, python, C#, powershell are examples I've seen working and there is nothing stopping you using any number of other programming languages/ tools.

    It's also worth noting how much control you may need on this data, if it's a pure load then the existing data import feature may work for you:

    https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=c-import-data-into-cube

    If you need greater control to load the data then you may find what you need in the TM1 Local Variables where you can set the DataSourceNameforServer and configure the details of the datasource (delimiters, header records etc..)

    https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=tv-turbointegrator-local-variables

    ------------------------------
    Edward Stuart
    ------------------------------



  • 3.  RE: import Excel file

    Posted 10/10/22 05:53 AM
    Thank you Stuart. 

    My client decided to use Talend for replace TM1 

    I dont have so much knowledge about Python, C# and powershell but if i can do something with it, will TM1 can call this from a TI? how? (until now, i just use executecommand to call BAT file)

    Can you give me an exemple of use case? 

    Thank !

    ------------------------------
    Duong DAU
    Consultant EPM Finance Transformation & Performance - Micropole


    M +33 (0)7 62 61 85 33
    F +33 (0) 4 26 99 60 81
    131 Boulevard Stalingrad / 69100 Villeurbanne
    ------------------------------

    Original Message


  • 4.  RE: import Excel file

    Posted 10/11/22 11:49 AM
    Hi Duong

    Look at TM1 ExecuteCommand, you can call any other application or run batch\power shell scripts
    Since many TM1 developers are familiar with VBA\VBS, I recommend an approach using MS ADODB and OLE DB. This way you can work with Excel files without Excel being installed on the server, for instance use SELECT query for your Excel files

    Also if you like cloud technologies (in particular Google Sheets), all this functionality (and much more) is available in TeamOne:

    tm1import
    img




    ------------------------------
    Vlad Didenko
    Founder at Succeedium
    TeamOne Google Sheets add-on for IBM Planning Analytics / TM1
    https://succeedium.com/teamone/
    ------------------------------

    Original Message


Related Content