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

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
------------------------------

Bernd, thank you. Very helpful :-)

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

Original Message:
Sent: Tue October 18, 2022 04:04 AM
From: Bernd Siebert
Subject: Export Options TM1/IBM PA - help needed

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
------------------------------