-
Configuring Slice – Settings
Slice Settings can be updated through the Settings button from the Excel ribbon:
-
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.
-
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.
-
Insert Active Forms with dynamic columns
With Slice, you can insert Active Forms with dynamic columns. To do that, you will need to tick the option Dynamic Columns while inserting an Active Form from Excel:
-
Show and hide the menu
To maximize the tab, you might want to hide the left-side menu. To toggle the menu, you need to press CTRL+SHIFT+M:
-
FAQ
General + What is Slice ? Slice is an Excel add-in to retrieve and update values from a TM1 database using cell based functions. + Why create slice ? We wanted to expand the TM1 ecosystem to make it easier for companies to build and deploy application-specific Excel user interfaces. Key requirements of Slice: it…
-
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
-
Connecting to the IBM Cloud remotely with TM1py
In this article, we explain how you can use TM1py from your laptop/desktop and connect remotely to the IBM Cloud via the REST API.