While such relationships are normally summations, any type of computational relationship or formula might be defined. This is the opposite of sparse. Derived Data Derived data is produced by applying calculations to input data at the time the request for that data is made, meaning the data has not been pre-computed and stored on the database. The purpose of using derived data is to save storage space and calculation time, particularly for calculated data that may be infrequently called for or that is susceptible to a high degree of interactive personalization by the user. The tradeoff is slower retrievals.
Derived members are members whose associated data is derived data.
Detail Member A detail member of a dimension is the lowest level number in its hierarchy. A dimension acts as an index for identifying values within a multi-dimensional array. If all dimensions have a single member selected, then a single cell is defined. Dimensions offer a very concise, intuitive way of organizing and selecting data for retrieval, exploration, and analysis. The drilling paths may be defined by the hierarchies within dimensions or other relationships that may be dynamic within or between dimensions.