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:

<table BORDER="1"><tr><td COLSPAN="4" ALIGN="CENTER">January </td><td COLSPAN="4" ALIGN="CENTER">February </td><td COLSPAN="4" ALIGN="CENTER">March </td></tr><tr><td COLSPAN="2" ALIGN="CENTER">Actual </td><td COLSPAN="2">Budget </td><td COLSPAN="2" ALIGN="CENTER">Actual </td><td COLSPAN="2">Budget </td><td COLSPAN="2" ALIGN="CENTER">Actual </td><td COLSPAN="2">Budget </td></tr><tr><td>Prod A</td><td>Prod B</td><td>Prod A</td><td>Prod B </td><td>Prod A</td><td>Prod B</td><td>Prod A</td><td>Prod B </td><td>Prod A</td> <td>Prod B</td><td>Prod A</td><td>Prod B </td></tr></table>

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

<table BORDER="1"><tr><td>Chocolate Bars </td><td>Unit Sales </td><td>xxxx </td><td>xxxx </td><td>xxxx </td></tr><tr><td> </td><td>Revenue </td><td>xxxx </td><td>xxxx </td><td>xxxx </td></tr><tr><td> </td><td>Margin </td><td>xxxx </td><td>xxxx </td><td>xxxx </td></tr><tr><td>Fruit Bars </td><td>Unit Sales </td><td>xxxx </td><td>xxxx </td><td>xxxx </td></tr><tr><td> </td><td>Revenue </td><td>xxxx </td><td>xxxx </td><td>xxxx </td></tr><tr><td> </td><td>Margin </td><td>xxxx </td><td>xxxx </td><td>xxxx </td></tr></table>

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.