Difference between revisions of "Sub Cubes"
(Created page with "sc") |
|||
| Line 1: | Line 1: | ||
| − | + | A Sub Cube defines a subset of the cube to be queried. | |
| + | |||
| + | A Sub Cube is similar to adding restrictions to the Header area of a grid, the main differences are: | ||
| + | * Restrictions can be on a Hierarchy that is also selected on Rows or Columns | ||
| + | * Restrictions affect Totals in the grid. | ||
| + | |||
| + | [https://blog.xlcubed.com/2019/04/advanced-grid-reporting-mdx/] | ||
Revision as of 11:14, 18 April 2019
A Sub Cube defines a subset of the cube to be queried.
A Sub Cube is similar to adding restrictions to the Header area of a grid, the main differences are:
- Restrictions can be on a Hierarchy that is also selected on Rows or Columns
- Restrictions affect Totals in the grid.
