Dimensions Usage

Modified on Tue, 28 Jul at 2:48 AM

Dimensions Overview

QQube uses dimensions to give measures context. A measure supplies the value to calculate, such as a sum, average, maximum, or count. A dimension supplies the category used to group that value.

For example, Line Sales Quantity by itself returns one overall total.

Measure without a dimension

Line Sales Quantity displayed as one total without a dimension

Adding the Customer Name dimension gives the measure context, producing a separate sales quantity total for each customer.

Measure grouped by Customer Name

Line Sales Quantity grouped by the Customer Name dimension

Available QQube Dimensions

This reference shows each customer-facing dimension and the ready-made QQube data models in which it is included.

Date Dimensions

Date dimensions are documented separately.

Dimension	Included Data Models
Account	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Accounts Payable Inventory Job Cost Details Payroll Balance Sheet - Standard Profit and Loss - Standard Trial Balance - Current Trial Balance - All Dates Trial Balance - Activity Statement of Cash Flows Profit and Loss - Job (Enterprise) Profit and Loss - Actuals/Budget/Forecast (Enterprise) Profit and Loss - 52/53 Tax Year (Enterprise) Balance Sheet by Class - Standard Profit and Loss by Class - Standard Trial Balance by Class - Activity Statement of Cash Flows by Class Profit and Loss by Job by Class (Enterprise) Profit and Loss by Class - Actuals/Budget/Forecast (Enterprise) Profit and Loss by Class - 52/53 Tax Year (Enterprise) General Ledger Detail Profit and Loss Detail Cash Position Fixed Assets Audit Trail
Account - Balance Sheet	Balance Sheet - Standard Balance Sheet by Class - Standard
Account - Cash Flow	Statement of Cash Flows
Account - Cost of Goods Sold	Sales
Account - Expense Offset	Accounts Payable
Account - Fixed Asset	Fixed Assets
Account - Inventory	Inventory
Account - Profit and Loss	Profit and Loss - Standard Profit and Loss by Class - Standard Profit and Loss Detail
Account - Sales	Sales Inventory
Account - Summary	Sales General Ledger Detail Profit and Loss Detail Audit Trail
Bin Location	Sales Open Sales Orders Inventory General Ledger Detail Profit and Loss Detail
Class	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Accounts Payable Inventory Job Cost Details Time Tracking Vehicle Mileage Payroll Balance Sheet by Class - Standard Profit and Loss by Class - Standard Trial Balance by Class - Activity Statement of Cash Flows by Class Profit and Loss by Class - Job (Enterprise) Profit and Loss by Class - Actuals/Budget/Forecast (Enterprise) Profit and Loss by Class - 52/53 Tax Year (Enterprise) General Ledger Detail Profit and Loss Detail Cash Position Audit Trail
Company	All QQube data models
Currency	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Accounts Payable Inventory Job Cost Details General Ledger Detail Profit and Loss Detail Cash Position
Customer	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Accounts Payable Inventory Job Cost Details Time Tracking Vehicle Mileage Payroll General Ledger Detail Profit and Loss Detail Cash Position Audit Trail
Customer Message	Sales Open Sales Orders Accounts Receivable
Customer Rep	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Accounts Payable Inventory Job Cost Details Time Tracking Vehicle Mileage Payroll General Ledger Detail Profit and Loss Detail Cash Position Audit Trail
Customer Sales Tax Code	Sales Open Sales Orders
Document Attributes	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Accounts Payable Inventory Job Cost Details Time Tracking Vehicle Mileage Payroll General Ledger Detail Profit and Loss Detail Cash Position Audit Trail
Line Attributes	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Accounts Payable Inventory Job Cost Details Time Tracking Vehicle Mileage Payroll General Ledger Detail Profit and Loss Detail Cash Position Audit Trail
Document Sales Tax Item	Sales Open Sales Orders
Employee	Purchases Accounts Payable Inventory Job Cost Details Time Tracking General Ledger Detail Profit and Loss Detail Cash Position Audit Trail
Employee HR	Payroll
Geography	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Accounts Payable Inventory Job Cost Details Cash Position
Item	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Accounts Payable Inventory Job Cost Details General Ledger Detail Profit and Loss Detail Fixed Assets Audit Trail
Item Sales Tax Code	Sales Open Sales Orders Purchases Open Purchase Orders Audit Trail
Job	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Accounts Payable Inventory Job Cost Details Time Tracking Vehicle Mileage Payroll General Ledger Detail Profit and Loss Detail Cash Position Audit Trail
Job Rep	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Accounts Payable Inventory Job Cost Details Time Tracking Vehicle Mileage Payroll General Ledger Detail Profit and Loss Detail Cash Position Audit Trail
Other Name	Accounts Receivable Purchases Accounts Payable Inventory Job Cost Details Time Tracking Payroll General Ledger Detail Profit and Loss Detail Cash Position Audit Trail
Payment Method	Sales General Ledger Detail Profit and Loss Detail Audit Trail
Payroll Item	Job Cost Details Time Tracking Payroll General Ledger Detail Profit and Loss Detail Audit Trail
Sales Rep	Sales Open Sales Orders Accounts Receivable Purchases Accounts Payable Inventory Job Cost Details Cash Position
Sales Tax Item	Accounts Receivable General Ledger Detail Profit and Loss Detail Cash Position Audit Trail
Service Item	Time Tracking Vehicle Mileage Payroll
Ship Method	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Inventory Job Cost Details Cash Position Audit Trail
Site	Sales Open Sales Orders Inventory General Ledger Detail Profit and Loss Detail
Source Name	Job Cost Details General Ledger Detail Profit and Loss Detail Cash Position Audit Trail
Template	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Inventory Job Cost Details General Ledger Detail Profit and Loss Detail Cash Position
Terms	Sales Open Sales Orders Accounts Receivable Purchases Open Purchase Orders Accounts Payable Inventory Job Cost Details Cash Position Audit Trail
UofM	Sales Open Sales Orders Purchases Open Purchase Orders Inventory Job Cost Details
Vehicle	Job Cost Details Vehicle Mileage
Vendor	Accounts Receivable Purchases Open Purchase Orders Accounts Payable Inventory Job Cost Details Time Tracking Payroll General Ledger Detail Profit and Loss Detail Cash Position Audit Trail