MIK-BIS XLReport

Dynamic interface to Microsoft Excel

The complex functionality of Microsoft Excel combined with the advantages of OLAP: MIK-BIS XLREPORT is the sophisticated MIK application for multidimensional analysis of business ratios.

It builds upon the standard Excel functions with a range of ready-made business performance management functions that can be integrated in spreadsheets. These include comparisons, variance and traffic light analyses and more than 40 MIK-specific functions.

The database is accessed dynamically, so that real-time data is always provided. Not only can data be read from the database, but write access to the database is also possible. Data values can be entered directly in the database via an Excel sheet, for instance for planning or budgeting purposes.

Convenient navigation options and extra view functions are provided in the browser mode of XLREPORT. Here the user can use Drag & Drop to swap dimensions, expand and collapse hierarchical dimension structures and create nested spreadsheets.

Applications
Analysis
Presentation
Reports
Planning

Special features
MIK-OLAP database ensures consistent basic data
Powerful access to the MIK-OLAP database and other OLE-DB databases with the full functionality of MS Excel
Dynamic reporting (including drill-down and Slice and Dice functions)
Integration of BPM functions such as cumulation, normalisation, indexing, variances, comparisons, warning-point functions, hit lists etc.

Central and local data entry
Automatic data update after changes (including other users)
Central document management of Excel files on the MIK-BIS server

Business performance management functions

Traffic light function with full configurability
Numerous period options such as average, cumulation and decumulation
Data-type and previous-year comparison
Variance analysis
Various sorting functions

Layout functions

User-defined layout of Excel worksheets
Customisable style (e.g. font, colour, size) of all elements, such as data values, row and column headings
Inclusion of logos

Operation

Familiar user interface of MS Excel plus additional menus
Browser mode with intuitive operation: Drag & Drop, expanding/collapsing hierarchies

Database connection

Supports MIK-OLAP and OLE-DB databases
Continuous database connection and central data storage
Structures and data from the database are adopted directly in the Excel spreadsheet
Local data entry via input option in Excel sheets