DBRW Advanced Feature

In this spreadsheet, you can showcase five different ways to retrieve the same data from TM1 using the DBRW function:

1. Element Name: Directly reference the element name in the DBRW formula.

2. Subset: Use a subset inside DBRW to return the sum of all elements in that subset.

3. Virtual Consolidation: Reference a Virtual Consolidation for dynamic grouping.

4. Virtual Expression: Create your own calculation within DBRW for custom logic.

5. Cell Range: Use a range of cells in DBRW to pull multiple values efficiently.