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.

Announcing the Journey to AI Blog, the new home for IBM data and AI stories
by eric-hausken on July 29, 2020 at 6:44 pm
Welcome to the Journey to AI Blog, the new home for blog storytelling from across the IBM Data and AI business. Here you’ll find the latest news, client features, product launches, industry innovator spotlights and thought leadership from IBM executives.
Why healthcare needs big data and analytics
by holly-vatter on July 28, 2020 at 7:51 pm
The COVID-19 global pandemic has heightened the focus on collecting, analyzing, and leveraging big data to drive positive and lifesaving outcomes. Yet the volume, velocity, and variety of data generated by COVID-19 is too vast and complex to be analyzed by traditional means.
Upgraded agility for the modern enterprise with IBM Cloud Pak for Data
by mukta-singh on July 27, 2020 at 10:36 pm
Your data and AI tools are important, and outcomes are critical, but with today’s data-driven world, businesses must accelerate outcomes while improving IT cost efficiency. But how do you achieve this? First, Data and AI initiatives must have intelligent workflows where the data lifecycle can work for various personas of the organization. It’s beyond just tool collaboration and consolidation, but it is also the collaboration of teams, streamlining of processes and interoperability of capabilities that improve outcomes.

TM1 Tutorials

Children-MDX for Next Level Only of TM1 Element
by John on November 16, 2020 at 10:53 pm
Use MDX to return JUST the children of a parent element in TM1. Simple explanation with worked example. THis MDX can then be used to export just those elements.
How to Install Planning Analytics Workspace to Windows 2016
by John on October 23, 2020 at 1:23 am
Detailed instructions on how to install Planning Analytics Workspace and Docker onto Windows Server 2016. Updated for PAW version 2.0.57.
How to Backup Planning Analytics Workspace
by John on October 16, 2020 at 6:50 am
Here are complete steps with screenshots how to backup Planning Analytics Workspace (PAW). This should be done prior to upgrading PAW.

From the Blog

IBM Big Data Hub Blog

TM1 Tutorials