Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

Report Portal

with 3 comments

As I say whenever I talk about third party products here, I don’t do reviews on my blog, I just highlight products that look interesting and probably deserve closer inspection. So here is a non-review of a client tool I had a demo of today, Report Portal, a thin client, pure-html solution that includes both ad-hoc browsing capabilities and dashboarding/reporting. Although the UI looks a little dated, the fact that nothing needs to be installed on the desktop, that there are no requirements that might fall foul of corporate IT policies (which might, for example, rule out a Silverlight solution), and that it is licensed on a per-server basis do remove a lot of potential deployment headaches. 

Rather conveniently, Igor, the guy who gave me the demo, realised that I’ve seen hundreds of client tools for SSAS and just showed me the features that make this particular product stand out from the pack, so that’s what I’ll talk about. Here are the main points:

  • It automatically creates a number of date calculations and relative time selections (such as ‘current month’, ‘previous month’) for you, meaning you don’t have to develop them yourself.
  • On time dimensions you can set up selection by a date picker, and also do date range selections by selecting a start and end date.
  • It can also do cascading parameters rather like what’s possible in SSRS or with Excel 2010’s slicers.
  • For drillthrough it allows you to build your own drillthrough query, select which measures you want, which attributes/columns you want and the order you want the columns to appear
  • There are a wide range of charts and visualisations to choose from, including an interesting (although possibly not Stephen-Few-approved) pie-chart tree report.
  • There’s also a load of other features, such as the ability to embed SSRS, OWC, SQL-based and other report types in dashboards; it supports writeback; it allows you to save comments in cells; and there’s also a blog and a wiki inside the portal.

Overall, it’s a solid, mature product that’s been around for six years and does pretty much everything you’ll want. Definitely looks like one to add to the shortlist if you’re looking for a zero-footprint SSAS client tool.

Written by Chris Webb

January 3, 2011 at 11:20 pm

Posted in Client Tools

Tagged with

3 Responses

Subscribe to comments with RSS.

  1. Hi Chris, first of all: i wish you and your family all the best for 2011!

    And that sounds amazing! Will have a look immendantly.

    Dietmar

    Dietmar

    January 4, 2011 at 8:53 am

  2. Hi Chris,

    Great article. And it is also nice to know that you can use in ReportPortal any XMLA OLAP server like SSAS, SAP /BW or the new icCube: http://www.iccube.com

    Marco

    Marco

    January 5, 2011 at 8:58 pm

  3. This tool seems to have the answer that most BI client tools fall short of. For example, 90% of my projects involve missing source data and metadata that needs to be constructed. Typically, you would have to get another group to build the CRUD. Report Portal has a very simple, yet advance, CRUD system that a power user can construct.

    Regards,
    Paul

    Paul

    March 13, 2013 at 7:33 pm


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 2,868 other followers

%d bloggers like this: