10

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
Improve this question
1
  • Did anybody use pivot4J?
    – borjab
    Feb 2, 2015 at 11:07

7 Answers 7

Reset to default
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.

Improve this answer
6
  • 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, 2014 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, 2014 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, 2014 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, 2014 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, 2014 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.

Improve this answer
2
  • 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, 2014 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, 2014 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.

Improve this answer
1
  • 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, 2014 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.

Improve this answer
0

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

Note: I work for Syncfusion

Improve this answer
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

Improve this answer
1
  • If you plug your own product, at least be honest enough to say so in the text.
    – Christian Aichinger
    Apr 4, 2016 at 9:32
0

As for 2019 there are several new alternatives in addition to the already mentioned in prev answers:

  • PivotData microservice if you're looking for something that can be is seamlessly integrated into existing web application. Can connect directly to SQL-compatible databases including OLAP DBs like BigQuery, Redshift, ClickHouse. Connector to OLAP cubes (XMLA client) was added recently. Unlike many other solutions you can specify custom MDX templates.
  • SeekTable which is a standalone web-based BI tool, has both cloud and on-premise versions (can be used for free, only advanced functions require a subscription). With 'publish to web' functionality reports may be embedded into any other webapps with IFRAMEs. SeekTable uses PivotData microservice under the hood, so support of data sources is exactly the same.

Disclaimer: I'm affiliated with these products.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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