Features
|
|
Visual query editor: Knowledge blocks provides you with a powerfull query
editor. Filter blocks are used to define filter criteria on individual table columns.
The color coding assigned to filter blocks is visible throughout the entire document,
allowing the user to easily identify which filters are active on result blocks.
Complex filtering can be created by connecting 2 or more filter blocks using a logical
block.
|
|
|
|
|
Present query results in different formats: Knowledge blocks provides three
types of result blocks to present data.
|
Users can attach multiple result blocks to defined filters, refine the filter and
attach further result blocks.
- Summary result block: displays 1 or more aggregations based on database columns
combined with text.
- Detail result block: displays results, with or without aggregations, in tabular
form.
- Parallel sets block: used to visualize and interactively explore categorical
data.
|
|
|
|
|
Database relationship designer: Database relationships can be challenging
to non-technical users. Knowledge blocks identifies and imports all relevant database
relationships. Using the library designer, users can edit existing and create new
relationships. The table relationship information is used by the system when connecting
and configuring blocks to ensure that only valid queries are generated.
|
|
|
|
Connect to different sources: Knowledge blocks allows you to connect to different
databse systems. The current version supports.
|
Microsoft SQL Server
|
 Microsoft
Access Database
|
 Microsoft
Excel files
|
 Text files
|
|
|