|
 |
| Cross Tab OLAP BI Analysis |
 |
|
|
|
|
|
Insightful, Dynamic BI Analytics for Everyone
While pre-built ElegantJ BI cubes turn the organisation’s useful data into useful business information with flexible Cross Tab OLAP BI analysis – a powerful cross tab analysis - you can readily analyse a business opportunity better. Making it interactive and dynamic, ElegantJ BI’s powerful OLAP technology brings the power of Cross Tab OLAP business intelligence analysis, including pivot table analysis, to any user across your organisation, right on your browser.
Business analysis has never been easier!
|
 |
|
|
|
|
|
|
|
Cross Tab OLAP analysis software ElegantJ BI’s Dynamic Analytics provides a 360 view of your business to help you assess how successfully you are measuring against plan, what are the reasons behind poor business performance, and how to best direct the business. Through seamless integration with data extraction & cube management, ad-hoc querying and BI reporting, you are able to take full advantage deriving intelligence out of all existing corporate information and have broader, brighter and sharper view of corporate performance.
With ElegantJ BI’s Cross Tab OLAP analysis tool, users can engage in multi-dimensional cross tab analysis, including pivot table analysis, on modeled cubes to explore large volumes of summarized business intelligence data in just seconds. They can easily filter data, change business intelligent report layouts, add charts, perform their own calculations, cross tab analysis and pivot table analysis for the information that is most relevant to them, all within their Web browsers. |
| |
|
BENEFITS OF CROSS TAB OLAP SOFTWARE TO YOUR BUSINESS AT A GLANCE |
|
|
|
| › |
analyse past performance and predict future opportunities at the earliest |
| › |
Increase in resource utilization, availability and productivity for performance optimisation |
| › |
Quick and easy consolidation of reports from dynamic, interactive analysis |
| › |
Increased flexibility to respond to changes in market trends |
| › |
Better agility and business outcomes through proactive, dynamic analysis |
|
|
|
|
| |
| Key Features of Cross Tab OLAP Software |
|
| Interactive, Insightful Business Intelligence Analysis |
| Providing you interactive, insightful cross tab OLAP analysis, including and pivot table analysis, with slice and dice, drill up, drill down and drill through options; it gives you the flexibility to have unlimited combinations of possible views of data, and information from different perspectives for a more balanced view of your business. |
| |
| Seamless Integration of Query, Business Intelligence Analysis and Reports |
| ElegantJ BI’s zero-footprint browser based interface with seamless integration of query, cross tab analysis, pivot table analysis and reporting is what brings the power of OLAP analysis to any users across your organisation. With no software to install for end users, it’s fast to roll out and requires minimal maintenance. |
| |
| Quick and simple, Enterprise-wide Adoption |
| Business Analysis is an important part for executing strategy and achieving results. Being easy and intuitive for all users, business users can create their own business intelligence analysis and reports without depending on IT support. Transforming every user into a knowledgeable worker, you can quickly create cubes, perform dynamic cross tab OLAP analysis, including pivot table analysis, and generate any type of business reports with just a few clicks. |
| |
| Product Highlights |
|
|
|
- Interactive easy to use analysis design wizard
- Outliner setting with flat view or hierarchical view
- Easy to use Drag n’ Drop outer liner lay outer interface to support four dimensional analysis through dynamic cross tabs
- Multiple Page dimension filters
- Multiple measures and Custom measures can be added to analysis
|
- Slice & Dice (Dynamic cross tabulations with multidimensional cube)
- Single click Dice operation
- Runtime retrieval parameter on loading OLAP analysis
- Drill-up / Drill-down to higher / lower levels of the dimension
- Drill-through Data operations: Sum, minimum, maximum, average, effective average (average for non-null values), count, effective count (count of non-null values), row percentage, row group percentage, column percentage, column group percentage, total percentage, relative difference, relative difference percentage.
- Create Graphical view of Analysis
- User-Friendly data operation within Analysis
|
- Data operations: Sum, minimum, maximum, average, effective average (average for non-null values), count, effective count (count of non-null values), row percentage, row group percentage, column percentage, column group percentage, total percentage, relative difference, relative difference percentage.
- User defined row and column with powerful expression building
- Summary operations: Sum, minimum, group minimum, maximum, group maximum, average, effective average (average for non-null values), group average, count, effective count (count of non-null values), row percentage, row group percentage, column percentage, column group percentage, total percentage, relative difference, relative difference percentage, default (automatic based on data operation)
- Suppress rows and columns with all zero values
- Spot lighters: Colour or text based spot lighters to highlight cells as per criteria
- Sorting rows and columns ascending, descending or based on data values
- Ranking of rows and columns according to Top 5, Top 10, etc.
- Filtering: On loading data from cube, On front end, Using hierarchical tree view with values for quick filtering, Advanced expressions
- Show-Hide row and column values
- Easy to use options to show all columns / rows, exclude unwanted columns / rows and show a particular column / row only
- Group / Ungroup selected rows and columns
- Value mapping for user friendly display of data
- Summary of operations performed on analysis
|
- Access to central Cube Repository Objects like Custom Measure, Custom Dimension Values, Spot Lighter, Data Value – Display Value Mapping
|
- Time Series filtering with Absolute, Relative and Range criteria.
|
- Easy Formatting and Display
|
- Cell notes / Table notes with private or public option
- Comprehensive cell formatting with resizing and renaming
|
|
- Brochure quality printing with all page setting and printing options
- Exports: PDF, CSV, XML, JPEG, XLS
- Sharing & Publishing: Design, Publish and schedule delivery of analyses to selected users through Publishing and Delivery agent
- Publish Now to instantly publish & deliver analysis to users
|
|
| |
|
|
| |
|
|
|
|
|
|
 |
|
|
|
 |
 |
 |
|
|
|
|
|
|
|
With ElegantJ BI engage in
multi-dimensional analysis on modeled cubes to explore large volumes of summarized data in just seconds. Providing you interactive
insightful analysis with slice and dice, drill up/down and drill through options; it gives you the flexibility
to have unlimited combinations of possible views of data, and information from different perspective. |
|
|
|
|
 |
 |
 |
|
|
|
|
|
|
|
|
|
|
|
|
Relation between Outliner |
|
setting and analysis |
|
|
|
|
|
| Dynamic OLAP analyses by simple dragging-n-dropping of dimensions and measures in to relevant quadrants |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Single click Dice operation |
|
|
|
|
|
| Multidimensional tools allow users to view data from any angle. Through slice-n-dice, user can rotate the presentation between rows and columns in crosstabs. After generating an analysis, a user can swap dimensions from row to column and column to row. |
|
|
|
|
|
|
|
|
|
|
|
