Generic filters
Exact matches only
Search in title
Search in excerpt
Search in content
Bissantz Bixel

What's new in DeltaMaster

released on August 18th 2023

DeltaMaster 6.5.3 makes it even easier to organize report distribution: With a new maintenance application, publisher jobs can be managed conveniently – using DeltaMaster itself. The clear access to the jobs with their numerous settings and the familiar functions such as filter, search, sorting and links make it easier to handle even a large number of jobs. In the time series analysis, the X-axis can now be defined dynamically. This allows for controlling the displayed time interval by selecting the current period.

All features in detail
  • General: executing database queries via DeltaMaster Service instead of Windows client
  • Licensing: using license codes according to July 2023 license model
  • Publishing: storing FTP password encrypted and referencing it in address using variable (@PWD)
  • Publishing: maintaining Publisher jobs in DeltaMaster using maintenance application (Publisher Maintenance Application.das)
  • Time Series Analysis: defining x-axis dynamically using named set

Notice: Windows client and DeltaMaster Service must be run in the same version.

released on July 28th 2023

DeltaMaster 6.5.2 extends the architecture of the Windows client: Database queries can now also be executed via the DeltaMaster service (three-tier architecture), as has already been the case with the web client. Further improvements include: A help page can be stored for each report in order to offer users, for example, manuals, further information or even an external web application. Viewing ratios of higher-level members has become easier: Ratios are automatically displayed in the status bar. A new, interactive scaling variant for bars in graphical tables helps to focus the comparison on members of a certain level.

All features in detail
  • General: executing database queries via DeltaMaster Service instead of Windows client
  • General: adding help page to report
  • Browsing: optionally disabling Browse function in application
  • Geo Analysis: using finer zoom levels
  • Graphical Table: displaying share of parent members in status bar
  • Graphical Table: scaling bars locally
  • Graphical Table: disabling link and navigation context menu temporarily using Ctrl+M keyboard shortcut
  • Graphical Table (relational): inheriting member property filter on drill-down in parent-child hierarchies
  • Modeling (relational): adding SQL queries without selecting tables beforehand

released on July 28th 2023

DeltaMaster 6.5.1 brings functional and technical improvements, among others: Modeling a dimension that aggregates key figures or accounts, for example in a profit and loss statement (P&L), has become even more flexible. Data entry via SQL drill-through is now also possible in OLAP applications with an attached relational model, for example, for control tables in planning applications. A new variant for searching and filtering dimension members speeds up the use of large dimensions in Microsoft Analysis Services. With Amazon Athena and SAP ABAP SQL Service, two additional relational data sources are supported. And a new authentication method is available for using the Bissantz Service in conjunction with Publisher.

All features in detail
  • Export: referencing user name in templates using variables (@username, @domainuser)
  • Microsoft SQL Server Analysis Services: searching for member key or name accelerated
  • Modeling (relational): defining factor and sign in level-based hierarchies
  • Planning (relational): using hybrid procedures for writeback
  • Publishing: authenticating to Bissantz Service using Personal Access Token (PAT)
  • SQL Drill-Through: enabling data input and writeback in OLAP applications with attached relational model
  • SQL Drill-Through: creating reports configured by Application Designer automatically
  • Setup: installing DeltaMaster optionally without GoToAssist
  • Access to Amazon Athena using ODBC driver
  • Access to SAP ABAP SQL Service using ODBC driver

released on February 20th 2023

DeltaMaster 6.4.9 and 6.5.0 mark a technical milestone: Communication between clients and services has been switched to Web API. This improves the security of web-based DeltaMaster applications and facilitates their use in distributed environments. Functionally, the two versions are identical. Among other things, they bring improvements in the presentation of typical financial reports, in planning and in relational applications.

All features in detail
  • General: repository access switched to ASP.NET Web API (Windows client, Office add-ins)
  • all features from DeltaMaster 6.4.9

Notice: DeltaMaster 6.4.9 and 6.5.0 are functionally identical, the differences are technical. DeltaMaster 6.4.9 communicates via WCF, DeltaMaster 6.5.0 via Web API.
Clients and services must use the same technology. Please refer to the notes on the changeover in the Release Notes (online help).

released on February 17th 2023

All features in detail
  • Graphical Table: disabling navigation in presentation mode
  • Mobile Report: selecting file path for export
  • Mobile Report: assigning different aliases to repeated columns
  • Planning: resolving calculated members in period view dimension of hybrid planning applications
  • Modeling (relational): using calculated members that define sets of members more flexibly
  • Publisher: storing log file in standard log file folder
  • SQL Drill-Through: enabling multiple selection for data drill-through based on stored procedure
  • Access to Microsoft SQL Server 2022 (Database Engine and Analysis Services)

released on December 9th 2022

Improvements in DeltaMaster 6.4.7 include functions for the display and interactive use of typical financial reports, such as BWA (“Betriebswirtschaftliche Auswertung”, a standard financial statement widely used in German speaking countries).

All features in detail
  • General: deactivating generation of log and trace files using Registry keys
  • General: using Microsoft Edge (WebView2) instead of Internet Explorer as rendering component (URL View, extension menu)
  • Report List: displaying long report list title in tool tip
  • Graphical Table: using calculation scheme to determine indentation in inverted parent-child hierarchies
  • Help: opening language-specific web-based online help
  • SQL Drill-Through: resolving time analysis member to report filter when accessed via link

Notice: The next DeltaMaster version will be provided as a dual release – the next stage of the changeover to ASP.NET Web API, as explained in DeltaMaster Feature Notes 6.4.2.

released on October 19th 2022

DeltaMaster 6.4.6 allows for attaching the relational model in the cloud (Microsoft Azure Analysis Services, Power BI) and for tabular models of Analysis Services. This enables hybrid applications that link OLAP structures with the relational database, for example, to access document data via SQL drill-through. For time series analyses, a new, automatically generated representation is available that combines an attractive appearance with the flexibility, dynamics and robustness of graphical tables.

All features in detail
  • Report List: editing title of report list
  • Graphical Table: automatically formatting and labelling time series on column axis (Magic Button “Graphic/Auto”)
  • Graphical Table (relational): inverting hierarchy
  • Microsoft Azure Analysis Services: attaching relational model
  • Microsoft Power BI: attaching relational model
  • Microsoft SQL Server Analysis Services: attaching relational model for tabular models
  • Modeling: defining factor for calculated members
  • Modeling (relational): adhering to factor and sign of members in aggregations in parent-child dimension
  • SQL Drill-Through: displaying unrelated dimensions in report filter in gray (Edit mode)

released on August 19th 2022

DeltaMaster 6.4.5 once again improves and accelerates planning. For the DeltaApp, time series can now also be provided for deviations and cumulations. A new option for number formatting enables particularly compact graphical tables.

All features in detail
  • Graphical Table: displaying numbers in uniform compact format, in thousands, millions, or billions
  • Mobile Report: exporting member properties
  • Mobile Report: exporting sparklines for comparisons and cumulations
  • Planning: using fast input (for blockwise inserting data, e.g. from Microsoft Excel)
  • Planning (relational): allowing data input in report depending on SQL condition

released on June 24th 2022

One focus of DeltaMaster 6.4.4 is planning based on relational databases such as Microsoft SQL Server and Microsoft Azure SQL Database. Thus, cell comments are now also available there and data entry can be made dependent on cell conditions in SQL. Data entry becomes as convenient as it is known from OLAP applications: users can now also enter relative value changes, like “10%+”, and work with application-specific operators that automate the distribution of values, for example (provided that the stored procedures are extended accordingly on the project side). For all types of databases, the development of day-specific applications, for example for the DeltaApp, has become easier: through a central definition of the day level. And the PowerPoint add-in has also been enhanced: with an option for finer control of the overlaying of report components.

All features in detail
  • Graphical Table (relational): defininig conditions for links
  • Modeling: defining current period using user-defined expression with “Today” (Logic)
  • Modeling: defining day level (Logic)
  • Modeling (relational): referencing dimension members using variable in user-defined measures
  • Modeling (relational): modeling views created by DeltaMaster ETL using AutoModel
  • Planning (relational): defining conditions for input cells in Graphical Tables
  • Planning (relational): entering values using standard and application-specific operators
  • Planning (relational): reading and writing cell comments
  • PowerPoint Add-in: defining z-order using field codes

released on April 14th 2022

DeltaMaster 6.4.3 brings significant simplifications for building reports that dynamically adapt to the current period. Typical reporting rhythms, for example, the changeover of the reporting period on a certain key date, can now be formulated with simple, almost natural language expressions. When distributing reports with DeltaMaster Publisher, you can also use them to define report updates more easily and flexibly. Two specialties of DeltaMaster’s Graphical Tables can now be used in combination: table wrap and semantic zoom in sparklines. And the development of applications based on Microsoft Power BI is accelerated by automatisms for modeling the time dimension, which is incomplete in many Power BI datasets. DeltaMaster closes the gaps and maps time as required for professional applications.

All features in detail
  • General: using user-defined expressions as variables in names and captions
  • Filter Context: defining default selection in time dimension using user-defined expressions with “Today”
  • Graphical Table: using user-defined expressions in filter queries for time dimension (Settings, Filter)
  • Graphical Table: using semantic zoom in tables with table wrap
  • Graphical Table: cycling through scaling options using F12 key
  • Graphical Table: wrapping table using “Wrap” Magic Button
  • Microsoft Power BI: optionally creating virtual time dimension automatically when creating application
  • Modeling: maintaining technical member name patterns in time dimension (Level Properties)
  • Modeling: creating perspectives for measure groups automatically
  • Publisher: using user-defined expressions with “Today” in report update
  • Web Client: communication with DeltaMaster Service changed to ASP.NET Web API

released on April 13th 2022

DeltaMaster 6.4.2 provides a new analysis method: distribution analysis. It can be used to examine frequencies, create histograms and calculate statistical measures. The modeling of relational applications is even more flexible thanks to new expressions for dynamic time comparisons. The web-based online help is now context-sensitively linked to the user interface, making it even easier to use. Further improvements concern geo analysis, the repository and the web client.

All features in detail
  • Geo Analysis: view component updated
  • Help: web-based online help is context-sensitive
  • Help: opening web-based online help using standalone launch app
  • Modeling (relational): new user-defined expressions for time analysis members available – Descendants, Children, First, Last
  • Planning: new keyboard shortcuts for copying and moving value structures
  • Repository: anonymizing or pseudonymizing user names in logs
  • Distribution Analysis: available as new report type
  • Web Client: calculating sum, count, and average of selected cells in Graphical Tables

released on December 23th 2021

DeltaMaster 6.4.1 connects Bissantz and Microsoft Power BI, which can now be connected as a data source. With Amazon Redshift, DeltaMaster supports a widespread cloud-based data warehouse and with PostgreSQL another open source database system. Class boundaries can be defined in ABC analysis, which is used in risk analysis, among other things. And users in all roles are pleased with a new, web-based online help with full text search: the Bissantz Help Center.

All features in detail
  • Concentration Analysis: defining class boundaries between ABC classes
  • General: using web-based online help – the Bissantz Help Center
  • Mobile Report (relational): exporting mean values
  • Planning: adding user name and time stamp to report comments automatically
  • Repository: using local connection strings and table names when working with application subscriptions
  • Access to Amazon Redshift using ODBC driver
  • Access to Microsoft Power BI
  • Access to PostgreSQL using ODBC driver

released on October 15th 2021

DeltaMaster 6.4.0 improves the interaction with the Bissantz DashBoard. In relational applications, there are new possibilities to design reports dynamically and to unify the “look and feel” in planning.

All features in detail
  • Graphical Table (relational): defining starting period for sparklines using user-defined expression
  • Mobile Report: using technical table and column names for export
  • Mobile Report (relational): defining starting period for sparklines using user-defined expression
  • Planning (relational): coloring input cells gray in Graphical Tables
  • Repository: integrated Planning license for Repository Maintenance application
  • Maintenance dialog: activating or deactivating gray coloring for input cells in relational applications (Compatibility tab)

released on September 17th 2021

Version 6.3.9 improves support for Microsoft Azure, making it easier to develop business intelligence applications in the cloud. Microsoft Azure Analysis Services can now also be addressed directly, and authentication via Active Directory is possible for Microsoft Azure SQL Database. The expressions for dynamic calculations along the time dimension, which are very useful in relational applications, have become more powerful once again. Additional database connections, such as for writing back and comments in connection with planning, can now be viewed and edited in a central location.

All features in detail
  • Modeling (relational): using user-defined expressions for time analysis members in calculated members directly
  • Modeling (relational): new user-defined expressions for time analysis members available – first child, last child
  • Publisher: repeating job execution if application is locked
  • Repository: defining user group assignment rules in maintenance application
  • Maintenance Dialog: editing additional database connections
  • SQL Drill-Through: adjusting display column width in detail view dynamically
  • Access to Microsoft Azure Analysis Services
  • Access to Microsoft Azure SQL Database using Active Directory authentication

released on June 11th 2021

The current release presents itself with a redesigned portal and tiles that can also accommodate longer labels thanks to a second line. With Snowflake, another widely used relational data source is supported.

All features in detail
  • General: displaying DeltaMaster version number in title bar
  • Graphical Table: displaying line break in column header in quick view of web client
  • Mobile Report: exporting time span format of measures
  • Parent-Child Editor: defining selectability of drop-down list items using SQL query
  • Portal: new design
  • Access to Snowflake using ODBC driver

released on April 16th 2021

A number of improvements affect the display of sparklines. For example, intelligently indented guides increase readability and emphasize the integrable, comparable scaling. New data sources from Google and IBM can be connected. And in mobile reports, data can now be provided to the Bissantz DashBoard in incomplete hierarchies, as you often get from external sources (for example, market data for selected countries that add up to less than the total available for the world)

All features in detail
  • Export: avoiding to open export documents automatically
  • Export: “Generating” preset as standard export method in new installations
  • Graphical Table: dynamically labeling line sparklines
  • Graphical Table: displaying line sparklines comparably with grid lines
  • Graphical Table: displaying line sparklines using raster
  • Graphical Table: drawing column graphics space-savingly
  • Graphical Table: omitting days without data in sparklines
  • Graphical Table (relational): extending sparklines beyond current period using plan or forecast data
  • Mobile Report: assigning aliases to columns
  • Mobile Report: exporting incomplete hierarchy with pre-aggregated All member
  • Modeling (relational): referencing report filter in user-defined time expressions
  • Modeling (relational): displaying unrelated dimension in filter bar if referenced by variable
  • Publish: uploading job result to Bissantz Service (distribution type “bissantzservice”)
  • Access to Google BigQuery using Magnitude Simba ODBC driver
  • Access to IBM Cognos TM1 (IBM Planning Analytics) in cloud environment

released on March 22th 2021

The current release expands the options for working with relational data. DeltaMaster now supports interfaces for direct access to Salesforce. This allows relational applications to be created with Salesforce data without having to extract it first. Support for tabular models in Microsoft SQL Server Analysis Services has been enhanced to allow procedure calls when SQL is traversed. And creating mobile reports for the Bissantz DashBoard has become even easier with a new Magic Button organization that automatically checks the combination of comparisons.

All features in detail
  • General: Microsoft .NET Framework 4.8 required
  • Graphical Table: referencing user name in external links using variables (@@User, @@Current_User)
  • Microsoft SQL Server Analysis Services: configuring „Real Time Olap“ property per report (Report Properties)
  • Microsoft SQL Server Analysis Services: attaching relational model for Tabular Models
  • Mobile Report: naming dashboards after parent folders when exporting nested folders
  • Mobile Report: Magic Buttons simplified
  • Mobile Report: checking reasonable combination of comparisons
  • Modeling (relational): showing and hiding values for unrelated dimensions and levels („Ignore Unrelated Dimensions“; Measure Properties)
  • Repository: editing application description in Maintenance Application
  • Repository: reviewing application, folder, and report rights in Maintenance Application
  • SQL Drill-Through: referencing user name in external links using variables (@@User, @@Current_User)
  • Access to Salesforce using Simba ODBC driver

released on February 15th 2021

An extension of the role model facilitates “self-service” in the business departments: Report editors can edit reports and analyses; modeling of key figures, hierarchies and other similar things is reserved for application editors. An additional cache accelerates OLAP applications. Planning applications used via the web browser run faster thanks to Quick View, which now also allows data to be entered. And editing mobile reports in DeltaMaster is more oriented to the presentation in the app, the Bissantz DashBoard.

All features in detail
  • General: using cache for MDX queries (Options/System)
  • General: optionally displaying main menu bar permanently (AppSettings)
  • Help: retrieving articles from Bissantz Research blog (in German version of online help)
  • Mobile Report: displaying history and exporting history data, if cumulation and reference values of variances are provided by means of measures
  • Mobile Report: grouping columns as displayed in DashBoard app
  • Mobile Report: defining start view for display in DashBoard app
  • Mobile Report (relational): providing cumulation and reference values of variances by means of measures
  • Multiples: exporting report in web client
  • Multiples: applying filter to all sub-reports in web client
  • Multiples: using value from a sub-report to filter the other sub-reports in web client
  • Multiples: using value from an SQL Drill-Through sub-report to filter the other sub-reports
  • Planning: executing external processing of planning data using link (target type: Database Command)
  • Planning: entering data in quick view of Graphical Tables in web client
  • Planning: entering values using application-specific operators
  • Repository: new role available, to separate editing and modeling (Report Editor/Application Editor)
  • SQL Drill-Through: reverting and restoring report operations using undo/redo function
  • SQL Drill-Through: starting data input using double-click
  • SQL Drill-Through: entering text in editor window
  • Webclient: Microsoft Edge Legacy (not based on Chromium) no longer supported