Contour OLAPBrowser Analyzer [2.2 10 User Licence]

• 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

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.

Analyzer
For data access, advanced analysis and interactive reporting, creating new microcubes and reports.

Explorer
For data access, analysis and interactive reporting.