To produce attribute dimensions in your cube, build a multichain hierarchy, adding the same dimension element or physical column as the leaf-level member of each chain, as shown in Figure 9, Multichain hierarchy to build attribute dimensions.
In the Cube Schema Wizard, use this hierarchy in your cube schema and build an Essbase model. After the Essbase model is built, in Essbase Model Properties, set the attribute member properties for the parent of each of the attribute hierarchies in the chain. In the example in Figure 9, Multichain hierarchy to build attribute dimensions, set the attribute property on the members Caffeinated, Ounces, PkgType, and IntroDate. See Selecting Members as Attributes for more information.
To set attribute formatting rules for the model, see Defining Attributes in Models.
Figure 10, shows a portion of the resulting Essbase outline after cube deployment.
