Planning Analytics

 View Only
  • 1.  Export Options TM1/IBM PA - help needed

    Posted Mon October 17, 2022 10:15 AM
    Hello All, I would like to get an idea of the data export options offered by IBM PA / TM1. Is there a list of options? Thanks in advance.

    ------------------------------
    Matthias Frank
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: Export Options TM1/IBM PA - help needed

    Posted Tue October 18, 2022 04:04 AM
    You can export a cube respectively a cube view to a CSV-file, see the product documentation:

        https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=views-exporting-cube-data
        Exporting Cube Data

    Same for subsets.

    Instead of doing this manually, using the Planning Analytics (PA) GUI, you can do that by code, by a TI process.

    You can perform an export into a text file using the TI functions ASCIIOutput or TextOutput.

    You can perform an export into a relational datasource using the TI function ODBCOutput, invoking an INSERT SQL statement.

    ------------------------------
    Bernd Siebert
    ------------------------------



  • 3.  RE: Export Options TM1/IBM PA - help needed

    Posted Tue October 18, 2022 04:16 AM
    Bernd, thank you. Very helpful :-)

    ------------------------------
    Matthias Frank
    ------------------------------