Introduction
The following is a compilation of practical GOC Cubes. Each example shows its cube request screen and how dimensions are arranged in the Cube Viewer.
List of Dimensions
Each CUBE possesses a unique list of dimensions. A printable reference of the Point of Sale Orders Cube dimensions may be downloaded here.
Dimension Reference - Point Of Sale Orders Cube (PSRPM.GOC) v2022.01.13.xlsx
Simple
Part Sales by Tasting Room
SELECT orders sold between 07/01/2021 and 08/30/2021. Include orders with a status of Sold=Y or Shipped=Y. Select gift packages per their components. SHOW etc. DIMENSIONS
| 1- Drag the TastingRoom dimension into the Columns area. 2- Drag the PartCode and Description dimension into the Rows area. 3-Toggle display of Total by Row as needed | Download this Cube: GOC.SimpleSample.PartSalesbyTR.YAC |