<img src="https://trc.taboola.com/1278851/log/3/unip?en=page_view" width="0" height="0" style="display:none">

Blog

TM1: Feeder-Less Feeding

[fa icon='calendar'] July 17, 2020 / by Kunal Ghewade posted in PlanningAnalytics, TM1 How To, TM1 Local

[fa icon="comment"] 0 Comments

Many Developers like to stay away from the topic call Feeders in TM1 / Planning Analytics world but on the other side we cannot avoid Feeders as it plays the most crucial role while Modelling the data flow.
Sometimes, dealing with Feeders may result in 2 major issues:
1. Over Feeding
- Performance issue.
- RAM consumption.
2. Under Feeding
- Totalling issue
To avoid this there is a small concept called Feeder-Less Feeding where we can avoid writing Feeders and Feeder related issues.

About:
Feeder-Less Feeding is a Concept of Modelling the data in such a way where you write a Rule in TM1 Rule file but you don’t need to write feeders for it, still using ‘Skipchecks’ (By having the sparse consolidation algorithm on).

Example:
To show the concept of feeder-less feeding we will proceed with an example where we are computing Travel Cost with Headcount and Rate.

Formula:
               Travel Cost = Headcount * Travel Rate

Here we can say Headcount is the Driver of Travel Cost and if we want to feed, we would have fed the Travel Cost with Headcount.

So, element Travel Cost and Driver: Headcount should be in same dimension and Driver should be the child of its Rule Driven element as below,


 The Rule element should be the Parent (Consolidation) of its Driver to get fed automatically.

Now we have inputted some filled values in the Headcount and Travel Rate.

  
Here we have kept the Rates in the Same Cube to keep it simple.
You can have the Rates from the same Cube as well as from another Rate Cube depends on your way of Modelling.

The simple Cube Rule we can have for current formula and the resulted Value as below.
  

Read More [fa icon="long-arrow-right"]

Automation in TM1 using AutoHotkey

[fa icon='calendar'] March 2, 2020 / by Rajan Bajracharya posted in PlanningAnalytics, How to, TM1 How To, TM1 hidden feature, TM1 Support, PA Local, TM1 Local, PA Cloud, Financial Planning, Financial Planning Software, Business Intelligence Applications, IBM Planing Analytics

[fa icon="comment"] 0 Comments

This blog explains a few TM1 tasks which can be automated using AutoHotKey. For those who don't already know, AutoHotKey is open-source scripting language used for automation.

Read More [fa icon="long-arrow-right"]

Planning Analytics Secure Gateway: Token Expiry

[fa icon='calendar'] November 11, 2019 / by Srinivas STP posted in TM1 How To, Planning Analytics, Planning Analytics Workspace, cloud, TM1 Support, Octane Software Solutions, PA Local, TM1 Local, PA Cloud, Financial Planning, Financial Planning Software, Business Intelligence Applications, PAX, PAX and PAW, IBM Planing Analytics, PA secure gateway

[fa icon="comment"] 0 Comments

Before you read further, please note, this blog details secure Gateway connection used for Planning Analytics deployed “on-cloud” Software as a Service (SaaS) offering.

Read More [fa icon="long-arrow-right"]

IBM Planning Analytics for Excel: Bug and its Fix

[fa icon='calendar'] October 21, 2019 / by Srinivas STP posted in PA and PAW, TM1 on cloud, TM1 Support, Octane Software Solutions, TurboIntegrator, PA Local, TM1 Local, PA Cloud, PAX, PAX and PAW, IBM Planing Analytics

[fa icon="comment"] 0 Comments

Since the launch of Planning Analytics few years back, IBM has been recommending its users to move to Planning Analytics for Excel (PAX) from TM1 Perspective and TM1 Web. As every day new users migrate to adopt PAX, it’s prudent that I share my experiences.

Read More [fa icon="long-arrow-right"]

Moving from on-premise TM1 10.X.X to Planning Analytics on Cloud

[fa icon='calendar'] September 30, 2019 / by Sameer Syed posted in TM1, TM1 Training, TM1 How To, Planning Analytics, IBM PA, Octane Software Solutions, PA Local, TM1 Local, PA Cloud, Financial Planning Software, Business Intelligence Applications, PAX and PAW

[fa icon="comment"] 0 Comments

As you plan to adopt IBM Planning Analytics cloud, it’s important to understand what it takes. This blog highlights areas you will be involved-in when you upgrade from on-premise TM1 10.x.x to Planning Analytics on Cloud.

Read More [fa icon="long-arrow-right"]

Planning Analytics - Cloud Or On-Premise

[fa icon='calendar'] September 16, 2019 / by Srinivas STP posted in PlanningAnalytics, TM1, PA and PAW, TM1 on cloud, TM1 Local, PA Cloud, Analytics, Business Intelligence Tools, Financial Planning, Financial Planning Software, Business Intelligence Applications, PAX and PAW

[fa icon="comment"] 0 Comments

This Blog details IBM Planning Analytics On-Cloud and On-Premise deployment options. It focusses & highlights key points which should help you make the decision; “whether to adopt Cloud Or stay on Premise”

Read More [fa icon="long-arrow-right"]

Planning Analytics and PowerBI

[fa icon='calendar'] May 21, 2019 / by Lisi Luo posted in Technical, Business Intelligence, PlanningAnalytics, TM1 How To, Planning Analytics, Business Analytics, PA Local, TM1 Local

[fa icon="comment"] 0 Comments

Many businesses have already turned to Octane and partnered with us to help turn their data into meaningful insights. So if you've wanted to connect your Planning Analytics to Power BI, you're not alone and now with us you can.
Read More [fa icon="long-arrow-right"]

Planning Analytics 2.0.7 release

[fa icon='calendar'] May 1, 2019 / by Martin Liwosz posted in Insider, Technical, PlanningAnalytics, Planning Analytics, PA, IBM PA, TM1 on cloud, PA Local, PA 2.0.7, TM1 Local, PA Cloud

[fa icon="comment"] 0 Comments

The long-awaited release of Planning Analytics 2.0.7 is finally here!

Read More [fa icon="long-arrow-right"]

Subscribe to Email Updates

Recent Posts