Access 256 Column Limitations

Modified on Sun, 26 Jul at 3:46 AM

Overview

Beginning with QQube 6.1, several Financial Summary data models were expanded beyond Microsoft Access's 256-column limit.

QQube provides alternative Microsoft Access FACT views that contain selected subsets of the original fields. These alternatives preserve the primary reporting functionality while remaining within the Access column limit.

Alternative FACT View Naming

FACT views ending in _MA are Microsoft Access replacements created for the 256-column limit.
FACT views ending in _MA_57 remain backward compatible with QQube 5.7.

Changes Introduced in QQube Version 10

QQube Version 10 added traditional Financial Summary data models that are aggregated by day and support custom calculations, including actual-to-date calculations.

Because users create the calculations they need, these models avoid the 256-column limitation.

QQube Version 10 daily Financial Summary data models

Financial Data Model Replacement Chart

Analytic	FACT View Used
Balance Sheet	vf_FINANCIALBS
Profit and Loss	vf_FINANCIALPL_MA
Profit and Loss	vf_FINANCIALPL_MA_57
Trial Balance (Current)	vf_FINANCIALTB
Trial Balance Activity	vf_FINANCIALTBA
Statement of Cash Flows	vf_FINANCIALCASH
Balance Sheet (Class)	vf_FINANCIALBSCLASS
Profit and Loss (Class)	vf_FINANCIALPLCLASS_MA
Profit and Loss (Class)	vf_FINANCIALPLCLASS_MA_57
Trial Balance Activity by Class	vf_FINANCIALTBACLASS_MA
Statement of Cash Flows by Class	vf_FINANCIALCASHCLASS
Profit and Loss by Job	vf_FINANCIALJOBYTD_MA
Profit and Loss by Job	vf_FINANCIALJOBRUNNINGTOTALS_MA
Profit and Loss by Class by Job	vf_FINANCIALJOBCLASSYTD_MA
Profit and Loss by Class by Job	vf_FINANCIALJOBCLASSRUNNINGTOTALS_MA
Profit and Loss with Actual/Budget/Forecast	vf_FINANCIALABF_MA
Profit and Loss by Class with Actual/Budget/Forecast	vf_FINANCIALABFCLASS_MA
Profit and Loss 52/53 Tax Year	vf_FINANCIAL5253
Profit and Loss by Class 52/53 Tax Year	vf_FINANCIAL5253CLASS

Changes Made for Microsoft Access

The following chart identifies which Financial Summary data models require an Access replacement and which fields were removed or separated.

Analytic	Access Status
Balance Sheet	No replacement.
Profit and Loss	Budget % of Sales columns were removed.
Trial Balance (Current)	No replacement.
Trial Balance Activity	No replacement.
Statement of Cash Flows	No replacement.
Balance Sheet (Class)	No replacement.
Profit and Loss (Class)	Budget % of Sales columns were removed.
Trial Balance Activity by Class	Last Period shortcut columns were removed. Ending Debit Budget Amount and Ending Credit Budget Amount were removed. Budget Ending Amount remains.
Statement of Cash Flows by Class	No replacement.
Profit and Loss by Job	One FACT view contains Year-To-Date fields without Running Totals. A second FACT view contains Running Totals without Year-To-Date fields.
Profit and Loss by Class by Job	One FACT view contains Year-To-Date fields without Running Totals. A second FACT view contains Running Totals without Year-To-Date fields.
Profit and Loss with Actual/Budget/Forecast	Actuals % Sales, Budget % of Sales, and Forecast % Sales columns were removed.
Profit and Loss by Class with Actual/Budget/Forecast	Actuals % Sales, Budget % of Sales, and Forecast % Sales columns were removed.
Profit and Loss 52/53 Tax Year	No replacement.
Profit and Loss by Class 52/53 Tax Year	No replacement.

Expected Result

Use the listed Microsoft Access FACT view for the selected Financial Summary analytic. The replacement views remain within Access's 256-column limit while retaining the primary reporting fields.