Loading ...

Overcoming Access column limitations in QQube | CLEARIFY

Support Guides

Version 15

256 Column Limitations

0 
 /5
0 (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 FACT TABLE USED STATUS
Balance Sheet vf_FINANCIALBS
Profit and Loss vf_FINANCIALPL_MA Is Replacement
vf_FINANCIALPL_MA_57 Backwards Compatible
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 Is Replacement
vf_FINANCIALPLCLASS_MA_57 Backwards Compatible
Trial Balance Activity vf_FINANCIALTBACLASS_MA Is Replacement
Statement of Cash Flows vf_FINANCIALCASHCLASS
- - -
Profit and Loss by Job vf_FINANCIALJOBYTD_MA Is Replacement
vf_FINANCIALJOBRUNNINGTOTALS_MA Is Replacement
Profit and Loss by Class by Job vf_FINANCIALJOBCLASSYTD_MA Is Replacement
vf_FINANCIALJOBCLASSRUNNINGTOTALS_MA Is Replacement
- - -
Profit and Loss w Actual/Budget/Forecast vf_FINANCIALABF_MA Is Replacement
Profit and Loss (Class) Actual/Budget/Forecast vf_FINANCIALABFCLASS_MA Is Replacement
- - -
Profit and Loss 52/53 Tax Year vf_FINANCIAL5253
Profit and Loss (Class) 52/53 Tax Year 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

Support Guides Index

Pages