OLAP Client | KYUBIT Business Intelligence

OLAP Client software

'Kyubit Business Intelligence' provides OLAP client application with features and services to analyze OLAP data with drag-and-drop analysis, visual analysis on the interactive charts or prepare MDX queries to visualize data on OLAP Reporting and Dashboards. User-friendly interface, fast performance and stunning visualizations are primary features of the 'Kyubit Business Intelligence' OLAP client software.

OLAP Client software for SSAS environment

'Kyubit Business Intelligence' is OLAP client application that will enable your analysts to create beautiful and comprehensive OLAP analysis, OLAP Reporting, data visualizations, calculations and integrate OLAP data usage within your team by adding comments and interaction between OLAP reports and users. 'Kyubit Business Intelligence' OLAP client download and setup are ready in 5 minutes and you will be surprised how quickly users can adopt OLAP analysis with this web application that is installed in your environment and used by all authorized users using a web browser. The product setup has minor prerequisites and it is suitable for almost any environment with MS analysis services and SQL server. Product is installed on a server with IIS and become a central point for useful OLAP tools, OLAP reports, Dashboards and other Business Intelligence content that will be accessed by authorized users using only a web browser. (Internet Explorer, Chrome, Firefox and Safari internet browsers are supported).

Drag-and-drop OLAP analysis

You are going to like how easy and practical is to drag-and-drop OLAP dimension hierarchies and measures to two axes OLAP grid that instantly responds with results for defined analysis. On same analysis, user can switch from grid to chart view and back to use all benefits of Kyubit OLAP client application and actions that are adequate for current analysis needs. All actions using any of Kyubit OLAP client application are stored in analysis history and the user can view all analysis changes and has the option to switch to some analysis state that was previously taken. At any time of analysis export data to Excel, CSV or PDF file.

Visual & interactive OLAP analysis

OLAP client application includes chart features to render perception of current analysis with 2D and 3D charts that are using a major portion of user interface. At any time click on the certain chart part that presents certain segment of analysis data (OLAP member) and check for additional actions (Drill by, Drill down, Drillthrough) that visual analysis includes to further analyze OLAP data. Sort data by series or categories or compared to measure over specific member on the series axis. Use following chart types for OLAP data visualizations (Lines Splines, Stacked Bars, Stacked Bars 100, Stacked Columns, Stacked Columns 100, Areas, Stacked Areas, Stacked Areas 100, Pie, Doughnut, Radar) Export chart analysis to PDF file or subscribe to analysis and receive fresh data on email at scheduled time.

OLAP client application and Reports

While designing OLAP report using Kyubit OLAP application, Filters will be set by adding OLAP dimension members that will be slicers for OLAP report. While observing report by the end user, Filters could be temporarily changed to show other slicing variations of the OLAP reporting. Finally, the user can choose also which visual elements OLAP report will contain. Optionally 'Grid' and 'Chart' data presentation could be included, custom Title and Description that can contain HTML, the position of the visual elements and 'Value bars' that visually indicate the amount of data in each cell, compared to the totals or grand totals. Reporting with Kyubit OLAP application includes features to provide end-users with the ability to add their own comments, make discussion and share their thoughts on OLAP related data on the report. OLAP reports are organized in folders with unique permissions defined for users and groups and definitions who can only read or change existing OLAP report
Learn more about OLAP analysis to start creating an OLAP report.

MDX queries using Kyubit OLAP client application on the dashboards

Beside single OLAP report generated by the single OLAP analysis, Kyubit OLAP client application also includes features to create dashboards that include many visualizations, metrics and indicators that are based on multiple OLAP analyses, but also MDX and SQL queries. So, if OLAP data of interest is not practical to get by drag-and-drop OLAP analysis features, a user can always write MDX queries for full benefits of OLAP environment and MDX syntax queries to get full OLAP reporting experience. Construct new MDX query in 'Queries' section of 'Kyubit Business Intelligence' OLAP tools and click 'Run' to test results. Select appropriate OLAP database data source that accepts MDX query language. Once created MDX query is valid and returns results as expected, it could be saved and used on the dashboard visualizations.

Publish and Integrate OLAP data with other web applications

Every OLAP analysis report created with Kyubit OLAP client application has options to be published and become visible and accessible from other web applications via URL and defined analysis alias name. In other words, a snapshot of interesting OLAP data becomes visible from other web environments with the ability to create a custom layout. This option makes possible to create links from other applications or define the area where certain analysis would be visible inside other application using HTML IFRAME element or Web Parts.

While publishing and integrating certain OLAP analysis results, users have options to create a custom layout to fit OLAP analysis (grid and/or charts) in other web environments, considering fonts, colors and other visual elements.
For more details on publishing (integration) OLAP data snapshot, see 'Publishing features' in OLAP Analysis user manual documentation.

Step-by-Step Tutorials introducing main Kyubit Analysis concepts with instructions on how to start and use application features ...

Analysis Tutorials

Get started with OLAP client application

Download 30 days evaluation of 'Kyubit Business Intelligence' and see OLAP client features in action.
It is a simple and quick installation that will bring all features unlocked in the evaluation version. We will be happy to receive your feedback and inquiries.
Download 'Kyubit Business Intelligence OLAP analysis - User Manual' which covers all aspects of Kyubit OLAP client application.