A well designed cube(s) or enterprise analytic solution is an information powerhouse, especially when used inside EXCEL. Rules to access TM1 cubes is the equivalent of using SQL on database. Analytic modelers can create complex models to derive insights on various facets of the enterprise without actually developing an excel and on the fly. To create a new model in EXCEL, the users just need the DBR() function.
A simple example: Consider the situation when a cube is designed to determine the monthly sales or inventory or financial information. These can be one or more cubes depending on how the enterprise solution is created. Using DBR(), an EXCEL-TM1 user can extract data from the cubes into the EXCEL worksheet. Once the organized data is present, trending models or aggregated yearly information models or any other predictive or informative analytics can be performed based on the task at hand without relying on enterprise solutions to be developed. Of course, a well-designed cube with crisp structural, creational and behavioral patterns in a pre-condition to make TM1 and EXCEL combined an information powerhouse.
