TM1 Information Hub

From the Blog

08:00 27.10.2016 Creating User Defined Consolidations in TM1

If you use TM1 Architect / Perspectives and need a temporary consolidation which does not exist in dimension structure, you can insert user defined consolidation into existing subset. Follow steps

08:00 26.10.2016 Creating TM1 Dimension Calculation in Performance Modeler

You can use dimension calculation if you have a calculation that will be used in all the cubes that contain the dimension. Dimension calculation can be done at leaf level

08:00 25.10.2016 Creating TM1 metrics cube for Scorecarding

Metrics cube is an essential part of a scorecarding application, this cube uses icons to show how each metric is performing. A metrics cube has to contain at least following dimension:

08:00 24.10.2016 Adding dimensions to TM1 cubes

Using Performance Modeler we can add dimension to an existing cube without rebuilding it. Double click on the cube. Drag and drop the dimension from list to cube area or

08:00 21.10.2016 Creating TM1 Drill-through

In Performance Modeler we can easily create a drill-through from a link. Refer here for creating link. Double click the link and in properties window select Yes for Generate Drill through objects?

06:52 12.09.2016 Returning values from Turbo Integrator processes

Introduction The two cornerstone features of any generic programming platform are encapsulation and reuse. These related ideas are simply the ability to write a piece of code once and then

10:16 20.06.2016 Adaptive Modelling – An Item-based Approach

Introduction Working on projects over the years, there was a confluence of “classical” TM1 model design and an approach that was often used to implement Cognos Planning. This occurred when

09:44 20.06.2016 Creating TM1 Pick List in Performance Modeler

Pick List is used to validate data typed into cell against a set of predefined elements. These elements can be based on static list or from dimension subset. Using Performance

09:43 20.06.2016 Moving TM1 Objects using Performance Modeler

In Performance Modeler there’s a functionality to Transfer Out and Transfer In TM1 objects. We can use this functionality to move objects between environments for example from development to testing environment.

Comparing IBM Watson OpenScale to open source on AI explainability
by manish-bhide on April 7, 2020 at 4:28 pm
IBM Watson OpenScale helps organizations detect and correct AI model bias and drift, explain AI outcomes, monitor model accuracy, analyze payloads, and more. There are algorithms available in open source that provide some of these capabilities.
A partnership for growth and innovation: IBM Informix and HCL
by kip-yego on April 2, 2020 at 4:25 pm
Building on a history of collaboration, in April 2017, IBM and HCL entered into a 15-year partnership that merged the best of their shared knowledge and teaming experience to accelerate the product roadmap and innovation of IBM Informix.
Using open source and open-source-based databases to drive your Journey to AI
by kip-yego on April 1, 2020 at 7:13 pm
As data proliferates, the need to efficiently undertand, process, and act quickly for competitive advantage continues to increase. Applications must be able to use data swiftly and adapt as needs change by the week or even the day. Developers also require places to store their data that can handle multiple formats and use cases. In order to manage these growing data needs, drive innovation and increase agility via modern application development, enterprises are turning to open-source-based solutions and technologies.

TM1 Tutorials

Planning Analytics for Excel (PAX) Ribbon Not Visible
by John on March 9, 2020 at 12:43 am
The Planning Analytics for Excel ribbon is somewhat unreliable. Here we explain what drives the PAX toolbar, the add-ins and how and what to activate and a registry change that might be required.
Planning Analytics Version Management
by John on March 9, 2020 at 12:17 am
Here we explain what versions of Planning Analytics (TM1) server, Planning Analytics for Excel (PAX) and Planning Analytics Workspace (PAW) work together to ensure your TM1 environment keeps on working nicely.
How to Display Traffic Lights using TM1
by John on December 19, 2019 at 8:19 pm
Traffic Lights in an Excel based TM1 report are dead simple. Here is a fully worked exercise to follow to create them and a series of ideas for their use.

From the Blog

IBM Big Data Hub Blog

TM1 Tutorials