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
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!
