9

I have cube on MS SQL Server and I want to install a web based visual client tool for exploring and analyzing OLAP databases. A cube is an array of data understood in terms of its 0 or more dimensions. That web-based app should support:

  • data exploration/auditing
  • generation of reports
  • generation of embeddable charts/graphs
  • Did anybody use pivot4J? – borjab Feb 2 '15 at 11:07
4

I have used and recommend Saiku.

It is a Pentaho plugin, you have to install it from Marketplace after you have installed and launched the Pentaho BI server.

Saiku allows you to explore and drill down data with a nicer interface than Pentaho's default.

It also allows you to quickly create graphs:

enter image description here

To create more advanced reports/dashboards, Saiku also allows you to get the MDX for the current exploration, which you can then use with the "Community Dashboard Editor" plugin.

  • Thank @Nicolas Raoul, could I access to the "mssql CUBE" which it was created by someone else and I want just to use it and analyse its data ? In other hand could I use third party CUBE on that ? – soheilz92 Mar 4 '14 at 10:33
  • Yes, you can use MSSQL data as well. I believe that any cube is OK as long as it is written in standard MDX. – Nicolas Raoul Mar 4 '14 at 11:55
  • Hey @nicolas-raol, I installed Saiku and connected it to SSAS after so many challenging, now do you know can I display Saku server chart in other 3th party web application? I just want to display our created chart on some web pages (.jsf) – soheilz92 Mar 12 '14 at 8:16
  • @soheilz92: Yes, open your chart, go to the MDX dialog, copy/paste, then use this MDX in your third-party application. – Nicolas Raoul Mar 12 '14 at 8:23
  • @nicolas-raol :No, I mean only displaying a chart on other web pages, some thing like I user saiku taglibs and send some request to saiku server and it response a respected chart. – soheilz92 Mar 12 '14 at 8:25
2

Actually there are a lot of apps with some similar features and with some differences. I'd made a short presentation for inner clients during my work to choose an app for us. As a user of BI, not a developer, I looked at app from simple point of view. I wish it works fine, do what I need for the cost we can pay. As i understood there is no full web-analog to exel which works fast with different types of cubes, has same or very close features and can be easily configured.

Your choice depends on how you want to use it, what is cost limitations and what is more important for you (work with bid ammounts of data, concrete visualisation features, easy configuration..) and what plans do you have for this app, can their support make a custom project for you etc.

Webpivotable costs not much, works fine, but their design may be better, but thats just for me. Here their demo.

icCube - nice team, support, tool totally for OLAP and their webreporting tool is enough for some usual needs, but not more. Regarding futher detailisation, this is not for you.

Flexmonster - looks nice, works good, professional team and possible different types of customization, but quite costly.

Dundas is really not bad too, actually. You need to sign in to get their demo.

If you tell me more about your needs I'd try to be more specific. These apps were the first ones I remembered.

  • Thanks for your answer. In my organization (insurance company), their looking for open source (java based preferred ) app, to work with pre-created cube in SSAS, they asked me to find a web application for top-level manager for analytic issues. – soheilz92 Mar 12 '14 at 8:18
  • Than, let me think.. really saiku or jpivot, both open source and java. github.com/rjackson/pivot.js - open source too but written on coffescript. Good luck in your search! – user3375936 Mar 12 '14 at 9:00
1

What I have found till now is Pentaho.
The open source BI tool which has tow servers (BA Server and Data Integration Server) and several tools.
It has web console to touch it with web browser, but the tools are windows application.
The other thing I have found is Pentaho has its own Cube Designer and you should design your Cube with that in order to analyze it in data analyzer web application.

  • I installed Saiku and connected it to SSAS, it works fin :) other tasks are coming to me to do with Cube viewer :D – soheilz92 Mar 12 '14 at 8:35
1

I have conducted a trial of Kyubit and it is a very good portal for OLAP dashboards. They have an aggressive release cadence with frequent improvements to their functionality. For a small to midsize business or department using Analysis Services, this is an excellent option.

0

Syncfusion Olap Client allows for connecting to SSAS and analyzing cubes. There is a free community license available.

Note: I work for Syncfusion

0

Best web based OLAP browser and much more is our product 'Kyubit Business Intelligence'. You're gonna love it on first sight.

www.kyubit.com

enter image description here

  • If you plug your own product, at least be honest enough to say so in the text. – Christian Aichinger Apr 4 '16 at 9:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.