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.

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

Popular Articles

Keen to chat? Book a discovery call!

pen