Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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

  • 23 Tasting Room
  • 22 Part

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


Advanced


Way Cool


  • No labels