Integrate OLAP data, Interactive Charts, Dashboards and KPIs
with your Solution

Discover ways to integrate Kyubit Business Intelligence features with your web site/application and use many of data analysis and visualization features in your existing solutions.

HTML/Javascript Integration

Include Kyubit Javascript/CSS files to your web site/application to integrate OLAP/SQL data analysis visualization. Integrated Kyubit visualization enables users of your solution to analyze OLAP data directly on your site, still offering Kyubit features like Drill-Down, Drill-through, 'Large View', Export to Excel, Customize appearance, Caching and other.

Example:
<script type='text/javascript'>
$(document).ready(function ()
{
    $kyu.initVisualization('testDiv', {
        name: 'My Visualization',
        analysisId: 2053,
        chartType: 'Column_Chart',
        colorPallete: 0,
        allowLargeView: true,
        refreshTime: 5
    }
}
</script>

HTML/Javascript approach advantege is integration quality and fine tuning of visualization and behavior options.
Learn about OLAP/Dashboard Javascript Integrations


IFRAME HTML Integration

To integrate whole existing OLAP Analysis Report or Dashboard to your site, use IFRAME HTML integration options. Created Analysis or Dashboard within Kyubit application is included to your site with single line of HTML and ready for your site user data discovery and usage with custom visual pereferences to best fit to your existing user interface experiance.

Example:
<iframe id="dashFrame" 
    src="http://localhost:85/Forms/Dashboard.aspx
    ?DashboardID=3027
    &@country=Canada;Australia
    &align=right&font=helvetica
    &fontColor=red&tileFontSize=11px
    &hideDesignButton=1&hideCloseButton=1
    &hideOpenPDFbutton=1&hideSubscribeButton=1" 
    width="1600px"
    height="1000px" 
    frameborder="0" 
    scrolling="no">
</iframe>

IFRAME approach advantege is speed and OLAP and Dashboard behavior exactly as within Kyubit application.
Learn about OLAP/Dashboard IFRAME Integrations
Integrate OLAP data, Dashboards, KPIs to your site

Video - Integrate OLAP Analysis and Dashboards to any web site


Introduction

In this video we will demonstrate, how to integrate interactive OLAP analysis and SQL data visualizations in any web site or application. Suppose that you have any kind of HTML page with the list of your products and a place where you would like your users to analyze data from your OLAP or SQL data sources. It only takes to add required javascript and css files and write few simple lines of code for magic to appear on your page. Any analysis, query or dashboard created in Kyubit BI will be rendered on your page with interactive ability to drill-down your data, drill by any available dimension in your cube, change chart type, drill-through the data and many more. Users will also be able to enlarge presented visualization, export analysis to Excel file or continue analysis with full analytic features inside Kyubit Business Intelligence app. Same way created KPIs and Gauge visualization could be included to your page to show metrics and success of your business goals. Add ability for your users to explore and discover OLAP data structures on your page within minutes.


Integration Basics (HTML/Javascript Integration)

Let's start from the beginning. Open your Kyubit BI application and create some simple analysis. Choose your OLAP data source and drag-and-drop some dimension hierarchies to see some data related to your products. Save your analysis and go to your HTML page where you would like to reuse created analysis. Add prerequisite javascript files to your page and decide location of the HTML element where you would like your visualization to appear. Within Kyubit global configuration, set URL to Kyubit application that will be shared among multiple visualizations on your site. Also here are attributes that will set general layout and behavior of integrated analysis on your site in general. Finally, create javascript function that will initiate integration as soon as your page loads and set parameters for analysis you would like to show. First integration is here, but now you will want to customize its appearance. Set value labels to show on the chart. For all labels or only top values. Add series to your analysis for more detailed visualizations and set 'Column Chart' chart type to your integration details parameters. Any of these visualizations gives you ability to drill your data to the point of interest using any dimension hierarchies from your OLAP cubes. Change integration color pallete to best match your site layout colors or create new color pallete with specific colors your prefer. To focus on specific data and show only part of your initial analysis, set specific categories and series you wish to show. Choose 'Pivot' option to switch categories and series values on your chart. Set 'Refresh' time interval, after which data will be automatically refreshed with current values from data source or set cache parameters that will hold integration data in the memory for specific amount of time. More advanced scenario is that you would like to have analysis in the context of some data from your page. For example, you would like to show analysis for a given product from your page, you have selected. When user click on 'Details' specific product, analysis will be displayed. First, create certain analysis with dimension you would like to see on your categories, series and filters within Kyubit BI app. It will take a minute to prepare any kind of analysis and save it to be reused. Create javascript function that will be called when used clicks on details, passing product key as an argument. Within this function, we shall call integration function, but this time we will add slicer parameter. Integration function can have any number of slicer parameters that consist of slicer ID, which stands for dimension hierarchy we would use for slicing and slicer value that is actual member unique value used for filtering. Of course, we shall set product key to create final slicer parameter values for data integration. Now, we have integrated visual analysis in the context of the data user has previously selected. After user selects details for any product, he is able to see analysis data and interactively explore data on this page, export data to Excel or continue analysis in Kyubit Business Intelligence application. Set series of values to display 'Trend' or 'Average' line on the chart.


Integrate Dashboards or OLAP Analysis using IFRAME

It is also possible to integrate whole dashboard created in Kyubit BI using IFRAME HTML element. Set the URL of the IFRAME to point to Kyubit application with parameters for specific dashboard and some parameters that will hide unnecessary items in toolbar. Again, to show dashboard in the context of particular product, we will create function that will pass product key to set appropriate URL for dashboard visualization. We shall set URL for dashboard, but this time we will add slicer value for the dashboard. Slicer consist of the filter dimension hierarchy defined in the dashboard and the slicer member unique value. Ampersand is escaped with HTML equivalent. Every time we click on 'Details' same dashboard is rendered, but every time with different slicer value to show product specific dashboard visualization. Using IFRAME elements, we can also integrate OLAP report to our web page. OLAP report is specific as it show expanded portions of OLAP data, making sort of analysis tree, that is intuitive to users exploring the data. Drag-and-drop dimension hierarchies on the category and series axis, expand any of dimension members and prepare all visual details OLAP report could include 3D visualizations that could be part of the report embedded to your page. Set value bars to visually indicate impact of the values compared to totals. Save analysis and set URL within IFRAME element to point to saved analysis and be rendered on your page. Kyubit Business Intelligence provides simple and advanced interactive visualization for data analysis and features to integrate within your page within minutes.