BiX Software is proud to unveil BiXAnalytics version 7 for Microsoft Excel. Version 7 represents a major release for BiXAnalytics, with many new features giving unmatched power and productivity to the end user.
Among the many new features is the support of Excel calculations. This makes it easy for BiX 7 users to add a new column or row to an “InfoSet” and then type any Excel formula, including Vlookups. The “BiX Excel” formula then becomes dynamic and automatically adapts to the resizing of rows and columns and will be replicated by BiX when drilling into the dimensions.
These calculations are secure as the formula is being managed by BiX, they are truly dynamic and will no longer become wrong or obsolete during changes.
Improving the ease and efficiency of use was also a key priority in this version’s development cycle.
Two new options in the Excel ribbon now provide intuitive and direct access to most navigation and formatting options. These buttons appear or disappear depending on the active cell thus reducing clutter and irrelevant options.
Navigation and interactions have been sped up: The user can now quickly perform actions such as keeping or removing rows and columns, adding the selected member’s descendants, choose all members from a level or apply filtering options that have previously been saved.
New, more sophisticated filters can be applied just as easily. With a single click, it is now possible to automatically select the last period containing data, to add a certain number of previous periods or the YTD periods, and to display a 20/80 analysis on any dimension at any level.
Layout management has also been improved with brand new management options, it is possible to set a layout using native Excel controls in a single cell then, using the “apply” option in the ribbon, the user can define the range, the member or the level where this layout should be applied. Bix will then apply the correct format even if the number of rows or columns changes.
Label management has been upgraded. Once the labels have been modified, they can be saved with a single click on the “Apply” button of the “Label management” section.
Several other tools, such as the ability to copy labels from one “InfoSet” to another (or all those on the sheet), or the option to switch between displaying the original or modified labels enable common reporting issues to be easily addressed.
Finally. the performance of the new version has been greatly improved thanks to, among others, a new connection management which is now synchronised by default. This single change results in a vastly improved reactivity and significantly reduces Excel’s memory use.
Optimisations in the MDX query generator also offer considerable performance gains, particularly with regards to nested dimensions.