CubeView is a browser based Business Analytical reporting tool OLAP Dashboard - PowerPoint PPT Presentation

About This Presentation

CubeView is a browser based Business Analytical reporting tool OLAP Dashboard


CubeView is a self-service reporting platform with capabilities of building, publishing and circulation of dashboards, simple tabular reports, SSRS reports (Microsoft Reporting Services) and Analytical reports with graphics. It identifies and tackles needs and challenges faced by businesses of different sizes and domains. Center for Business Intelligence & Analytics, LLC – PowerPoint PPT presentation

Number of Views:64


Transcript and Presenter's Notes

Title: CubeView is a browser based Business Analytical reporting tool OLAP Dashboard

Business Analytical Reporting Tool OLAP Dashboard
CubeView is a browser based Business Analytical
reporting tool OLAP Dashboard
What is OLAP Dashboard?
  • The OLAP designation indicates that one or more
    of the graphs or reports (sometimes referred to
    as panes, in the dashboard) are based on an
    Online Analytical Processing (OLAP) data source. 
    OLAP data sources are multi-dimensional, in that
    they allow for reporting on several different
    variables (also known as dimensions), sometimes
    at the same time, with the flexibility to select
    only a subset of the variables at a time.
  • Dashboards commonly include anything from basic
    tabular reports, pie charts, bar charts, line
    graphs, to more complicated reports with traffic
    lighting and automatic threshold e-mail alerts,
    maps, gauges, pyramids, spark charts and scatter
    plots with trend lines. The options for reports
    and graphs available in an OLAP dashboard may be
    limited by the vendor. 

Generate two types of reports
  • Tabular reports (from Database views)
  • Analytical OLAP reports (from Cubes) Cross Tab
    / Graphical

self service reporting on Microsoft SQL platform
  • Reporting Features
  • Reporting Benefits
  • Dashboarding Features
  • Dashboarding Benefits
  • Publishing Features
  • Publishing Benefits
  • Cost Benefits

How Browser based reporting tool Works?
  • Connect to MS SQL Views or Cubes.
  • Build reports (OLAP, Tabular, Cross-Tab and
  • Build dashboard page using templates.
  • Insert Reports and define Page level Filters.
  • Publish and circulate using dashboard viewer or
    dashboard page URL.
  • Set access rights for dashboard pages.

Structure Of OLAP Reporting Tool
(No Transcript)
CubeView user-friendly Web Based Dashboarding Tool
Publishing and Circulation
Dashboard Viewer shows all the Dashboard pages
in menu form enabling users to select and
view any page. Insert Dashboard View URL in
intranet, website or MS SharePoint application.
Insert Dashboard View URL or Dashboard Page URL
in e-mails, to allow designated users access
to Dashboard Viewer or page. Easy
accessiblity on mobilephones and tablets
Industry standard security features
  • Single Sign for using Active Directory Feature
  • Role based access to Dashboard pages for
    business users.
  • Disable export to Excel file for selected roles
    or users
  • Power users authorized to build, edit and
    delete reports/Dashboard pages.
  • System Administrator authorized to
    Add/edit/delete roles and users Connect to
    Databases and Cubes Install/Uninstall

Built using Microsoft technology
  • ASP / dotNet
  • SQL 2012 database and Analysis Services
  • IIS

Why CubeView?
  • Meets the needs of organizations using Microsoft
    SQL database.
  • Requires minimum IT support for installation and
    system administration.
  • Reports presentable through dashboard pages or
  • Offers variety of reporting formats.
  • Publishing reports does not require any
    specialized tool.
  • Dashboard viewer accessible using URL.
  • URL linked dashboard viewer or pages can be
    embedded in intranet,
  • website or e-mail.

About C-BIA
C-BIA is a specialist BI solutions and analytics
services company. With more than 150 projects
executed successfully since 2004, C-BIA has
built expertise on Microsoft and SAS platforms
and worked on Oracle, Business Objects and some
open source platforms for client specific
Behind the Design
CubeView is a web based Reporting and Analysis
tool created by Center for Business Intelligence
and Analytics (C-BIA), based on their vast
experience into designing and building Business
Intelligence (BI) solutions.
Contact US
Center for Business Intelligence Analytics,
LLC 10685-B Hazelhurst Dr. 15378
Houston, TX 77043 USA Web
Write a Comment
User Comments (0)