QQube Date Dimension Details

Version 50

Date Details

CLEARIFY® TEAM

Published: 3/5/2012

CLEARIFY® TEAM

Updated: 12/20/2022

0
19336

0 (0votes)

Handling Dates in QQube for QuickBooks

Calendar DIMENSIONS

QQube Technology contains special Date DIMENSIONS that allows for multiple variations of a single date, e.g. Weekday name, Month name, day in year, day in quarter.

There are two types of calendar dimensions:

One is for use in a DAX time pattern measure which allows you to drill down e.g. year-to- quarter-to-month, using transaction date.
The other is for dates that would primarily embellish the data on a report e.g. discount date, trip start date where you typically would not establish a drill down mechanism.

The first type is a combination of Calendar and Fiscal capabilities.

The second type is only calendar.

Document Single Dates

We also have single date fields, because tools like Microsoft Excel and Tableau have added dimension-like features directly in their tools, thereby abating the need for the QQube Date fields.

Power Calendars for PowerPivot and Power BI

For PowerPivot and Power BI it is always best to use the dimensions.

For more information on the special constructs we create for PowerPivot and Power BI, please peruse this guide: Calendar Dimensions | CLEARIFY

Available Calendar Dimensions

DIMENSION	DATA MODEL	TRANSACTION WHERE USED
52/53 Tax Year Dates	Sales Purchasing Inventory Management General Ledger Detail Profit and Loss Detail Audit Trail	QQube created
Asset Purchase Date Asset Sales Date Asset Warranty Date	Fixed Assets	Fixed Asset
Audit Trail Date	Audit Trail	Audit Trail
Billed Date	Sales Accounts Receivable Inventory Management Job Cost Details General Ledger Detail Profit and Loss Detail Audit Trail	Statement Charge
Due Date	Sales Open Sales Orders Accounts Receivable Purchasing Open Purchase Orders Accounts Payable Inventory Management Job Cost Details General Ledger Detail Profit and Loss Detail Cash Position Audit Trail Sales Tax (USA)	Bills Credit Memo Statement Charge Estimate Invoice Purchase Order Sales Order Sales Receipt Vendor Credits
Effective Payroll Date	Payroll	Paycheck Payroll YTD Adjustments Liability Adjustments Payroll Liability Check
Estimate Date	Job Cost Details	Estimates
Expected Date	Purchasing Open Purchase Orders Inventory Management Job Cost Details Audit Trail	Purchase Orders
Fiscal Year Dates	Sales Purchasing Inventory Management Job Cost Details General Ledger Detail Profit and Loss Detail Audit Trail
Forecast Date	Inventory Management	Combination Sales Order Ship Date Purchase Order Expected Date
Fully Paid Date	Sales Purchasing Inventory Management Job Cost Details General Ledger Detail Profit and Loss Detail	Invoice Statement Charge Bill
Job End Date Job Projected End Date Job Start Date	Sales Open Sales Orders Accounts Receivable Purchasing Open Purchase Orders Accounts Payable Inventory Management Job Cost Details Time Tracking Vehicle Mileage Payroll General Ledger Detail Profit and Loss Detail Cash Position Audit Trail	Job Information
Liability Period End Date Liability Period Start Date	Payroll	Payroll Liability Check
Pay Period End Date Pay Period Start Date	Job Cost Details Payroll	Paycheck Payroll YTD Adjustment Liability Adjustment Liability Check
Service Date (Line)	Sales Accounts Receivable Purchasing Open Purchase Orders Inventory Management Job Cost Details General Ledger Detail Profit and Loss Detail Cash Position	Invoice Credit Memo Sales Receipt Purchase Order
Ship Date	Sales Open Sales Orders Accounts Receivable Inventory Management Job Cost Details Cash Position	Invoice Credit Memo Sales Receipt Sales Order
Suggested Discount Date	Sales Accounts Receivable Purchasing Accounts Payable Inventory Management Job Cost Details Cash Position	Invoice Bill
Transaction Date	Sales Open Sales Orders Accounts Receivable Purchasing Open Purchase Orders Accounts Payable Inventory Management Job Cost Details Time Tracking Vehicle Mileage Payroll General Ledger Detail Profit and Loss Detail Cash Position Audit Trail	ALL except Vehicle Mileage and Fixed Assets
Trip End Date Trip Start Date	Job Cost Details Vehicle Mileage	Vehicle Mileage

Comments (no comments yet)

Add a new comment

QQube Date Dimension Details | CLEARIFY

Support Guides

Date Details

Handling Dates in QQube for QuickBooks

Calendar DIMENSIONS

Document Single Dates

Power Calendars for PowerPivot and Power BI

Available Calendar Dimensions

Comments (no comments yet)

Search Support Guides

Pages

QQube Date Dimension Details | CLEARIFY

Support Guides

Date Details

Share

Handling Dates in QQube for QuickBooks

Calendar DIMENSIONS

Document Single Dates

Power Calendars for PowerPivot and Power BI

Available Calendar Dimensions

Comments (no comments yet)

Search Support Guides

Pages

Loading ...