Category: Help
-
Check if the TM1 REST API is enabled
TM1py uses the TM1 REST API to connect to TM1.
-
Upgrade TM1py
To upgrade TM1py, after checking your current version, just open the command line and type:
-
Generate MDX Queries from Cubeview
MDX is a fast and powerful way to query data from TM1 Cubes. It can play a key role when you combine your TM1 models with other technologies (e.g. Canvas, R, Python).
-
Find unused dimensions
Ever wondered which of the dimensions in your TM1 Model are not used in cubes?
-
Cleanup your TM1 application
Sometimes our TM1 models (especially non-production environments) become messed up with temporary and unwanted objects, like
-
Upload Exchange rate from a Webservice
Your TM1 models can get great benefits from external information, e.g., FX rates, weather forecast, data on commodity prices or consumer confidence. Webservices like Yahoo Finance, Bloomberg or FRED, offer a range of financial and non-financial information. Many of them are Free to use.
-
Check TM1py version
To check the TM1py version installed on your machine, just open a command window and then type:
-
Install TM1py
TM1py is a Python package that wraps the TM1 REST API in a simple to use library. That makes it easy to build stuff with TM1 and python.
-
Display data from an Excel file and then send it to TM1 via REST API
With Canvas, you can upload an Excel file into your browser, validate the data and then send the data into TM1 using the REST API. A sample showcasing has been introduced in Canvas 2.0:
-
Alternate Hierarchies in Canvas
Probably the most exiting feature in IBM Planning Analytics is alternate hierarchies. Using alternate hierarchies will enable you to potentially reduce the number of dimensions in your cube and therefore improve cube size and performance.