MIK-BIS Table Ultimate Edition
Complex tables made easy
Presenting and reporting figures clearly: MIK-BIS Table Ultimate Edition helps the user do this by combining high functionality with user-friendly operation. The module presents data clearly and provides a large number of BPM analysis functions without the need for extra programming.
MIK-BIS Table Ultimate Edition greatly reduces time and expenses for generating and maintainig tables while providing professional WIN and WEB tables with high contextual and optical quality. Tables with complex logic can be created in an hour rather than over the course of severalö days. The central component of MIK-BIS Table Ultimate Edition is the new table designer which significantly simplifies the defintion of rows and columns in tbales.
In addition, some 120 predefined formulas are available, including financial, statistical, date/time, mathematical and logic formulas. The user can also define his own formulas for including custom calculations in the table. In addition, the tables can be conveniently customised to give the required look. Thanks to a full range of formatting options, figures can be presented in a clear, informative and attractive form.
Instead of producing static views, MIK-BIS Table provides highly versatile analyses from which the user can extract exactly the information he requires with just a few mouse clicks. Similar to the MIK-BIS Graphics module, the data display can be changed by drill-down, drill-up or Slice and Dice, for example.
Tables always contain real-time information thanks to the direct connection to the database. In addition to the MIK-OLAP database, MIK-BIS Table also supports relational databases such as MS Access or SQL Server.
Applications
Analysis
Presentation
Reports
Planning/Data entry
Special features
outstanding appearance
Excel-compatible formulas
optimized for standard reporting
Business performance management functions
Off-the-shelf comparative functions: previous year, previous period, data-type and VIP comparisons plus user-definable comparisons
One-click analyses: traffic light, ABC, VIP and top-10 analyses
standardize index and total columns and rows with one click
a table can be made up of any desired mix of cubes
Layout
Numerous layout functions for font, colour and tables
About 40 attractive layout templates
Background images for tables
Template function for standardised tables
Separate formatting of individual columns and rows
export and import of design templates
numerous sclaes with just one mouse click
Formulas
About 120 predefined Excel-compatible formulas (including date/time, financial and statistical formulae)
freely definable formula columns
Easy-to-use formula editor
formulas in rows and columns
Display options
Sorting functions
Numerous display options (e.g. index-card view, hierarchical tables)
Colour-filling of negative values
Full-screen view
Database connection
Real-time data thanks to continuous database connection
Connection to relational databases (e.g. MS Access, MS SQLServer)
Data can be entered directly in the database via the table
Automatic validation of entered data as specified
Export
Operation
Confortable navigation
Programmable using VB.NET
Button actions without programming
Grouping functions to hide and show groups of rows and columns
Simple localization
Database element designations can be easily overwritten
Column Designer
