Vizubi 1.11: from Triadobatrachus to Prosalirus bitis the species evolves….

Version 1.11 (code name Prosalirus) is now available for your delectation.

Here are some of the highlights of changes for this version:

• Bookmarks (saved filters)
• Pivot Charts
• All relationships between tables are now Outer Joins
• Fully qualified field names
• You can create Slicers from the new panel window

For further details see below:

Bookmarks

Bookmarks are used to save filters that you think you will use frequently. Bookmarks can be applied in two ways:

1. Applying the bookmark will remove all active filters and apply the filters in the bookmark
2. Applying the bookmark will apply the filters in the bookmark in addition to current filters applied to columns on which the bookmark does not filter. Filters applied to columns in which the bookmark does filter will be replaced by those in the bookmark.

A flag in the window which opens when you create the filter lets you choose which type of filter you want to create.

Filters can be modified, deleted and replaced after they are created.

Additional formulas for creating calculated columns and improved usability

There are new formulas available for the creation of calculated columns. You can download an updated list with syntax rules here[link].

Labels removed from most elements

Panels, slicers, selections, relationships, reports, folders, formats, DB connections, bookmarks, no longer have labels, just names. This was done to make the interface more functional. Tables, Fields, Variables and Time Dimensions still have both names and labels.

Names can now contain spaces and special characters.

Old DBs will now show names only and labels will be removed.

Import Wizard Improved

When importing data, connections labels are shown (instead of names) when they have been created.

When importing a second table, the import wizard is automatically set to import the same type of data source (text file, excel etcetera) as the previous import.

Date fields are now shown with correct format.

Pivot Charts

It’s now possible to create a Pivot Chart directly from the new reports button without having to create a pivot table report first.You can create them on a different sheet, the same sheet or as Chart sheets in your workbook. The data which drives the chart is on a different worksheet and can be hidden. Pivot Charts are modified with the same interface you use for modifying reports.

Outer Join

Vizubi now treats relationships between tables as outer joins while previously relationships were treated as inner joins.

That means that all the records in the data you import are visible and usable; you’ll see what you haven’t sold as well as what you have. Products which have never been sold will be shown in reports which have the product field, while before you wouldn’t have seen those products at all. This may lead to unexpected results and in particular some reports may have columns with blank column headers and with zero values in the cells.

Vizubi creates an “unknown member” to handle all non-matching rows in relationships. If there are products with no product category assigned to them, a sales report by product category will include an unnamed column with the statistics for those products with no category summed together.

This is all transparent to the user.

Favorites

Vizubi now shows your last four and favorite four for reports, bookmarks and panels.

From the selection window for these three elements, you can use pushpins to leave up to four reports, bookmarks and panels permanently on the favorites list.

Fully qualified field names

You can select the source table of a field which exists on two tables when using that field in a report.

For instance, if you have a Prod_ID field in the facts table, when used in a report, the values for that field will only be those from the facts table (products you have actually sold). If you get the Prod_ID field from the products table, it will contain all the products in the products table even if they haven’t been sold (previously Vizubi only showed values present in the Facts table)

Name changes propagated throughout DB

If you change the name or label of a Table, the Panels with names which contain the same text can be changed automatically.

If you have a table named “Our Products” and a panel named “Our Products”, if you change the name of the table to “All Products”, Vizubi will ask you if you also want to change the name of the Panel.

Better Error Management

If there is an error in Vizubi, users can now decide to how send it to technical support; via e-mail, copy the error message to the clipboard and manually paste it into an e-mail, create a new post in the forum or do nothing.

Other Minor Improvements

• Slicers and Panels can now be hidden just like columns in tables.
• Report type can be changed between Pivot Table, Pivot Chart and Straight Table from the Vizubi Editor. This change will be applied the next time the report is opened or the next time you open a worksheet which contains the report.
• Improved look to Slicers and Data Filters
• Multiple select with CTRL-Click for move-up move-down of various elements in Editor
• Panel selections with single click-access (thanks Dominik for that one)
• Slicers can be created from the new panels window which means that you can add new slicers to a panel without having to leave the panels window, create your slicer and then go back into the panels window.
• When creating a new report, table nodes are collapsed by default for easier navigation.
• If you save a report with groups, the group which was active when the report was saved will be active when you open the report again.
• The active group is now highlighted in orange
• Better visibility of SQL statements when importing from a DB
• Tables which are in a relation with another table have an icon next to the column header used in the relation.

Sign up here to participate in our free beta test.

Vizubi – hop to itVersion 1.11 (code name Prosalirus) is now available for your delectation.

Here are some of the highlights of changes for this version:

• Bookmarks (saved filters)
• Pivot Charts
• All relationships between tables are now Outer Joins
• Fully qualified field names
• You can create Slicers from the new panel window

For further details see below:

Bookmarks

Bookmarks are used to save filters that you think you will use frequently. Bookmarks can be applied in two ways:

1. Applying the bookmark will remove all active filters and apply the filters in the bookmark
2. Applying the bookmark will apply the filters in the bookmark in addition to current filters applied to columns on which the bookmark does not filter. Filters applied to columns in which the bookmark does filter will be replaced by those in the bookmark.

A flag in the window which opens when you create the filter lets you choose which type of filter you want to create.

Filters can be modified, deleted and replaced after they are created.

Additional formulas for creating calculated columns and improved usability

There are new formulas available for the creation of calculated columns. You can download an updated list with syntax rules here[link].

Labels removed from most elements

Panels, slicers, selections, relationships, reports, folders, formats, DB connections, bookmarks, no longer have labels, just names. This was done to make the interface more functional. Tables, Fields, Variables and Time Dimensions still have both names and labels.

Names can now contain spaces and special characters.

Old DBs will now show names only and labels will be removed.

Import Wizard Improved

When importing data, connections labels are shown (instead of names) when they have been created.

When importing a second table, the import wizard is automatically set to import the same type of data source (text file, excel etcetera) as the previous import.

Date fields are now shown with correct format.

Pivot Charts

It’s now possible to create a Pivot Chart directly from the new reports button without having to create a pivot table report first.You can create them on a different sheet, the same sheet or as Chart sheets in your workbook. The data which drives the chart is on a different worksheet and can be hidden. Pivot Charts are modified with the same interface you use for modifying reports.

Outer Join

Vizubi now treats relationships between tables as outer joins while previously relationships were treated as inner joins.

That means that all the records in the data you import are visible and usable; you’ll see what you haven’t sold as well as what you have. Products which have never been sold will be shown in reports which have the product field, while before you wouldn’t have seen those products at all. This may lead to unexpected results and in particular some reports may have columns with blank column headers and with zero values in the cells.

Vizubi creates an “unknown member” to handle all non-matching rows in relationships. If there are products with no product category assigned to them, a sales report by product category will include an unnamed column with the statistics for those products with no category summed together.

This is all transparent to the user.

Favorites

Vizubi now shows your last four and favorite four for reports, bookmarks and panels.

From the selection window for these three elements, you can use pushpins to leave up to four reports, bookmarks and panels permanently on the favorites list.

Fully qualified field names

You can select the source table of a field which exists on two tables when using that field in a report.

For instance, if you have a Prod_ID field in the facts table, when used in a report, the values for that field will only be those from the facts table (products you have actually sold). If you get the Prod_ID field from the products table, it will contain all the products in the products table even if they haven’t been sold (previously Vizubi only showed values present in the Facts table)

Name changes propagated throughout DB

If you change the name or label of a Table, the Panels with names which contain the same text can be changed automatically.

If you have a table named “Our Products” and a panel named “Our Products”, if you change the name of the table to “All Products”, Vizubi will ask you if you also want to change the name of the Panel.

Better Error Management

If there is an error in Vizubi, users can now decide to how send it to technical support; via e-mail, copy the error message to the clipboard and manually paste it into an e-mail, create a new post in the forum or do nothing.

Other Minor Improvements

• Slicers and Panels can now be hidden just like columns in tables.
• Report type can be changed between Pivot Table, Pivot Chart and Straight Table from the Vizubi Editor. This change will be applied the next time the report is opened or the next time you open a worksheet which contains the report.
• Improved look to Slicers and Data Filters
• Multiple select with CTRL-Click for move-up move-down of various elements in Editor
• Panel selections with single click-access (thanks Dominik for that one)
• Slicers can be created from the new panels window which means that you can add new slicers to a panel without having to leave the panels window, create your slicer and then go back into the panels window.
• When creating a new report, table nodes are collapsed by default for easier navigation.
• If you save a report with groups, the group which was active when the report was saved will be active when you open the report again.
• The active group is now highlighted in orange
• Better visibility of SQL statements when importing from a DB
• Tables which are in a relation with another table have an icon next to the column header used in the relation.

Sign up here to participate in our free beta test.

Vizubi – hop to it