Category: How To
-
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:
-
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
-
Impersonate a user
From the Security page you can now impersonate a user to view how security is applied to them. Use it with care as all changes will be applied to the person you impersonate
-
Setting up native TM1 Open ID authentication
Starting with v2.0, Arc supports native TM1 OpenID authentication.
-
Troubleshooting Feeders in TM1 with Emojis
Emojis can do more than just make your messages fun. They can also be used to highlight important information, as Emojis are supported by most softwares. In IBM Planning Analytics and TM1, they are supported by Architect, TM1 Web and Planning Analytics Workspace.
-
Using the Arc Security tool for TM1
How to use
-
Getting started with Arc Desktop for Windows
On Windows, Arc is available as a desktop application or as a server. To install Arc as a server, the instructions can be found here. Arc Desktop and Arc Server have the same features except that it is easier to use multiple windows with Arc Desktop.