Introduction
The following is a compilation of practical GOC Cubes. Each example shows its cube request screen and how to arrange dimensions in the Cube Viewer. There is an endless list of ways to request cubes and organize their data for display or export. These examples only intended to expose the cube's abilities and give you ideas before going off the deep end. Knock yourselves out! If you have a wicked-awesome Cube you'd care to share with us, send it in for an entry to win a BART trip to the beautiful Fruitvale BART station in the San Francisco Bay Area. How nice is that?
List of Dimensions
Each CUBE possesses a unique list of dimensions. At the time of writing, the GOC cube supports 85 dimensions. You can download a printable reference of the Point of Sale Orders Cube dimensions using the link provided below.
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 |
