Bugfix: #4042 - Exporting LucaNet Values for BI Tools - 2.3.4

• Issue with fast extraction mechanism when using Drill-down by cost centers - specify hierarchy individually for an organisation element fixed.

Bugfix: #4042 - Exporting LucaNet Values for BI Tools - 2.3.3

• ExportTimestamp is not missing anymore for legacy facts data.

Bugfix: #4042 - Exporting LucaNet Values for BI Tools - 2.3.2

• LucaNet.Cloud JDBC driver is now recognized correctly in Lucanet version 25.1.

Bugfix: #4042 - Exporting LucaNet Values for BI Tools - 2.3.1

• Removed trailing space from column AverageExchangeRate of table ExchangeRate.

Enhancement: #4042 - Exporting LucaNet Values for BI Tools - 2.3.0

• Option added to specify whether the fiscal year starts in the previous year.
• Possibility added to read out partner information for formulas (preview feature).

Bugfix: #4042 - Exporting LucaNet Values for BI Tools - 2.2.10

• Column 'MonthName' in table 'Period' is now filled correctly when using a deviating fiscal year on the GUI.

Bugfix: #4042 - Exporting LucaNet Values for BI Tools - 2.2.9

• NumberFormatException for input String "*" fixed, when Calculate totals via SQL and  End period * was used.

Change: #4042 - Exporting LucaNet Values for BI Tools - 2.2.8

Shrink log file also when the app starts (Applies only to MS SQL).

Bugfix: #4042 - Exporting LucaNet Values for BI Tools - 2.2.7

A primary key error could occur if the option Export proportioning postings on cost center for proportioning was activated, the option Ensure referential integrity only for new exported data was deactivated, values for a proportioning cost center have already been extracted (legacy data) and values for a proportioning cost center were extracted with the current configuration. Duplicates are now filtered out correctly.

Change: #4042 - Exporting LucaNet Values for BI Tools - 2.2.6

Setting of a minimum required column format for the different dimensions tables in the transfer of the legacy facts. Without this, it would result in errors regarding missing table columns (Applies only to LucaNet 24)

Bugfix: #4042 - Exporting LucaNet Values for BI Tools - 2.2.5

Drop of foreign key works now, when the name of the foreign key contains a '+' and the option Ensure referential integrity only for new exported data is used. The '+' character of the name is taken from the used prefix.

Bugfix: #4042 - Exporting LucaNet Values for BI Tools - 2.2.4

Reference accounts inherit now the correct period type of the parent item when an item is referenced.

Bugfix: #4042 - Exporting LucaNet Values for BI Tools - 2.2.3

Removed entries for folders with child elements in account structure table.

Bugfix: #4042 - Exporting LucaNet Values for BI Tools - 2.2.2

The table on the tab Log is now filled correctly when PostgreSQL or Oracle is used as target database type.

Enhancement: #4042 - Exporting LucaNet Values for BI Tools - 2.2.1

Support for LucaNet.Cloud JDBC MSSQL driver (available from LucaNet 23.1)

Enhancement: #4042 - Exporting LucaNet Values for BI Tools - 2.2.0

Option added to use the beginning and end of the period of a data level by entering the character * as start and/or end period.

Option added to export the last X months by entering the expression LMX.

Bugfix: #4042 - Exporting LucaNet Values for BI Tools - 2.1.2

Option Delete data outside the period interval works now if option Ensure referential integrity only for new exported data is used.

Bugfix: #4042 - Exporting LucaNet Values for BI Tools - 2.1.1

Fast extraction mechanism for organisation groups works now for direct cost center references

Enhancement: #4042 - Exporting LucaNet Values for BI Tools - 2.1.0

Added column DefaultTransactionCurrency to the table OrganisationStructure.

Bugfix: #4042 - Exporting LucaNet Values for BI Tools - 2.0.5

Total calculation via SQL uses now the names of the selected attribute for the language.

Bugfix: #4042 - Exporting LucaNet Values for BI Tools - 2.0.4

The app tried to add the column RowFromLastExport a second time to the facts table if the option Ensure referential integrity only for new exported data is activated and the table DataLevel does not exist yet.

Bugfix: #4042 - Exporting LucaNet Values for BI Tools - 2.0.3

Fast extraction mechanism for organisation groups leads to a primary key error when extracting on cost center and accounting area level in one configuration, if an accounting area without cost centers exists.

Bugfix: #4042 - Exporting LucaNet Values for BI Tools - 2.0.2

Using the option Export proportioning postings on cost center for proportioning in combination with an accounting area without cost centers no longer leads to an error.

Bugfix: - #4042 - Exporting LucaNet Values for BI Tools - 2.0.1

Removed unnecessary warning messages for decimal number accounts under items of type currency amount. The implementation caused an exception in some cases.

(WARNING!) Important Information: #4042 - Exporting LucaNet Values for BI Tools - 2.0.0

Please make sure to read the following information before updating the App:

• This version of the app works with the following LucaNet versions or above: 
• LucaNet 22 LTS - 2111.0.78+7 - GA - 14/11/2022
• LucaNet 23 LTS - 2211.0.3+7 - GA - 14/11/2022
• Previous LucaNet versions are not supported!
• When using this app version (2.0.0) in combination with an SQL database that has already been filled by an older version of the app (1.X.X), irretrievable internal changes are made in the storage of the GUI-configurations in the SQL database, so that it is no longer possible to use an older version of the app (1.X.X) again.
• If the app is used in combination with the app #4043, this app must also be updated to app version 2.0.0.

Changes:

• Saving of the app configurations in the Prefix and MetaInfo tables
• The Period table was improved to improve the mapping of deviating fiscal years
• Reading balances beyond the time frame of the respective data level is no longer possible
• GUI design was customized
• The same data level can now be exported with different period intervals in one configuration

Enhancements:

The following functional enhancements have been made:

• Performance improvement when reading references
• Option to read separator lines in account hierarchies was added
• Option to create the Date table for day-based analysis of additional data not coming from LucaNet.Financial OLAP Server was added
• Option to inherit attribute values
• Option to exclude individual formulas and totals from export was added
• Option to export additional tables was added
• Possibility to ensure referential integrity only for new exported data
• Possibility to add a column for the export timestamp in the Facts table was added
• Possibility to delete only certain period intervals of the database content was added
• Possibility to display sample connection configurations was added
• Possibility to export the account hierarchy of a workspace without querying facts, by unselecting all types of account hierarchy elements for the given workspace and making no selection in the Transaction types column
• Possibility to calculate totals via SQL (preview feature)