Category: Help
-
PowerConnect Hands-on
The objective of this hands-on manual is to help you getting started with Cubewise PowerConnect, the complete Power BI Connector for IBM Planning Analytics (TM1). PowerConnect helps you getting your data, metadata and security from TM1 into Power BI. In this user manual you will learn: This manual is available to download for free by…
-
Troubleshooting Slice
Slice add-in for Excel connects users to Planning Analytics allowing the users to build dynamic reports connected to TM1 cubes. While it introduces advanced analytical functions, users may encounter challenges. Effective troubleshooting ensures Slice’s smooth operation, allowing for comprehensive utilization of its features for insightful data analysis. Below you will find some of the known…
-
Arc Plugins
-
PowerConnect Architecture
-
PowerConnect Prerequisites
System Configuration Hardware: Operating System: Microsoft Azure App Registration For OAuth2 authentication, a Microsoft Azure App API App needs to be registered. The required scope for the app is User.Read. Admin consent needs to be applied. The redirect URL for the app is An Azure tenant admin usually does the App registration. Network Configuration for…
-
PowerConnect Service Installation Guide
Prerequisites Windows Administrator credentials are required to complete this setup. Installation Click on “Next”. Read the license agreement, then click on “Agree”. Choose the Authentiaction Mode for Microsoft Power BI Desktop: Select the desired components. Enter the Base URL of the PowerConnect Server: Select the installation location. Default is “C:\Program Files\PowerConnect”. After the files…
-
PowerConnect Service Configuration
After the installation is completed, navigate to the installation folder, and open the copy the conf\settings.sample.yml file to conf\settings.yml. This will allow you to adjust the sample settings without having to start from scratch. Note: The PowerConnect service needs to be restarted after making changes to the configuration file. There are three sections in the…
-
Canvas Help
-
Slice Help
-
PowerConnect – Setting Passwords
PowerConnect uses the Windows Credential store to maintain the passwords for the administrator users connecting to IBM Planning Analytics. In Microsoft Power BI Desktop impersonation is used to enforce the users’ IBM Planning Analytics security after initially establishing the connection with an administrator user. This administrator user can be configured for each individual connection. Admin…