It is possible to import old NC Cube files (file name extension .nccx) via the import action. When importing an old NC Cube file, an attempt is made to import or convert as much information as possible from the file.
Please carefully check the correctness of the created evaluation after the import.
Following is no longer supported:
Excel Templates
Charts
Note: PivotCharts are still supported.
Cell Comments
Link/Page Link
"Output only if" (Data Sheet)
The following conversion options are available during import:
Automatic Formatting
Specifies whether the data should be transferred to Excel automatically formatted or whether all data should be transferred as text as before.
The settings can still be changed for each column after the import.
Translate Formulas from
Specifies whether to translate the Excel Function names of the Formulas into English Excel Function names.
Note
The function is available for the following languages: German, Danish, Italian, French, Spanish, Dutch, Finnish, Swedish, Hungarian, Polish and Czech.
For formulas to continue to work, the English Excel Function names, commas instead of semicolons and dots as decimal separators must be used.
The formulas can also be translated individually after the import.
Replace Semicolons in Formulas
Specifies whether to replace semicolons in Formulas with commas and Commas with dots.
Changed behavior for References in connection with Column Inheritance
The new system of column inheritance controls whether the columns of the parent table should be empty or not after a new row starts. In NC Cube, the 1:n JOIN - Fill field was responsible for this. However, in connection with with Formula IDs, there was a problem in NC Cube, which occurred mainly when the 1:n JOIN - Fill field was not activated.
Example
Note: This example is for explanation only and assumes a very simplified database in which only positive Customer Ledger Entries exist.
The following Data Sheet was created:
The following result was displayed in Excel after executing the evaluation:
The percentage value could not be calculated.
As the Formula Auditing shows, the dynamic references or the Formula IDs were converted as follows:
The row no. in the cell reference of the Formula ID [B] was thus also increased.
The new column inheritance creates the following result:
And therefore a correct calculation:
Important
Due to the changed column inheritance, the result of an imported NC Cube evaluation may differ from the result of the old NAV version.
Please check the formulas after the import and change the evaluation if necessary.
To restore the old NC Cube behavior in the example, the Formula =100 / [B] * [A] must be replaced by the formula =100 / [B:COL][ROW] * [A].
Manually convert FlowFilter loops
FlowFilter loops are no longer supported and cannot be automatically converted during import. The file can still be imported, but the settings of the FlowFilter loop(s) will be ignored.
After importing, the FlowFilter loops must be added manually as parent tables.
For more information, see Edit Evaluations, Data Sheets, Data Sheet.
Import old NC Cube files
The following result was displayed in Excel after executing the evaluation:
The percentage value could not be calculated.
As the Formula Auditing shows, the dynamic references or the Formula IDs were converted as follows:
The row no. in the cell reference of the Formula ID [B] was thus also increased.
The new column inheritance creates the following result:
And therefore a correct calculation:
