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 are 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 below. 

Dimension Reference - Point Of Sale Orders Cube (PSRPM.GOC) v2022.01.13.xlsx

CUBE Viewer Layouts

In the Cube Viewer, you drag and drop your requested dimensions to activate them as columns or rows.  You can also set dimension filters using the Dimension Editor or modify cube Measures using the Measure Manager.  However, the CUBE viewer does not allow you to "save" the arrangement of dimensions, their filters, or modified measures.  To document your work, we recommend taking screenshots of your layout, dimension filters and measure modifications so that you can return your cube to your preferred view settings when re-requesting the cube or reopening a saved copy after being closed.  

Simple Examples

Advanced Examples

To be compiled.

Way Cool Examples

To be compiled.