What's New in Version 8.10
The most important new features can be identified with the  icon.
Contents of this Page
·	InfoZoom and InfoZoom Product Variants
·	Data Import
·	Data Import Using the Database Wizard 
·	Researching Data
·	Analyzing Data 
·	Creating Reports and Charts
·	InfoZoom Office Add-Ins 
·	Command Line Parameters 
·	Sample Tables
·	Licensing

InfoZoom and InfoZoom Product Variants
InfoZoom	New product name: InfoZoom Desktop
The InfoZoom product family as desktop version for final users is now managed as "InfoZoom Desktop".	
InfoZoom Desktop Viewer Plus	Changed functionality: InfoZoom Desktop Viewer Plus with new licensing model
The InfoZoom Desktop Viewer Plus is now available as product variant subject to licensing in addition to the following product variants:
·	InfoZoom Desktop Explorer
·	InfoZoom Desktop Business
·	InfoZoom Desktop Professional
Depending on your licensing module, the licensing can be done by activation codes or dongles.	
Data Import
Data Import Using the Database Wizard
Compiling Data	Changed interface: Toolbars for functionalities for data sources
The interface has been remodeled. The following menus have been dropped:
·	File menu
 There were already buttons for the menu items.
·	Edit menu
 There was already a button for the menu item.
·	Properties menu in the windows of the source tables
  Some of the dropped menu items did not have any buttons yet. These have been added. 
Dropped Menu Items	
New Buttons	

Data Source | SQL Options	

Data Source | CSV Properties	

Data Source | Data Fields	

Data Source | Refresh Schema	

The arrangement of the buttons has been optimized. Functionalities for data sources are now available on the left window area for each data source. The buttons and context menus for functionalities for single source tables can still be found in the right window area.	
	New functionality: Numbering data sources and source tables
When being added, the data sources and corresponding source tables are numbered for the sake of unambiguous identification. The table numbers are displayed together with the table names in the preview of the compilation.
In source tables from database systems and MS Access files, the table numbers can be used instead of the table names in the SQL statement. For this purpose, the new Use Table Alias check box has been added to the SQL options of the data sources.
Topic: Compiling Data	
Adding Data Sources	New functionality: Assigning alias names to fields
When selecting the fields from a data source you may assign a name different from the original name (alias name) for each field (table column). In this context, the Alias column has been added to selection of fields in the overview. The purpose of the alias names is, for example, to identify fields that are used several times in the compilation of data in database systems and MS Access files.
In addition, you can choose to have quotation marks around the alias names in the SQL statement in source tables from database systems and MS Access files. For this purpose, the new Quotes for Alias Names check box has been added to the SQL options of the data sources.
The alias name is displayed together with the original name in the preview and is later adopted into the InfoZoom table as an attribute.
Topics:
·	Selecting Database Tables and Database Views
·	Adding CSV or Other Text Files as Data Sources	
Using Databases as Data Sources	New functionality: Using database tables multiple times
Depending on the data set required for an analysis in InfoZoom, you can use data from database tables or database views multiple times in a compilation. For instance, this allows you to build relationships between data coming from the same database table.
Topic: Using Database Tables Multiple Times	
Finding Database Tables and Database Views 	New functionality: Finding database tables and database views with search texts
You can narrow the lists of tables and views with search texts in order to faster find the desired tables or views.
Topic: Selecting Database Tables and Database Views	
Selecting Database Tables and Database Views	New functionality: Selecting database tables and database views with check boxes
Tables or views can now be selected with check boxes individually or as groups.
Topic: Selecting Database Tables and Database Views	
Specifying SQL Options	New functionality: Specifying the formulation of the SQL statement for links
Links created between source tables of a data source are initially formulated as nested in the SQL statement. In order to simplify the structure of the SQL statement, you can now specify another kind of formulation. For this purpose, the Join Generation (JOIN) option group has been added to the SQL options of the data sources.
Topic: Join Generation (JOIN)	
Changing Connection Data 	New functionality: Changing the connection data of database systems and MS Access files
Until now, it was only possible to change connection data of CSV or other text files. You can now also change the connection data of database systems and MS Access files. A change may be necessary, for example, if the database being addressed was moved to another server and the data for the access to the server therefore need to be adjusted.
Topic: Changing Connection Data of Data Sources	
Researching Data
Defining Queries	Expanded functionality: Using report or chart templates
You can now assign several report or chart templates in a query.	
Analyzing Data
Define Derived Attributes	New functionality: Assigning or withdrawing permissions for the display of definitions
With the new Display Definition permission you can suppress the display of the definitions of the following derived attributes:
·	Derived attributes with summaries
·	Derived attributes with formulas
·	Derived attributes with classifications
·	Derived attributes with case differentiations
With the permission you can prevent other users from viewing or changing formulas entered by you, for example. As a result, the Redefine Attribute or Insert New Attribute window is not opened for a derived attribute when the permission is not assigned.
The permission also determines whether the definitions of the derived attributes are displayed as follows:
·	In the metadata of the table
·	In the settings of the table
Topic: Permissions	
Defining Derived Attributes with Summaries 	New functionality: Defining attributes via buttons in the ribbon
You can now conveniently define derived attributes with summaries via buttons in the ribbon. For this purpose, the different summaries (functions) have been grouped by calculation method and the corresponding button has been added to the ribbon. When clicking the button the corresponding summaries are listed.
The following buttons have been added:
·	 Sum
·	 Percentage
·	 Statistics
·	 More
Topic: Defining Derived Attributes with Summaries	
Defining Derived Attributes with Formulas	New functionality: Defining attributes via buttons in the ribbon
For defining derived attributes with simple computing operations, the corresponding buttons are now available for frequently used operators in the ribbon.
The following buttons have been added:
·	 Compare
·	
·	
·	
·	
Topic: Defining Derived Attributes via Buttons	
	Expanded function: Number
Converting strings into numbers with the function "Number" has always been done according to the decimal system, i.e. to the base of 10. Now it is also possible to convert according to further place-value systems. For this purpose, the optional parameter "base" has been added to the function, which allows you to determine the base for the conversion.
Topic: Number	
	Changed notation: Function names are now written in CamelCase, e.g. "ENDSWITH" has been changed to "EndsWith".
The change does not affect the use of the functions.	
Defining and Redefining Analysis Groups	Changed functionality: Using derived attributes in analysis groups
Derived attributes in analysis groups that depend directly or indirectly on aggregates are no longer entered as dimensions (). This way, you can continue working with the aggregates without the occurrence of cyclical dependencies. For example, you can form the sum of two aggregates. The resulting attribute can remain in the analysis group. Until now, this type of attribute was inserted outside of the analysis group to prevent cyclical dependencies.	
Color Analysis	New field: This attribute determines all colors of its attribute group
When conducting a color analysis you can now decide whether the colors defined for the current attribute are not used for all attributes of the table, but only for the attributes of its attribute group or analysis group.
When the colors of an attribute are only used for the attributes of its attribute group and the Bold Values and Lines check box is checked, the values and lines are in bold font only in the attributes of the attribute group.
Topic: This Attribute Determines All Colors of its Attribute Group	
	New functionality: Simple color analysis
With the help of the simple color analysis you can now easily change the medium range as well as the colors of a color analysis with the classes "low", "medium" and "high". For this purpose, a special window is opened which only contains elements for changing these settings. Thus, this window provides an easier handling in contrast to the standard window for color analysis.
Topic: Simple Color Analysis	
Share Analysis 	New functionality: Share analysis
The share analysis provides you with a quick overview on the weighting of an attribute's values (reference quantity) in relation to the values of further attributes (dimensions). This allows you to view the share of the sum of the values from the reference quantity for each dimension.
Topic: Share Analysis	
Table Metadata 	New metadata: Information about queries
The following attributes have been added to the attribute group "Queries":
Attributes	
Explanations	

Queries	
Attribute group for summarizing information on queries.	

Number	
Number of queries in the original table.	

Query Names	
List with the names of queries in the original table. 
 The list may contain a maximum of 254 names. If the original table contains more than 254 queries, "..." is displayed after the last name.	

	New metadata: Information about attribute values
The following attribute has been added to the "Value Information" attribute group:
	
Explanations	

Maximum Value Length	
Number of characters of the longest attribute value per attribute in the original table. 
Blanks count as characters.	

Table Properties	New properties: Information about queries
The following properties have been added:
Properties	
Explanations	

Queries	
Attribute group for summarizing information on queries.	

Number	
Number of queries in the original table.	

Query Names	
List with the names of queries in the original table.	

This information is only displayed if the original table contains queries.	
	New property: Information about attribute values
The following property has been added to the main header "Attributes":
	
Explanations	

Maximum Value Length	
Number of characters of the longest attribute value per attribute in the original table. 
Blanks count as characters.	

Creating Reports and Charts
Interface of the Report and Chart Component	New functionality: Hiding menu bars and status bars
You can now decide whether the menu bars and status bars are hidden or shown in the windows of the internal reports and charts. For this purpose, the Menu Bars check box has been added to the View tab. 
Topic: Menu Bars	
Internal Charts	Expanded functionality: Design of the standard template adapted
The design of the standard template for internal charts has been adapted to the design of the InfoZoom table.	
InfoZoom Office Add-Ins
InfoZoom Excel Add-In 	New functionality: Exporting data from Excel to InfoZoom
You can now export data from Excel tables to InfoZoom.
Topic: Exporting Data from Microsoft Excel to InfoZoom	
Command Line Parameters
Command Line Parameters for Entering a Data Source	New command line parameters for ODBC and OLE DB data sources
-dbwizarduid	
Username for Login	

-dbwizardpwd	
Password for Login	

Topic: Login Data for ODBC and OLE DB Data Sources	
Command Line Parameters for Working with the Data 	New command line parameter -metadata for creating the metadata of a table	
Sample Tables
Sample Tables	Changed sample tables
ErsteBundesliga.fox	
The delivery of InfoZoom Desktop includes the "Erste Bundesliga.fox" sample table ("Bundesliga" directory). Data about the German Bundesliga season 2011/12 has been added to the sample table.	

FormulaOneSample.fox	
The delivery of InfoZoom Desktop includes the "FormulaOneSample.fox" sample table ("FormulaOne" directory). Data about the Formula 1 season 2011 has been added to the sample table.	

Revenue.fox	
The delivery of InfoZoom Desktop includes the "Revenue.fox" sample table ("Revenue" directory). The following have been added to the sample table:
·	"Top 5 Customers" initial query
·	"Superior" and "Personnel Number" attributes
·	"Share Analysis of Total Price" share analysis with the "Analysis of Specialists" and "Analysis of Industry" analysis groups	

 
Licensing
License Monitoring with Dongles	The delivery of InfoZoom Desktop now includes the new file "InfoZoom Protected Installation Instructions.pdf". The file contains detailed installation instructions for the product installations with dongles.