Category Archives: Excel

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 following dimensions: Year, Month, Customer, Product, Measures.  I want the intersection of: 2015 (Year), Oct (Month), The Corner Cafe (Customer), Coffee (Product) and Sales $ (Measure). If I open Architect and navigate to this intersection, it says $1,230.00. I now want to … Continue Reading

This entry was posted in Excel. Bookmark the permalink. | 1 Comment

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 in a Rule or TI. Example For example if I have a dimension called Customer with an attribute called Channel. An element of this dimension is called “Fred Bloggs” (he’s a customer) and his Channel is “Retail”.  In this case “Retail” would … Continue Reading

This entry was posted in Excel. Bookmark the permalink. | 1 Comment

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 and refer to the control cube for the relevant dimension in the Excel formula. Example I have a dimension called Customer.  In this dimension there is an attribute called Channel. There is an element called “Fred Bloggs” (he’s a customer) and … Continue Reading

This entry was posted in Attributes, Excel. Bookmark the permalink. | Leave a comment

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 included in Excel. So I thought I would do a quick blog about how to enable it. What this does is then automatically add the Perspectives addin to Excel on your PC so that TM1 automatically opens each time you … Continue Reading

This entry was posted in Excel, Installation. Bookmark the permalink. | Leave a comment

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 a combination of attributes and ATTRS rather than this function. Please see our warning below. Syntax The syntax is: ELPAR(dimension, element, index), where: dimension is a valid dimension name, and element is the name of an element within the dimension or … Continue Reading

This entry was posted in Excel. Bookmark the permalink. | Leave a comment