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
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
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
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
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
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
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
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
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
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
Keen to chat? Book a discovery call!
