OLAP Tools for Reporting and Analysis

Kyubit BI OLAP tools provides smooth web-based data analysis features that support MS Analysis Services (SSAS) OLAP Multidimensional and Tabular models. OLAP data analysis, interactive visualization, collaboration, and embedded analytics based on OLAP data.

Superior OLAP/Tabular Analysis Tools

OLAP tools The Kyubit is a set of web-based OLAP tools designed for Microsoft Analysis Services environment (SSAS) with features to analyze, visualize, share, and integrate OLAP data. Quick and straightforward installation, feature-rich, and easy-to-adopt analysis are some of the most popular remarks for Kyubit OLAP analysis software. Kyubit Business Intelligence OLAP tools include ad-hoc OLAP analysis within the OLAP grid or OLAP chart and make essential analysis operations very easy and intuitive.
OLAP tools

3-axis Grid Analysis

Drag-and-drop any number of measures and dimension attributes on the category, series, and filter axis to drill down/slice any data available to create complex analysis structures.

Embedded Analytics

Embed OLAP analysis and reports within your web application to quickly add OLAP analytic capabilities to your environment. Embed prepared analysis or set a blank analysis grid.

Ad-hoc OLAP features

Create new named sets, drill-through actions, calculated measures, and calculated members in the Kyubit application or use existing defined in the OLAP cube.

Collaborate or Export

Share created OLAP analysis/report with other users using appropriate authentication (Windows/Kyubit authentication) or export to the PDF or Excel files.

Scheduled Report Delivery

Schedule OLAP report (analysis) delivery on the email at the scheduled time in PDF, Excel format, or embedded report (HTML) into the delivered email.

Analytic Dashboards

Organize multiple OLAP analyses to interactive analytical dashboards with various data slicing abilities and OLAP quick explore, drill-down and many more OLAP analytic features.

OLAP tools on dashboard
Watch the video with the main OLAP features related to Kyubit OLAP tools. OLAP grid analysis, OLAP Decomposition analysis, OLAP on interactive Dashboards, Dashboard customizations, Dashboard visualizations slideshow, and more BI tools and features from Kyubit.


OLAP TOOLS USAGE SAMPLES
Use various OLAP tools provided by the Kyubit business intelligence platform to create analyses, reports, and dashboards based on OLAP multidimensional or tabular model data. After connection to your OLAP cube is created in Data sources, each authorized user can quickly create new OLAP analysis, by simply drag-and-drop measures and dimensions, creating slicers, drill-down, and using other numerous ways to explore and deep search OLAP data to find answers and insights to particular analytic questions. Kyubit OLAP tools provide ad hoc 'Named Sets', 'Calculated Measures' and 'Drill-through definitions' directly inside the Kyubit application, which are instantly ready for usage and sharing with other users. To prepare reports for end-users (less analytic options on the screen), use a variety of cell formatting options. Set cell colors, Grid KPI icons, and text formatting depending on the values thresholds. Create OLAP Time Intelligence slicers, that will be useful to prepare time-relative filtering. Create interactive dashboards that use data from existing analysis, schedule subscriptions to receive OLAP report on your email, use mobile devices to reach your OLAP data or embed analytics to your own HTML page.

A quick tour of Kyubit OLAP Tools and features

Quick Setup

It takes a few minutes to download, install and utilize Kyubit OLAP Tools.

Grid Analysis

Powerful 2-axes, multi-measure, intuitive OLAP grid analysis.

Chart (Visual) Analysis

Interactive charts for OLAP analysis and visualization with Kyubit OLAP Tools.

Drag-and-drop experience

Easy to adopt, intuitive, drag-and-drop user experience.

Share

Share analysis with colleagues on your intranet.

Dynamic drill-through

Dynamically define drill-through columns to show while drill-through with OLAP tools.

Export

Export your analysis to Excel and PDF.

Subscribe

Create OLAP reporting scheduled subscriptions to existing analysis.

Embedded Analytics

OLAP report data integration within other web applications.

Use on Dashboards

Use created SSAS OLAP analysis to prepare complex analytic dashboards.
OLAP tools, OLAP analysis

Drag-and-drop OLAP elements for analysis

OLAP analysis software User interface and interaction are an important part of 'Kyubit Business Intelligence' and OLAP tools usage for end users. Drag-and-drop any OLAP element to the analysis area to start OLAP analysis. Dimensions, hierarchies, levels, measures, named sets, user calculated measures are easily dropped into the analysis screen.


Drill-down, drillthrough, slicing ...

OLAP analysis software Kyubit's BI platform supports a variety of standard OLAP operations for analytic purposes. Analyzing multiple measures with categories and series, drill down members, filtering and slicing, expand-collapse members, drill through for additional details, pivot categories and series, sorting members of dimension levels with advanced options, level filtering, etc.

Visual analysis on charts

OLAP visual analysis While analyzing OLAP data with Kyubit OLAP tools, it is possible to switch to visual analysis with a chart at any time or go back to grid analysis. With chart analysis, a user selects chart elements for additional OLAP operations and sees results as a new chart immediately. There are a number of different chart types that are appropriate for certain analysis types, while 3D chart types visually enhance the analysis experience.


Share analysis reports with other users

OLAP analysis share After analysis is created with Kyubit OLAP tools, it is the ideal point to share with other users for analytic or reporting purposes. Security concept allows analysis to be shared with other Active Directory (or local machine) users and groups. 'Kyubit Business Intelligence' impersonates the current user, so the particular user will see OLAP content for which the current user has permissions in the OLAP database within the SSAS environment.


Schedule analysis report subscriptions

OLAP analysis subscriptions Users of the Kyubit BI platform can subscribe to created analyses and reports and receive an email with fresh data at the scheduled time. Kyubit includes its own subscription service that handles subscription delivery within a scheduled period. The subscription will deliver embedded analysis within an email message, attached as a PDF/Excel file, or link to the analysis/report on the Kyubit web application.
OLAP tools
MORE REASONS FOR KYUBIT OLAP TOOLS
Monitor the success of your business goals with KPIs (Key Performance Indicators) & Scorecards that are based on your OLAP data with Kyubit BI OLAP Tools. Set alert emails that are triggered by particular KPI status. Use the KPI/Scorecard application section to create KPIs that are based on created OLAP analysis or group such KPIs into scorecards. Display KPI as KPI Icons, Goal meters or Gauges. Use Kyubit BI OLAP tools to embed OLAP analytics to your own HTML page and discover ways to integrate Kyubit Business Intelligence features with your website/application and use embedded analytics features on your existing site or application. Use the Mobile BI feature for OLAP analysis with Drill-Down and Drill-through actions to find more in-depth details of your data with the touch of your fingers on the Dashboards Mobile BI view. Select the OLAP dimension level to Drill current data with multiple Drill-Down steps or get back to the previous state of analysis. Select the predefined Drill-through action that will return row details of the current OLAP visualization.

Get started with Kyubit OLAP Tools

olap tools download Download BI tools and 30 day evaluation of Kyubit business intelligence platform and its OLAP tools and try OLAP analysis 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 self-service analytics - User Manual which covers all aspects of OLAP tools usage.