Feed Icon  


  • Bryant Likes
  • Send mail to the author(s) E-mail
  • twitter
  • View Bryant Likes's profile on LinkedIn
  • del.icio.us
Get Microsoft Silverlight
by clicking "Install Microsoft Silverlight" you accept the
Silverlight license agreement

Hosting By

Hot Topics


Open Source Projects



Wanted: Cube Browser WebPart

Posted in Reporting Services | SharePoint at Monday, March 1, 2004 8:08 AM Pacific Standard Time

At my new job we are doing a lot of work with OLAP cubes. We have to create reports that run off these cubes. We also use SharePoint as our dashboard technology to display these reports. Currently we are using two main technology to access our cube data: Reporting Services reports and Office Web Components.

The problem is that Reporting Services reports don't offer a lot of functionality to the user. They can view the data, change the parameters, but that is pretty much it. We can show/hide stuff but really there isn't much functionality other than giving the users a very cheap access to the data. On the other end of the spectrum, Office Web Components offer a lot of functionality to the user but don't give the user a good way to print. They also have enough features to thoroughly confuse users and they directly hit the cubes.

What I would like to have is a WebPart that displays data in a grid so that the user can sort and filter all they want without directly hitting the cube. But when they hit the print button I want the same data that is in the grid to be displayed in a Reporting Services report so that I can give them pretty reports.

I'm thinking about building this myself since I haven't been able to find anything like this so far. I'm thinking that I will have to generate the RDL base on what the user has setup in the grid. Or maybe I will just let the user save the state and only the admin can generate the RDL. Either way it would be a lot of work and I really wish there was a good solution already out there.

Monday, March 1, 2004 8:17:00 AM (Pacific Standard Time, UTC-08:00)
Perhaps our Snowflake.net component fits this need. It provides tons of wrapped up functionality for OLAP, however you, the developer, can choose how much of that functionality is exposed to the end-user. On the other hand the fact that the source is available with our Intellimerce source license means that there is also no dead-end in terms of implementing functionality that we might not already have. The list of functionality is too long for a post but most of OLAP front end actions are implemented and all within an MVC in asp.net with grid and charts synchronized. I hope you like it.
Monday, March 1, 2004 10:32:00 PM (Pacific Standard Time, UTC-08:00)
I should have mentioned the company is Intellimerce Inc, <a target="_new" href="http://www.intellimerce.com">http://www.intellimerce.com</a> and the product is Snowflake.net.
Thursday, May 13, 2004 4:46:00 AM (Pacific Daylight Time, UTC-07:00)
Try looking at www.dsppanel.com
Sunday, May 30, 2004 9:09:00 PM (Pacific Daylight Time, UTC-07:00)
<br>I was wondering if you managed to come up with a solution to your problem?
<br>I'm sitting in the same situation as you.
<br>People have recommended Snowflake.net however my superiors are not too keen to on purchasing the licence for a product that can be developed by a member of our team.
<br>Please could you offer some advice on a good route to follow.
Tuesday, October 19, 2004 4:23:00 AM (Pacific Daylight Time, UTC-07:00)
<br>In theory, wouldn't it be cheaper to buy a tool that someone else maintains and upgrades than to put the money and effort into internal development? Employees' time costs money, too, doesn't it? :)
Tuesday, November 9, 2004 1:05:00 AM (Pacific Standard Time, UTC-08:00)
<br>OWC is hidden within Reporting Services for presentaion. Let's say you generate a Pivot table with Reporting Services, nothing is stopping from Exporting the data from the Pivot table to PDF and then let the users print the PDF. Let me know what you think of this
Sathi V
Friday, December 3, 2004 5:03:00 AM (Pacific Standard Time, UTC-08:00)
I have developed an ASP based application. Let me if you are interested
Thursday, January 20, 2005 3:09:00 PM (Pacific Standard Time, UTC-08:00)
I am intersted.. Pls. could U share with me..
Monday, July 11, 2005 2:04:00 AM (Pacific Daylight Time, UTC-07:00)
<br>I'm also intrested....
<br>Thanks in advance
Thursday, February 23, 2006 5:55:13 PM (Pacific Standard Time, UTC-08:00)
hello i'm much interested in this too ..
how can i approach for a view ...

thanks, Andy
Sunday, February 26, 2006 7:43:19 PM (Pacific Standard Time, UTC-08:00)
plz let me know.im with the same problem
Sunday, February 26, 2006 7:45:03 PM (Pacific Standard Time, UTC-08:00)
Monday, November 20, 2006 4:24:36 PM (Pacific Standard Time, UTC-08:00)
Hey if you still need a cube browser that can be used with Web Parts then our BIWEB can. al so you could take an look at www.targit.dk thay have an web wesion of there app... this can allso be used af web parts
Wednesday, December 13, 2006 2:00:22 PM (Pacific Standard Time, UTC-08:00)
OWC (Office web components) might be the solution however you can check CellSetGrid too:
Mehran Taheri
Sunday, June 15, 2008 6:54:03 PM (Pacific Daylight Time, UTC-07:00)
Hi i am a student in Egypt Working on My graduation Project My Prof Said to me My reports with SSRS is nothing because it does not support pivoting dragging and dropping Dimensions from filters So please same Problem here And need Much help
Tried already Snow flack and targit cants manipulate the table online on IE . Any help will be Great Help . Than you For having this Blog
Mohmmed Fekry
Comments are closed.