Loading Cube Data at Non-Leaf Levels

Overview

SAS 9 OLAP Server cubes load input data into a multi-dimensional structure that enables fast retrieval of summarized views of that data. This paper explains how to load data like these into SAS9 OLAP Server cubes, how the cube loading options for ragged and unbalanced hierarchies implicitly support virtual members, and how the cube reads your input data into virtual members. This paper discusses advanced cube-loading techniques. Knowledge of the MDX query language is helpful for understanding the notation of dimension, hierarchy, level, and member names.