Friday, October 22, 2010

Web based OLAP client for SSAS : Report Portal

I'm reading: Web based OLAP client for SSAS : Report PortalTweet this !
In my views, OWC (Office Web Components) available in SSMS is by no means a professional OLAP browser. Excel is one of the widely used client for browsing OLAP cubes, but there are some limitations with it when one wants to consider it as an enterprise client, some of which are listed below:

1) It needs to be installed on every client workstation
2) Data visualizations available are more suited for operational reporting than analytical reporting
3) There are almost no features for collaboration i.e. sharing generated reports with other users on a common platform unless you use Office Web Apps or Sharepoint
4) No spatial data support either in consumption or presentation with Bing Maps / Google Maps

Actually Excel has the capability to use OLAP / SSAS cube as a data source, but that does not mean that this capability can be treated as the primary purpose of using Excel. In one of my posts, I mentioned about
Analyzer which is a product from Strategy Companion. Recently I came across one another such product - Report Portal.

Zero footprint, SaaS, Cloud are some of the buzz words while selecting a technology / product for solution development, and Report Portal is also a zero footprint OLAP web client for SSAS. In my view, this product lacks that professional and sleek features that is expected from a web client. Documentation is quite poor, export formats of reports are limited, there is no mention of SaaS offering. But some of the noteworthy features of this product are as below:

1) Report portal has got very distinguished data visualizations, which are quite impressive from a data browsing point of view. You would not use these kind of data visualizations generally for reporting, but to develop analytical reports, these visualizations can be quite helpful for analysis. Check out the Pie-Chart Tree Report, which is one of the quite unique kind of data visualization for data analysis.

2) Collaboration and organization of the analyzed data, which can be saved in the form of reports, is considerably mature.

3) Metadata can be browsed very efficiently, and this product makes a very extensive use of XML/A ( XML for Analysis ). The browsing features are quite friendly to take away the pain of forming MDX queries.

If you use it as a tool to save your OLAP analysis i.e. the results that you gathered while browsing or analyzing OLAP data, and want to stick it in the form of reports on a collaborative platform, it's a nice web client with zero footprint installation ( as it's a web based solution ). But if you are looking out to use as a full fledged self-service enterprise reporting solution out of your OLAP, I would feel much more comfortable and confident in Analyzer than Report Portal.

A wise strategic move can be to use Report Portal when you are taking your baby steps in your OLAP reporting i.e. the phase when you are developing your data marts / data warehouse. This product could well support your OLAP browsing needs efficiently as well as facilitate reporting at the same time, keeping the pressure of immediate reporting from your evolving data warehouse, at bay. When the solution is in the next level, you can choose a SaaS reporting solution like Analyzer and retire Report Portal. Please keep in view, this always depends upon scenarios and it's not a generalized strategy. The key difference between Analyzer and Report Portal is that Analyzer is a reporting solution, and Report portal is a web client and reporting is one of it's features and not a primary function.

4 comments:

Igor Krupitsky said...

Hi Siddharth,

Which professional and sleek features does Report Portal lack?

Also can you please explain the difference between a reporting solution and a web client. What are the distinguishing attributes?

Siddharth Mehta said...

Hi Igor,

It seems you are much more well informed about Report Portal than I do.

Can you share a comparative list of features that are available in Report Portal from the pdf mentioned in the link below: http://www.strategycompanion.com/_Download/Analyzer%20Product%20Summary.pdf

Igor Krupitsky said...

Hi Siddharth,

Based on this document here is the list of features provided by Strategy Companion Analyzer and not provided by Report Portal:

1. Pre-Defined Measures – Rankings
2. Send annotated reports to other Analyzer (although ReportPortal lets you add comments to the email along with the report)
3. 80/20 Rule –(although ReportPortal provides Top-N% feature)
4. Analytic Chart Features
• Lock / Unlock function
• Transparent Effect

However, here are features supported by Report Portal but not by Strategy Companion Analyzer:

OLAP Report
• Date Calculation wizard http://www.reportportal.com/help/olap/filterTime.htm
• Date Picker and Ranges http://www.reportportal.com/help/olap/filter.htm
• Cascading Filters http://www.reportportal.com/help/olap/options.htm (None Empty Options - Filters depend on one another)
• Drillthough lets you select measures attributes/columns you want http://www.reportportal.com/help/olap/drillthrough.htm
• Sparklines http://www.reportportal.com/help/olap/Sparkline.htm
• Rows Filter http://www.reportportal.com/help/olap/rowfilter.htm
• Vieing and Editing MDX http://www.reportportal.com/help/olap/mdx.htm
• Write Back http://www.reportportal.com/help/olap/writeBack.htm
• Cell Comments: http://www.reportportal.com/help/olap/comment.htm


Advanced data Visualizations:
• Pie-Chart Tree report http://www.reportportal.com/Flash/PieTree.html
• Bar-Chart Tree report http://www.reportportal.com/Flash/BarTree.html
• Chart Grid report http://www.reportportal.com/Flash/Chart_Grid.htm
• Moving Bubble Report http://www.reportportal.com/Flash/Bubble/Bubble.html

Data mining report http://www.reportportal.com/Flash/mining.html
Office Web Components http://www.reportportal.com/Flash/OWC.html
Crystal Report support http://www.reportportal.com/Flash/Crystal.html
ROLAP Report http://www.reportportal.com/Flash/ROLAP.html
SQL Report http://www.reportportal.com/Flash/sql.html
SQL Template Based Report http://www.reportportal.com/help/sqlT/frame.htm
Data Entry Form http://www.reportportal.com/Flash/DataEntry/DataEntry.htm
Blog http://www.reportportal.com/Flash/Blog.htm
WIKI http://www.reportportal.com/Flash/Wiki.htm

BTW, here is another review of Report Portal by Chris Webb: http://cwebbbi.wordpress.com/2011/01/03/report-portal/

Anonymous said...

Υπάρχει προφανώς πολλά να μάθω γι 'αυτό. Νομίζω ότι έχετε κάνει κάποια καλά σημεία στα χαρακτηριστικά γνωρίσματα επίσης. Κρατήστε εργασίας, πολύ καλή δουλειά!

Related Posts with Thumbnails