Category: How To
-
Connecting Arc to Atmosphere
The Atmosphere portal is available inside Arc: Atmosphere Subscription Before using Atmosphere, you need an active subscription. To subscribe to Atmosphere, please reach out to your Cubewise local contact or you can click the contact us button on the top right. Activate Atmosphere inside Arc Once your Atmosphere subscription is active, you will get an…
-
Override selected user preferences
Starting with v4.6.1, it is now possible to set the default values for user preferences. the list of properties exported by the User Preference dialog to include a wider variety of preferences supported by Arc. This now includes toolbar visibility preferences and code formatter options. When Arc Server is run or re-started, a new folder…
-
DBSW function behavior with Slice
Slice supports the native TM1 functions DBS and DBSW to send data into your IBM Planning Analytics (TM1) cube. DBSW is much faster than DBS, it is highly recommended to use DBSW instead of DBS. Default behaviour of DBS and DBSW Slice offers a convenient feature with the DBS Send button located in the Slice…
-
5 Ways to Aggregate Data in DBRW with Slice
When working in Excel with IBM Planning Analytics (TM1), efficient data aggregation is essential for building dynamic reports so here are five powerful ways to aggregate data using the DBRW function in TM1 with Slice: 1. Natural Consolidations You can easily select any consolidation in your dimensions by clicking in any cell with a SUBNM…
-
Creating new alert templates
What is an Alert Template? An Alert Template is a predefined alert with default settings that you can use to create new alerts quickly. Instead of manually configuring each alert, you can apply a template that already contains default values for the alert settings. Creating a new Alert Template To create an alert template: Migrating…
-
Updating the Pulse Opensearch JVM maximum memory
This article explains how to update the Pulse Opensearch maximum memory. To see how much memory the Pulse Opensearch service is using, open Task Manager and look for pulse-opensearch.exe (in the example below it is currently using 697,644K): The minimum memory should be 1 GB. This value can be overwritten when installing Pulse. Updating the Pulse Opensearch…
-
Migrating cube data
Starting with Pulse v6.5.1, cube data can be migrated using the Live option. It means that you can migrate cube data between two TM1 instances without having to restart the instance. Option to include cube data When creating a new migration package, the option Include Cube Data needs to be ticked as below: Then after…
-
Pushing Pulse VCS folder into a remote GIT
Pulse is constantly tracking changes made by IBM Planning Analytics (TM1) developers. These changes are stored in a local vcs folder. It is possible to send these changes into a remote GIT repository. To do that, a script is available inside the vcs folder: About the aunthentication: GitRemotePush uses the windows credential helper of git,…
-
Monitor the status of any service
Starting with v6.5.1, the Pulse Monitor can now monitor the status of any service on a server. A new parameter externalservicestomonitor has been added into the monitor.yml file to list down the Windows Services it needs to further monitor. It should contain the Windows Service Name (not the display name). As an example, to monitor…
-
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…