Loading ...

Overcoming Access column limitations in QQube | CLEARIFY

Support Guides

Version 22

256 Column Limitations

0 
 /5
0 (0votes)

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

Beginning with QQube 6.1 we expanded the columns for  Financial Summary Data Models - some of which have more than 256 columns by design. We have accommodated those cases with alternative Access data models containing specific subsets of information, which still keeps the primary functionality intact.

Further, we have included special data models to be backward compatible with QQube Versions 5.7 as they contain the same columns as what was included in those versions.

NOTE QQube 5.7 will be sunsetted February 1, 2023

Changes in Version 10

Version 10 added several traditional financial summary data models where you can create your own calculations.  They are aggregated by day, and allow actual "To Date" types of calculations.

These will obviously negate the need for worrying about 256 columns - because you will create the calculations you need.

Financial Data Model 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 5.7

 

ANALYTIC FACT TABLE USED
Balance Sheet vf_FINANCIALBS
Profit and Loss vf_FINANCIALPL_MA
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
vf_FINANCIALPLCLASS_MA_57
Trial Balance Activity vf_FINANCIALTBACLASS_MA
Statement of Cash Flows vf_FINANCIALCASHCLASS
- -
Profit and Loss by Job vf_FINANCIALJOBYTD_MA
vf_FINANCIALJOBRUNNINGTOTALS_MA
Profit and Loss by Class by Job vf_FINANCIALJOBCLASSYTD_MA
vf_FINANCIALJOBCLASSRUNNINGTOTALS_MA
- -
Profit and Loss w Actual/Budget/Forecast vf_FINANCIALABF_MA
Profit and Loss (Class) Actual/Budget/Forecast vf_FINANCIALABFCLASS_MA
- -
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