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 multidimensional, 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 Graphical). 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
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 viewer. • 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 requirement. 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: www.cubeviewtech.com