Nesting

Nesting is a display technique used to show the results of a multi-dimensional query that returns a sub-cube, i.e., more than a two-dimensional slice or page. The column/row labels will display the extra dimensionality of the output by nesting the labels describing the members of each dimension. For example, the display's columns may be:

January				February				March
Actual		Budget		Actual		Budget		Actual		Budget
Prod A	Prod B	Prod A	Prod B	Prod A	Prod B	Prod A	Prod B	Prod A	Prod B	Prod A	Prod B

These columns contain three dimensions, nested in the user's preferred arrangement.
Likewise, a report's rows may contain nested dimensions:

Chocolate Bars	Unit Sales	xxxx	xxxx	xxxx
	Revenue	xxxx	xxxx	xxxx
	Margin	xxxx	xxxx	xxxx
Fruit Bars	Unit Sales	xxxx	xxxx	xxxx
	Revenue	xxxx	xxxx	xxxx
	Margin	xxxx	xxxx	xxxx

from OLAP Glossary, 1995

DSS Home \| About Us \| Contact Us \| Site Index \| Subscribe \| What's New
Copyright © 1995-2021 by D. J. Power (see his home page). DSSResources.COM^sm was maintained by Daniel J. Power of PowerEnterprises.net. See disclaimer and privacy statement.