Interactive data analysis and reporting features
- Processing millions of rows with sub-second response times
- Dynamic data filtering, pivoting, drill-down and roll-up
- Interactive drill-down into multiple detail levels
- Show/hide detail levels in summary views
- Interactive filtering of dimension members
- Sorting table by dimension members or facts values
- Hierarchical dimension filtering for navigation in thousands of members
- Interactive instant switching between ascending and descending sort orders
- Automatic sizing of columns and rows to fit values into cells
- Header and footer in RTF format that provides sophisticated reporting with headings and comments
- Exporting reports into HTML format, also acceptable by MS Excel and Word
- Presentation-quality colored or grayscale reports generated without writing code
- Print preview with Zoom, Scale and Fit to Page
Web based OLAP features
- Create web-based OLAP solutions
- Users can load reports stored at web sites just by typing URL or clicking a link
Calculation features
- Multiple aggregation functions: Sum, Min, Max, etc.
- Calculated facts, based on predefined functions or user-defined formulas.
- Hierarchical fact structure that allows defined calculated facts based on other calculated facts
- Allows user to add and edit facts at runtime interactively in Excel style
- Rich set of dynamically calculated statistical functions: Average, Variance, Standard Deviation, Root Mean Square, Variance Ratio, Count.
- Four fact calculation modes: Data source records Count, Leaves Count, Child Count, Data source Count Field
- Several percentage calculation algorithms: by row totals, by column totals, by subtotals, by previous period, by fixed period
- The unique "LAST" aggregation algorithm allows you to analyze stocks, inventory stock, balance sheets, loan balance and other data with balance carried forward
- Advanced dynamic Ranking algorithm
- Powerful multidimensional Formula language that allows you to operate on any elements of cube data.
- Conditional operators, built-in functions, user-defined functions and constants in formulas
- Date and time fields can be broken into series (Year, Quarter, Month, Week, Ten-Day Period, Day of Month, Day Of Week, Time, Hour, Minute, Second)
Data visualization features
- Shows data in multiple tables and charts
- Provides numerous chart types and allows you to set lots of chart properties
- Allows you to change data appearance at design time as well as at runtime
- Conditional styles gathered in cascading stylesheets allow users to define colors and fonts for data highlighting based on custom rules
Microcube wizard
- Allows user to create new interactive reports in a minute, and to get data directly from Excel and XML documents
- Gets data from arbitrary relational databases and XML files.
- Saves data and reports in one compressed file - microcube
Multi Document Interface
- Supports MDI - Multi Document Interface and allows you to view multiple reports, web pages and office documents in one screen
- Allows you to save windows layout to XML file for further reuse and publishing. For example, Windows Layout can consist of a company web page, interactive balance as a microcube and any report as MS Word or Excel document
Report distribution features
- In conjunction with Contour CubeMaker, OLAPBrowser provides an easy to use report distribution technology
- Allows you to distribute reports via local network and intra- / internet
- Allows you to distribute reports worldwide to users equipped with OLAPBrowser
- Allows users to share information and send reports to each other
- Any interactive report can be exported in HTML, Excel, Word or CSV-formatted text file for exchange with other applications
Features
Interactive data analysis and reporting features
Processing millions of rows with sub-second response times
Dynamic data filtering, pivoting, drill-down and roll-up
Interactive drill-down into multiple detail levels
Show/hide detail levels in summary views
Interactive filtering of dimension members
Sorting table by dimension members or facts values
Hierarchical dimension filtering for navigation in thousands of members
Interactive instant switching between ascending and descending sort orders
Automatic sizing of columns and rows to fit values into cells
Header and footer in RTF format that provides sophisticated reporting with headings and comments
Exporting reports into HTML format, also acceptable by MS Excel and Word
Presentation-quality colored or grayscale reports generated without writing code
Print preview with Zoom, Scale and Fit to Page
Web based OLAP features
Allows to create web-based OLAP solutions
Users can load reports stored at web sites just by typing URL or clicking a link
Calculation features
Multiple aggregation functions: Sum, Min, Max, etc.
Calculated facts, based on predefined functions or user-defined formulas.
Hierarchical fact structure that allows to define calculated facts based on other calculated facts
Allows user to add and edit facts at runtime interactively in Excel style
Rich set of dynamically calculated statistical functions: Average, Variance, Standard Deviation, Root Mean Square, Variance Ratio, Count.
Four fact calculation modes: Data source records Count, Leaves Count, Child Count, Data source Count Field
Several percentage calculation algorithms: by row totals, by column totals, by subtotals, by previous period, by fixed period
The unique "LAST" aggregation algorithm allows you to analyze stocks, inventory stock, balance sheets, loan balance and other data with balance carried forward
Advanced dynamic Ranking algorithm
Powerful multidimensional Formula language that allows to operate on any elements of cube data.
Conditional operators, built-in functions, user-defined functions and constants in formulas
Date and time fields can be broken into series (Year, Quarter, Month, Week, Ten-Day Period, Day of Month, Day Of Week, Time, Hour, Minute, Second)
Data visualization features
Shows data in multiple tables and charts
Provides numerous chart types, allows to set lots of chart properties
Allows to change data appearance at design time as well as at runtime
Conditional styles gathered in cascading stylesheets allow users to define colors and fonts for data highlighting based on custom rules
Microcube wizard
Allows user to create new interactive reports in a minute, and to get data directly from Excel and XML documents
Gets data from arbitrary relational databases and XML files.
Saves data and reports in one compressed file - microcube
Multi Document Interface
Supports MDI - Multi Document Interface and allows to view multiple reports, web pages and office documents in one screen
Allows to save windows layout to XML file for further reuse and publishing. For example, Windows Layout can consist of a company web page, interactive balance as a microcube and any report as MS Word or Excel document
Report distribution features
In conjunction with Contour CubeMaker, OLAPBrowser provides an easy to use report distribution technology
Allows to distribute reports via local network and intra- / internet
Allows to distribute reports worldwide to users equipped with OLAPBrowser
Allows users to share information and send reports to each other
Any interactive report can be exported in HTML, Excel, Word or CSV-formatted text file for exchange with other applications
Interactive user-friendly interface for wide range of users
Contour OLAPBrowser offers easy to use user-friendly interface. Every user familiar with Internet Explorer and a spreadsheet editor can learn OLAPBrowser in 30 minutes.
Fast deployment, zero administration, unlimited scalability
OLAPBrowser does not need any specific server. Users should just install the program to work with microcubes. Microcubes can be created once and scheduled for regular update, stored anywhere and do not require any maintenance at all. Thousands of users can view one microcube at the same time because OLAPBrowser performs all calculation at client side.
Interactive data analysis and reporting with sub-second response times
Contour OLAPBrowser allows users to interactively analyze data, build and print reports by clicking and drag&dropping with sub-second response times. Users can dynamically interact with data: move rows and columns, filter data, drill-down, roll-up, pivot table and get all possible reports from one dataset. Contour OLAPBrowser makes millions of calculations simultaneously and shows new subtotals and totals instantly.
Information access flexibility
OLAPBrowser can open microcubes across the corporate LAN, WAN, Web, and microcubes received by e-mail. Users can type the URL of a microcube in the address field of OLAPBrowser, or click on a link to a microcube placed on a web server and view corporate or public reports. Users can open a microcube from a file server or local directory, and send or receive microcubes by email. So IT-managers can create very simple and flexible enterprise reporting systems.
Microcube - a universal mobile container of interactive reports
OLAPBrowser gets data and reports views from Contour microcubes. Contour microcube is a new concept of multidimensional database. It stores not only extremely compressed data but all reports definitions in a single file. So any application powered with ContourCube can generate microcubes and define report layouts and many other applications will be able to view and print those reports. OLAPBrowser can show reports generated by ERP, CRM or any other 3rd party systems with ContourCube embedded, by Contour CubeMaker and by OLAPBrowser itself.
Very compact storage, very fast data loading
Microcubes store data in a very compact form. Source data loaded into microcube is compressed by 90% up to 99.9%, so you can publish this file to web, send it by e-mail and save it on your laptop. Imagine that data for all sales of your company for this year can be stored in one single file of 1 or 2 MB. You can save this file at your mobile PC and work with it anywhere. That is why Contour OLAPBrowser loads microcubes very fast. You have only to wait for a second to see a report that aggregates hundreds of thousand records from the source database.
Rich analysis, data manipulation and interactive reporting capabilities
Contour OLAPBrowser has many features for data manipulation using advanced OLAP technology. It allows to dynamically drill down through the data, provides many built-in functions for calculations on measures. Easy to use and powerful Formula Language dynamically performs custom calculations.
High quality data visualization
OLAPBrowser allows you to rapidly set colors, fonts, header & footer, create charts for better understanding of data. Users can create new reports and change layout of exiting reports, add and remove calculated fields. Conditional styles gathered in cascaded stylesheets allow highlighting of important values, so users get data in a nice and clear form.
Reports distribution technology
Contour OLAPBrowser provides ready to use powerful and affordable technology for delivering reports to a wide range of users through extranet, intranet, internet and email.
Benefits
Friendly user interface for wide range of users
Rapid deployment, zero administration
Interactive data analysis and reporting with sub-second response times
Information access flexibility
Microcube - a universal mobile container for interactive reports
Very compact storage, very fast data loading
Rich analysis, data manipulation and interactive reporting capabilities
High quality data visualization
Report distribution technology
Interactive user-friendly reporter for wide range of users
Contour OLAPBrowser offers easy to use user-friendly interface. Every user familiar with Internet Explorer and a spreadsheet editor can learn OLAPBrowser in 30 minutes.
Fast deployment, zero administration, unlimited scalability
OLAPBrowser does not need any specific server. Users should just install the program to work with microcubes. Microcube can be created once and scheduled for regular update, stored anywhere and does not require any maintenance at all. Thousands of users can view one microcube at the same time because OLAPBrowser performs all calculation at client side.
Interactive data analysis and reporting with sub-second response times
Contour OLAPBrowser allows users to interactively analyze data, build and print reports by clicking and drag&dropping with sub-second response times. Users can dynamically interact with data: move rows and columns, filter data, drill-down, roll-up, pivot table and get all possible reports from one dataset. Contour OLAPBrowser makes millions of calculations simultaneously and shows new subtotals and totals instantly.
Information access flexibility
OLAPBrowser can open microcubes across the corporate LAN, WAN, Web, and microcubes received by e-mail. User can type URL of a microcube in the address field of OLAPBrowser, or click on a link to a microcube placed on a web server and view corporate or public reports. User can open a microcube from a file server or local directory, and send or receive microcubes by email. So IT-managers can create very simple and flexible enterprise reporting systems.
Microcube - a universal mobile container of interactive reports
OLAPBrowser gets data and reports views from Contour microcubes. Contour microcube is a new concept of multidimensional database. It stores not only extremely compressed data but all reports definitions in a single file. So any application powered with ContourCube can generate microcubes and define report layouts and many other applications will be able to view and print those reports. OLAPBrowser can show reports generated by ERP, CRM or any other 3rd party systems with ContourCube embedded, by Contour CubeMaker and by OLAPBrowser itself.
Users can use microcube like Excel book that stores data and reports in one file. Microcube can be created by one person, published anywhere and then shared with other persons, who can read it, change and share like an Excel workbook.
Very compact storage, very fast data loading
Microcube stores data in very compact form. Source data loaded into microcube is compressed by 90% up to 99.9%, so you can publish this file to a web, send it by e-mail and save it on your laptop. Imagine that data for all sales of your company for this year can be stored in one single file of 1 or 2 MB. You can save this file at your mobile PC and work with it anywhere. That is why Contour OLAPBrowser loads microcubes very fast. You have only to wait for a second to see a report that aggregates hundreds of thousand records from the source database.
Rich analysis, data manipulation and interactive reporting capabilities
Contour OLAPBrowser has many features for data manipulation using advanced OLAP technology. It allows to dynamically drill down through the data, provides many built-in functions for calculations on measures. Easy to use and powerful Formula Language dynamically performs custom calculations.
High quality data visualization
OLAPBrowser allows to rapidly set colors, fonts, header & footer, create charts for better understanding of data. Users can create new reports and change layout of exiting reports, add and remove calculated fields. Conditional styles gathered in cascaded stylesheets allow to highlight important fact values, so user get data in a nice and clear form.
Reports distribution technology
Contour OLAPBrowser provides ready to use powerful and affordable technology for delivering reports to a wide range of users through extranet, intranet, internet and email.