Category: Code
-
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…
-
PowerConnect – Connector Installation and Configuration Guide
This installation guide describes how to install and configure the PowerConnect connector to load data from IBM Planning Analytics to Microsoft Power BI. Prerequisites Installation Upgrade Configuration Testing To ensure a successful installation, open the “Get Data” dialog in Microsoft Power BI Desktop and search for “cubewise”. The following data source will appear: The PowerConnect…
-
TM1py v1.11 is now available
With this release, TM1py closed the performance gap between TM1py and Turbo Integrator. Thanks to @AndrewScheevel, @Kevin Dekker and @Felipe Fonseca for contributing code!
-
MDXpy
A simple, yet elegant MDX library for TM1 MDXpy enables Python developers to create MDX queries programmatically without hacking raw MDX queries. Benefits The Member Class The Member class is a core building block for the MdxTuple and the MdxHierarchySet classes. To create a Member, use the Member.of(*args: str) method: The MdxTuple Class The MdxTuple…
-
Cubecalc
A super calculator for IBM Planning Analytics (TM1) CubeCalc enables you to execute complex finance calculations which are not available natively in IBM Planning Analytics (TM1) such as IRR (Internal Rate of Return) and NPV (Net Present Value). CubeCalc is a free Python script which requires TM1py and uses the TM1 REST API to connect…
-
Connecting to the Pulse Database
Since Pulse v5.6, Pulse uses only one h2 database by default, to access the data you just need to connect to the docs.h2.db. Instead of the h2 database, since v5.6 you can migrate your Pulse data to a MS SQL Server.
-
Canvas
A framework to build custom and modern web applications.
-
TM1py Support by Cubewise
Do you want to use TM1py and need access to support? Sign-up for official TM1py Support offered by Cubewise.
-
Fine-tuning for Pulse
The pulse default configuration should be enough for most environments. This article shares some tips to improve the performance of Pulse if it slows down. Migrating to MS SQL Server The default H2 database is single-threaded. It means that if you have many Pulse users and many TM1 instances. The queries to the database might…