Cookcode.com

Screen Shots

Interactive data analysis and reporting features

• Processing millions of rows with sub-second response time
• 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 data values
• Sorting table by dimension members or fact values
• Hierarchical filtering for navigation in thousands of dimension members
• 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
• Exporting reports into HTML format, showing reports in Excel and Word
• Presentation quality colored or grayscale reports built with zero programming
• Print preview with Zoom, Scale and Fit to Page

Web based OLAP features

• Allows to create web-based OLAP solutions
• Users can view and interact with reports stored on web sites
• Reads data and report definitions via HTTP and FTP protocols

Calculations features

• Multiple aggregation functions: Sum, Min, Max, Count, and others.
• Calculated facts, based on predefined functions or user-defined formulas.
• Powerful multidimensional Formula language allows to operate with Totals, Subtotals and any elements of cube data.
• Conditional operators, built-in functions, user-defined functions and constants in formulas
• Multiple calculated facts can be based on other calculated facts
• Allows user to interactively add and edit formula facts at runtime like in Excel
• Several Count algorythms: RecordsCount, Count in Group, Child Count, Leaf Count
• Several percentage calculation algorythms: by totals, subtotals, or grand totals
• The unique "LAST" aggregation algorythm allows to analyse stocks, inventory stock, balance sheets, loan balance and other datasheets with balance carried forward
• Advanced dynamic Ranking
• Breaking date and time fields into series dimensions (Year, Quarter, Month, Week, Ten-Day Period, Day of Month, Day Of Week, Time, Hour, Minute, Second )
• Time series calculations: Trend, Variance and Cumulative Sum functions
• Rich set of dynamically calculated statistical functions: Average, Variance, Standard Deviation, Root Mean Square, Variance Ratio

Data visualization features

• Allows to change all appearance properties at design and at runtime
• Conditional style rules grouped in cascaded stylesheets allow users to highlight various data
• Runtime editors for connection settings, fields used, report layout, header and footer, styles and rules
• Nice toolbar with source code included
• Wrapping strings and captions, providing "narrow" reports
• Wrapping filter area to show user all available filters
• Supports flat and 3d modes, XP styles

Report distribution features

• Builds extremely compact microcubes for persistent data storage
• Microcube data is compressed from 10 to 1000 times, and generates low traffic while transferring by email or Internet and can be saved for working offline
• Contour microcube contains not only data, but also all report layout settings and is a universal mobile report container
• ContourCube reads microcubes from file, by HTTP and FTP protocols
• Any ContourCube-powered tool and application can exchange reports stored in microcubes
• Microcube allows to develop corporate and public information delivery systems