About InfoZoom
Service for InfoZoom
Viewing Information on Memory Usage
Keeping a Log File
InfoZoom quick guide in 5 steps
Operating InfoZoom
Function Comparison of Product Variants
License Monitoring with Dongles
License Agreement
Activating InfoZoom
Action logging
InfoZoom - Languages and Language Designations
Information About InfoZoom
About InfoZoom Online Help
Copyright
Privacy
Legal Notice
What's New in Version 2020
InfoZoom GUI
Tabs
Focus field
Info field
Attribute column
Status bar
Setting up the work environment
Options dialog
General tab in the Options dialog
Color Scheme tab in the Options dialog
Data Import tab on the Options dialog
Results tab in the Options dialog
Chart Colors tab in the Options dialog
Warnings tab on the Options dialog
Option Management tab on the Options dialog
Docking Windows to Other Windows
Reading in data
Selection Wizard
Data source
Using Excel Files as Data Sources
Mapping fields
Open
Initial Queries
Recent files/templates
Import Data
InfoZoom Text Format
Import File Structure Models
Object-Per-Record Model
Import/Export File Example
Attribute-Per-Object Structure
The Key Attribute in an Imported Infoscape
Text Import Dialog
Special Characters
Database Wizard
Adding Data Sources
Restricting data
Linking Data Sources
Using Databases Multiple Times
Changing the Compilation After Import
Troubleshooting During Data Compilation
SQL Wizard
InfoZoom Connect for Microsoft SQL
Opening a cube
Defining a selection
Icons
Selecting a dimension
Selecting a level
Defining restrictions
Selection information
Analyzing data in InfoZoom with drilldown and rollup
Rollup
Drilldown
Reloading Data
Updating or Appending from a File
Updating or Appending from a Database
Linking tables
Joining Tables
Guess Import Structure?
Creating new attributes during insertion
Visualizing data
Resizing the window
Arranging Windows
Changing the view
Wide Table
Setting the object column width (Wide Table)
Compressed Table
Setting the object column width (Compressed Table)
Overview
Combining Identical Initials
Table-Specific Color Scheme
Table-specific font
Changing the font size
Changing the header row height
Hide Tables
Hiding Selected Attributes
Hiding Not Selected Attributes
Hiding single-valued attributes
Hiding Empty Attributes
Hiding complete attributes
Show Hidden Attributes Again
Formats
Syntax for formats
Automatic Data Format Recognition
Data Format Recognition Sample: Numerical Values
Data Format Recognition Sample: German Date
Data Format Recognition Sample: English Date
Check all attribute formats
Edit Commands
Copy
Cut
Paste
Replace
Undo
Redo
Show Names of Imported Fields
Showing Changes
Sorting
Coupling Attributes in the Overview
Attribute groups
Inserting an Attribute Group
Creating date groups
Opening and closing attribute groups
Researching Data
Find
Find and Replace with Regular Expressions
Selecting Data
Focusing objects
Drilldown attributes
Value lists
Navigation Functions
Show Current Query
Browsing the history
Reset
Queries
Analyzing data
Attributes
Simple Attributes and Duplicates
Inserting Duplicates
Derived attributes
Link
Inserting link
Derived attributes with summaries
Functions for Simple Summaries
Functions for Summaries with Calculations of Percentages
Functions for Statistical Summaries
Functions for More Summaries
Summaries with the "List" function
Formula
Defining and redefining derived attributes with formulas
Formula editor
Functions and operators for formulas
% (Percent)
* (Multiplication)
** (Exponential Function)
+ (Addition / Concatenation)
- (Subtraction or Sign)
/ (Division)
< (Smaller)
<= (Smaller or Equal to)
<> or != (test for inequality)
= (Test for Equality)
> (Greater Than)
>= (Greater than or Equal to)
Abs
ACos
and
ASin
ATan
ATan2
Average
BeginsWith
CalendarWeek
CalendarWeekISO
Char
Code
Combin
ComputerID
Concatenate
Contains
ConvertGeoCoordinate
Cos
Count
Date
Day
DayOfYear
Degrees
Difference
Element
EndsWith
Exact
Exp
Fact
FileExists
Find
First
Fract
Hour
If
Illegal
Intersection
JDEJulianToDate
Last
Latitude
Left
Length
Ln
Log10
Longitude
Lower
Matches
MatchesDotNet
Max
Mid
Min
Minute
Mod
Month
not
Now
Number
or
Proper
Quarter
Replace
ReplaceMatch
ReplaceMatchDotNet
Repeat
ReverseList
Reverse
Right
Round
Second
SetEqual
Sin
Sort
SoundEx
Sqrt
Tan
Time
Today
Trim
Trunc
Undefined
Union
Upper
Weekday
Year
Classification
Case Differentiation
Derived attribute for multidimensional analysis
Calculate derived attributes
Automatic recalculation
Define and Redefine Attributes
Inserting Attributes
Moving attributes
Sorting attributes
Editing attribute values and names
Entering and Maintaining Comments on Attributes
Delete Attributes
Special cell contents
User-Defined Sorting
Link (Hyperlink)
Invoking a link
Image
List
Truth Values
Empty Attribute Values
Inserting an analysis group
Inserting a cross table
Attribute values determine column width
Interpret missing values as 0
Color analysis
Simple color analysis
Share analysis
Analysis with external parameters
Metadata of the table
Table Properties
Objects
Adding objects
Duplicating objects
Deleting objects
Display Changed Objects
Saving and Outputting Data
InfoZoom's Proprietary File Format
InfoZoom's Protected File Format
InfoZoom Templates
Save
Save as
Save copy as
Save objects as
Table Section as New Table
Table Section with a Random Sample as a New Table
Page Setup
Print Setup
Print preview
All on one page
Print
Copy Attributes
Protecting data
Protect Table
Permissions
Creating reports and charts
InfoZoom's report component
Creating a report
Using a report/chart as template
Opening a report/chart
InfoZoom's Internal Charting Component
Defining the style and color scheme of internal charts
Creating a Chart
Using a report/chart as template
Opening a report/chart
Updating reports and charts
Creating Reports with List & Label
Interactive charts
Excel Wizard
Excel for reports
Importing Data from Excel
Import Worksheet
Exporting Data to Excel
Generating an Excel Pivot Table
Example: Generating a Pivot Table from Raw Data
Example: Creating a Pivot Table from an Analysis Group
Export Worksheet
Processing the Destination File
Attribute Selection
InfoZoom Excel Add-In
InfoZoom OLE DB Provider
Known issues
InfoZoom .NET Data Provider
Publishing tables on the InfoZoom Anywhere server
Command line parameters
Syntax overview
Commands
Data source (command line parameters)
InfoZoom files as data sources
Creating Metadata (Command Line Parameters)
Creating a Random Sample (Command Line Parameters)
Closing a table (command line parameter)
Import files
ODBC and OLE DB data sources
Login data for ODBC and OLE-DB data sources (command line parameters)
Working with the data
Selections
Select attributes (command line parameters)
Joining two tables (command line parameters)
Linking Two Tables (Link) (Command Line Parameters)
Set dynamic filters (command line parameters)
Arrange the Tables Window (Command Line Parameters)
Reset Table (Command Line Parameters)
Save (Command Line Parameters)
Save (Command Line Parameters)
Save as (command line parameters)
Save copy as (command line parameters)
Save objects as (command line parameters)
Reports (Command Line Parameters)
Publishing Tables (Command Line Parameters)