Excel

We’re the experts in corporate financial management and business analytics you’ve been searching for.
Our team of talented accountants can help you find and use the tools you need to make your budgeting, forecasting analysis and reporting world class.

Create a TM1 Send Sheet in Excel

Posted on Oct 15, 2018 by John

Sometimes we have data that is created in Excel and we need to load it into TM1 directly from the Excel sheet. This blog post details how to create a...

How to Create a List Report using a TM1 Active Form

Posted on Oct 16, 2017 by John

Ever wondered how to create an Excel list report over a TM1 cube that dynamically expands based on filters so you always get all relevant rows? Well you can, by...

How to Install Planning the Analytics for Excel (PAX) Add-in to Excel

Posted on Jul 13, 2017 by John

Here we are going to detail how to install IBM Planning Analytics for Excel (PAX) onto a user’s PC. What is Planning Analytics for Excel (PAX)? PAX is the Excel...

Errors when Connecting to Planning Analytics for Excel/CAFE

Posted on Jul 6, 2017 by John

Situation At a client where we are getting SaaS based Planning Analytics setup. We have a cube, we have data loaded from an on-premise database. Now we want Planning Analytics for...

DBRW TM1 Excel Syntax and Use

Posted on Oct 30, 2015 by John

DBRW is an Excel based function for use with TM1 that retrieves a value from a specific intersection of a cube TM1. Example I have a Sales Analysis cube with the...

DBRA TM1 Excel Syntax and Use

Posted on Oct 27, 2015 by John

DBRA is an Excel based function for use with TM1 that retrieves the value of an Attribute from a Dimension in TM1. It is roughly equivalent to using a ATTRS...

Display TM1 Attributes in Excel

Posted on Oct 26, 2015 by John

Question How do I display a TM1 Attribute in an Excel report? Answer The easiest way present a TM1 attribute in an Excel report is to use a DBRW, DBR or DBRA...

How to Enable the TM1 Excel Addin and TM1 Perspectives Ribbon in Excel

Posted on Apr 7, 2015 by John

I recently started working with a new PC and it did not have the TM1 Excel Perspectives add-in enabled and obviously I therefore did not have the TM1 Perspectives Ribbon...

ELPAR TM1 Function: Syntax and Use

Posted on Sep 29, 2014 by John

ELPAR stands for Element Parent, which describes what it does pretty well! In other words it returns the parent of an element in a defined dimension. You are better to use...

Need help with TM1?
We're here for you

Categories

Tags