256 Column Limitations

Version 10

256 Column Limitations

CLEARIFY ®

Published: 10/28/2017

CLEARIFY ®

Updated: 11/28/2018

Avg: 0 / 5 (0votes)

How QQube deals with the 256 Column Limitation in Access for Financial Summary Analytics

QQube 6.1 contains a variety of Financial Summary Analytics - some of which have more than 256 columns by design. We have accommodated those cases with alternative Access analytics containing specific subsets of information, that still keeps the primary functionality intact.

Further, we have included special analytics to be backward compatible with Versions of QQube before 6.1 - they contain the same columns as what was included in those versions.

Access Financial Analytic Replacement Chart

This table shows when the alternative FACT tables come into play.

FACT tables ending with "_MA" are replacements that accommodate the 256 Column Limitation
FACT tables ending with "_MA_57" are backwards compatible with QQube versions previous to QQube 6.1

ANALYTIC	ACCESS EXAMPLE	FACT TABLE USED	STATUS
Balance Sheet	financial_statements_xx	vf_FINANCIALBS
Profit and Loss	financial_statements_xx	vf_FINANCIALPL_MA	Is Replacement
Profit and Loss	financial_statements_xx	vf_FINANCIALPL_MA_57	Backwards Compatible
Trial Balance (Current)	financial_statements_xx	vf_FINANCIALTB
Trial Balance Activity	financial_statements_xx	vf_FINANCIALTBA
Statement of Cash Flows	financial_statements_xx	vf_FINANCIALCASH
-	-	-	-
Balance Sheet (Class)	financial_statements_class_xx	vf_FINANCIALBSCLASS
Profit and Loss (Class)	financial_statements_class_xx	vf_FINANCIALPLCLASS_MA	Is Replacement
Profit and Loss (Class)	financial_statements_class_xx	vf_FINANCIALPLCLASS_MA_57	Backwards Compatible
Trial Balance Activity	financial_statements_class_xx	vf_FINANCIALTBACLASS_MA	Is Replacement
Statement of Cash Flows	financial_statements_class_xx	vf_FINANCIALCASHCLASS
-	-	-	-
Profit and Loss by Job	xx_job_ytd_xx	vf_FINANCIALJOBYTD_MA	Is Replacement
Profit and Loss by Job	xx_job_running_totals_xx	vf_FINANCIALJOBRUNNINGTOTALS_MA	Is Replacement
Profit and Loss by Class by Job	xx_job_class_ytd_xx	vf_FINANCIALJOBCLASSYTD_MA	Is Replacement
Profit and Loss by Class by Job	xx_job_class_running_totals_xx	vf_FINANCIALJOBCLASSRUNNINGTOTALS_MA	Is Replacement
-	-	-	-
Profit and Loss w Actual/Budget/Forecast	xx_actual_budget_forecast_xx	vf_FINANCIALABF_MA	Is Replacement
Profit and Loss (Class) Actual/Budget/Forecast	xx_actual_budget_forecast_class_xx	vf_FINANCIALABFCLASS_MA	Is Replacement
-	-	-	-
Profit and Loss 52/53 Tax Year	financial_pandl_5253_xx	vf_FINANCIAL5253
Profit and Loss (Class) 52/53 Tax Year	financial_pandl_5253_class_xx	vf_FINANCIAL5253CLASS

What Was Replaced

This explains what has been replaced to accommodate Access Limitations. (FACT tables with a suffix of "_MA")

ANALYTIC	STATUS
Balance Sheet	NO Replacement
Profit and Loss	Removed Budget % of Sales Columns
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)	Removed Budget % of Sales Columns
Trial Balance Activity	Removed "Last Period" shortcut columns. Removed Ending Debit and Credit Budget Amounts (Budget Ending Amount field remains)
Statement of Cash Flows	No Replacement
-	-
Profit and Loss by Job	One FACT table contains Year-To-Date (YTD) while excluding Running Totals (RT) and one FACT table contains Running Totals (RT) while excluding Year-To-Date (YTD) fields.
Profit and Loss by Class by Job	One FACT table contains Year-To-Date (YTD) while excluding Running Totals (RT) and one FACT table contains Running Totals (RT) while excluding Year-To-Date (YTD) fields.
-	-
Profit and Loss w Actual/Budget/Forecast	Removed Actuals % Sales, Budget % of Sales, and Forecast % Sales Columns
Profit and Loss (Class) Actual/Budget/Forecast	Removed Actuals % Sales, Budget % of Sales, and Forecast % Sales Columns
-	-
Profit and Loss 52/53 Tax Year	NO Replacement
Profit and Loss (Class) 52/53 Tax Year	NO Replacement

Comments (no comments yet)

Add a new comment

256 Column Limitations | CLEARIFY

How-To Guides