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

GOC Entity Relationship Diagram

Visio-GOC Cube ERD (Entity Relationship Diagram).pdf

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.

...

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 For Part, show both its code and description	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 ROWS as needed	If your winery maintains multiple tasting rooms, this would be a handy view of the wines each tasting room was selling. Download this Cube: GOC.SimpleSample.PartSalesbyTR.YAC
Part Sales by Original Clerk
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 For Part, show both its code and description	DIMENSIONS 62 Original Clerk 22 Part	1- Drag the Original Clerk dimension into the Columns area. 2- Drag the PartCode and Description dimension into the Rows area. 3-Toggle display of Total by ROWS as needed	Useful if you were interested in knowing what clerks are selling what wines. Download this Cube: GOC.SimpleSample.PartSalesbyOriginalClerk.YAC
Part Sales by Transaction Category
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 For Part, show only Part Code	DIMENSIONS 35 Transaction Category 22 Part	1- Drag the Transaction Category dimension into the Columns area. 2- Drag the Part dimension into the Rows area.	Useful in showing what wines are selling through which sales channels. Download this Cube: GOC.SimpleSample.PartSalesbyTranCategory.YAC
Part Sales by Transaction Category, Selected on PFC
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. IRW select parts having Part Financial Code PFC=WN (Wine) with SHOW For Part, show only Part Code	DIMENSIONS 35 Transaction Category 22 Part	1- Drag the Transaction Category dimension into the Columns area. 2- Drag the Part dimension into the Rows area.	This view is similar to the previous example, except that the parts included are only those that identify with PFC = WN (Part Financial Code = Wine). Note that merchandise, tastings, and reservation part numbers do not appear. Download this Cube: GOC.SimpleSample.PartSalesbyTranCategory,Select PFC WN.YAC
Part Sales by Day of Week and Hour Commissions on Wine Sales
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. IRW select parts having Part Financial Code PFC=WN (Wine) with SHOW For Part, show only Part Code	Image Removed	(need a more realistic representation of auth hours. Democart is not a good source of transaction data). This view would be of value if you were scheduling staff, and looking to determine on what day of the week and at approximately what time do your sales occur. Download this cube: