Category: Code
-
Finding ideal dimensions order with OptimusPy
This article explains how to leverage OptimusPy to optimize your cubes for performance and memory.
-
TM1 hidden features
IBM Planning Analytics powered by TM1 (TM1) is full of features, over the years the IBM server team continues improving it to meet various customer requirements. This article digs into some of its hidden features. All features described below are currently undocumented, use them with care!
-
RushTI optimized mode
RushTI now has an alternative execution mode: OPTIt allows for an optimized execution schedule.
-
Loading data into a TM1 cube with TM1py
This article explains three methods of loading data into a TM1 cube with TM1py.
-
Updating dimensions with TM1py
This article explains two different ways to update dimensions with TM1py.
-
Arc v2.1 is now available
Thanks to the feedback from TM1 developers from all around the world, Arc is becoming more and more robust (900+ tickets closed). This new release includes 63 enhancements and fixes, here some highlights…
-
Connecting Power BI to TM1 for FREE with TM1py
It is easy to connect your data together. Power BI (PBI) includes 45+ certified connectors for Files (Excel, CSV…), Databases (SQL Server, Oracle, IBM DB2…), Power Platforms (Power BI datasets), Azure (Azure SQL databse, Azure Databricks…), Online Services (Sharepoint, Salesforce…) and Other (Web, Active Directory…).
-
Getting TM1 data into Power BI
TM1py v1.5 introduces two new functions to make it even easier to build beautiful Power BI (PBI) dashboards with Live TM1 data. This article is a step by step guide to get data from IBM Planning Analytics powered by TM1 (TM1) into Power BI Desktop.
-
Clearing cube data with TM1py
Often when interacting with TM1 through TM1py, it is necessary to clear out a slice of a cube. Since release 1.5 there are four options to clear a slice in a cube. Let’s look at the pros and cons of each option.
-
Loading data into a cube from a CSV file with TM1py
This article explains how to load data from a CSV file into a cube with TM1py