The DBRW serves as a fundamental tool for interacting with multidimensional data cubes on IBM Planning Analytics (TM1), enabling precise retrieval and modification of data within the context of financial planning, analysis and reporting. This function is used directly in Excel, enabling users to create dynamic and interactive reports and input templates.
It is recommended to use the View function with DBRW to define the data you want to retreive, as it will cache it into memory, making it faster to return data.
This formula, along with related functions like DBR and DBS, plays a crucial role in leveraging the power of IBM Planning Analytics (IBM’s solution for business analytics) for dynamic business insights and decision-making.
Learn how to use the DBRW to retrieve data from a cell in the Product Scorecard cube with the video.
Excel
Version 11 and 12
DBRW(TM1ServerName:CubeName, Element1, Element2, Element3, …, ElementN)