Index

Report Portal (ReportPortal.com)

ReportPortal is a client application that provides access to various data sources over the Internet. The application requires no client side software. It can run on Internet Explorer 5.5 or higher, Firefox, Safari or Chrome.

The application offers a role based security model. User and roles can be assigned to reports and folders as a reader, approver or as a publisher.

ReportPortal supports localization and customization using dynamic style themes.

The application is written using Microsoft technologies: JavaScript AJAX, ASP.NET, VB.NET, and Microsoft SQL Server. It also uses Microsoft XML for Analysis for OLAP data access.

ReportPortal provides access to Microsoft SQL Server Analysis Services OLAP data using the following reports:

Report Type

Description

OLAP report

A pivot table that lets user design the report online by dragging and dropping measures, dimensions and levels. This report provides:

Three data navigation modes: Drill-down, Expand and Expand All
Advanced charting including map and combination charts
Ability to add and use calculated measure
Ability to add and use named sets
Filtering by single or multiple member, date picker or value
Member search
MDX support
Member properties support
Actions support
Cell Write-Back support
Comments - for the entire report or a cell
Conditional formatting
Export to: Excel and HTML
Ability to limit set to top (bottom) N members
Drillthrough to detail
Sorting
Percentages
Paging
Printing
Email
Snapshot
Zoom-in

Microsoft OWC (Office Web Components) report

A pivot table that lets user design the report online by dragging and dropping measures, dimensions and levels. This report requires that Microsoft Office Web Components are installed on the client machine. The application will detect and help install the required components. This report type will work only in IE 5.5 or higher. This report provides:

Charting
Filtering by single or multiple member or value
Ability to add and use calculated measure (XP and up)
Ability to limit set to top (bottom) N members (XP and up)
Sorting
Percentages
Ability to create and use disconnected report (local cube)
Member search
MDX support
Member properties support
Actions support
Cell Write-Back support
Comments - for the entire report or a cell
Export to: Excel, HTML and GIF
Drillthrough to detail
Printing
Email

ReportPortal provides Data Visualization reports for OLAP data using the following reports:

Report Type	Description
Pie-Chart Tree report	Pie-Chart Tree report gives the ability to visualize multiple dimensions on a single page.
Bar-Chart Tree report	Bar-Chart Tree report gives the ability to visualize multiple dimensions on a single page. This information visualization method allows more than one measure to be selected as opposed to only a single measure for Pie-Chart Tree.
Tree Map report	Tree-Map report gives the ability visualize a lot of data on a single page. The user can select two levels (detail and grouping) and two measures (size and color).
Chart Grid report	Chart Grid report gives the ability to compare many charts on a single page. The user can select three levels (bars within chart and rows and columns) and many measures.
Moving Bubble Chart report	Moving Bubble report gives the ability to see how an attribute and three measures relate to each other over a time period. The user can select three measures (X Axis, Y Axis and Size), one attribute (Bubble) and the Time Dimension (Hierarchy and Level) For example, a user can select population size, GDP and live expectancy for countries for the last two centuries. Each bubble would be represented by a bubble. The size of the bubble would represent population size. The position on X Axis would represent GDP. The position on Y Axis would represent life expectancy. As the user clicks the play button, the slider would move from year 1810 to 2010.
Data mining report	This report lets user browse data mining models created in the Analysis Services. This report provides: Decision Tree and Clustering Mining Model Export to HTML Printing Email

ReportPortal provides access to Relational Data Sources using the following reports:

Report Type	Description
ROLAP report	A pivot table that lets user design the report online by dragging and dropping measures, dimensions and levels. This report provides: Two data navigation modes: Drill-down and Expand Advanced charting including map and combination charts Ability to design cubes online Filtering by single or multiple member, textbox, checkbox or date picker Provides access to multiple databases: Sql Server, Access, MySql, Oracle, and DB2. SQL Support Aggregation of fact table can be created or used Fact table partition support Printing Email Export to: Excel and HTML
SQL report	A tabular report that is designed online by using an SQL builder. This report provides: SQL Builder (supports stored procedures and functions) SQL Tutorial Filtering with dropdown, textbox or checkbox Printing Email Export to Excel Snapshot Zoom-in
Crystal report	This report allows viewing of Crystal Reports. This report supports: Multiple versions of Crystal Reports: 8.0 and up Filtering with dropdown, textbox or checkbox
Reporting Services report	This report allows designing and viewing of Microsoft Reporting Services reports. This report provides: Basic Report Builder (supports groupings) Using existing Reporting Services reports using URL Access
SQL template based report	Sql Template based report is a relational report based on SQL Report as a template. This report type is useful when report designers do not understand the database schema. Any SQL report can be used as a template. In the view mode of an SQL report, just click on the design button to use this SQL report as the template.

ReportPortal provides a way to design Dashboards and KPIs using the following reports:

Report Type	Description
Dashboard report	Dashboard report puts multiple reports on a single web page. This report provides: Tabs support Ability to drag sub-report inside of a tab and across tabs. Filters for OLAP Report Option to have horizontal and vertical report groups for each tab Ability to resize of groups and sub-reports Ability to apply a style theme for a report.
Freeform Dashboard	Dashboard report puts multiple reports on a single web page. This report provides: Ability to drag sub-report to any position Option to tile reports horizontally and vertically Ability to synchronize filters between OLAP reports
Analysis Services KPI report	This report lets users view Key Performance Indicators created in the Analysis Services 2005+. This report provides: Filtering by single or multiple member Ability to link a KPI to an external report Export to HTML Printing Email
Key Performance Indicators (KPI) Report	KPI report gives the ability do to design and view KPI reports. This report provides: Ability to design a KPI based on existing OLAP or SQL report Goal value can be based on a report or just a number Ability to select from a range of icons Ability to define green-to-yellow and yellow-to-red thresholds Ability to link a KPI to an external report Comments for each KPI Refreshing for each KPI

ReportPortal provides a way to Edit and Validate data using the following reports:

Report Type	Description
Data Entry	Data Entry report lets you edit or view data on the record level. This report provides: Ability to quickly design a data entry form to edit, add and delete data in a table. Ability to add and remove related records to a cross reference table. Ability to explore the data and relationships between data elements.
Data Entry Validation	Data Entry Validation lets you compare data between two tables. It provides a way to identify and fix records that don't match.

ReportPortal also provides other report types to help you Organize information:

Report Type	Description
File upload	Any file type can be uploaded into the application. The file is stored in the database.
Hyperlink	A hyperlink can be created to an external page. It has all the properties of a report. The hyperlink can be a web folder.
Wiki	Blog report provides the ability to create and view HTML page and drawings using an online editor.
Blog	Blog report provides the ability to display text/html entries in a reverse-chronological order.