Stack Overflow
Stack Overflow

Questions tagged [saiku]

Modular open-source analysis suite offering lightweight OLAP which remains easily embeddable, extendable and configurable.

Saiku is a modular open-source analysis suite offering lightweight OLAP.

Saiku's RESTful server connects to existing OLAP systems and provides analytics via a JQuery-based front end.

164 questions
9
votes
3 answers

Can we compare saiku with Pentaho Analyzer?

I'm currently in an internship and i have to create a whole BI application. I think i'll use pentaho, and I have to use just open source component. I know that Pentaho Analyzer is not free My question is: Is saiku an equivalent of analyzer? If yes,…
joris
  • 435
  • 1
  • 7
  • 18
8
votes
1 answer

java.lang.IllegalArgumentException: Unable to PTableType enum for value of 'MATERIALIZED VIEW' Exception with Phoenix and Hbase

I am very much new to Saiku. I am trying to integrate the saiku with phoenix. Phoenix intern connect with HBase. I created a schema and when the Saiku tries to load phoenix schema xml, Am triggered with below error. I am working restless to figure…
venky
  • 370
  • 1
  • 5
  • 18
5
votes
1 answer

Saiku: How to obtain licence for Saiku Pentaho plugin?

I am trying the Saiku Plugin for Pentaho CE. The plugin was successfully installed. Now It is asking to obtain a license from https://licensing.meteorite.bi But the site appears to be down for several days now. Is there another option to obtain a…
mtleis
  • 596
  • 1
  • 6
  • 21
5
votes
1 answer

Debugging BI Stack : MySQL + Mondrian + Saiku server

I'm trying to learn how to build a BI stack, but I'm stuck at understanding what part of the process failed : Designing a star schema : done Loading data from my OLTP database (MySQL) to my star database (MySQL too) : done with Pentaho Data…
AsTeR
  • 6,543
  • 12
  • 54
  • 91
3
votes
1 answer

how to use formula in Pentaho Mondrian schema XML

I'm working on Saiku reports in ReportServer. I have added a Mondrian Data Source. Now i would like to add two Rows in the report to show a Sum in the 3rd row, i did some R&D and found that we can use Cell formatter that can use Formula to use…
NoNaMe
  • 5,410
  • 30
  • 73
  • 98
3
votes
1 answer

Mondrian/Saiku - Closure Table - Null Pointer Exception

I am currently doing a PoC and facing a problem with closure table. I am using Saiku CE and database is postgres. Everything works until I add a closure table. If I remove closure table hierarchy, I don't get any error. If keep it I get the error. I…
Puneet Tayal
  • 31
  • 1
3
votes
1 answer

Pentaho 6: CDE and OLAP Selector wizard

I'am trying to create a Dashboard in Pentaho 6 with CDE. I'm follwing this tutorial (https://www.youtube.com/watch?v=Nq86J5t5c18). I already have a Cube and I've been using it on other tools like "Saiku", "New Openl Analysis report" and "Pivot4j".…
Evandro C.
  • 61
  • 5
3
votes
0 answers

Use saiku with apache hive

have you ever used Saiku to make data analysis on BigData Platform (Hadoop)? My recent work need to integrate some legacy BI tools with Hadoop to support common OLAP queries on HDFS/HBase. I found a solution implemented with Phoenix & Hbase here,…
He Bai
  • 285
  • 3
  • 11
3
votes
1 answer

Saiku cannot find JDBC driver for oracle connection

I'm using the all-in-one version of saiku and trying to connect it to my oracle DB. When starting saiku-server i got an error saying that it couldn't find the jdbc driver for oracle even if i put the driver in…
epsyl
  • 31
  • 4
3
votes
1 answer

Aggregate tables doesn't work in Pentaho Mondrian with Saiku

I am working for a project using the BI tools of Pentaho: Pentaho Mondrian. I am experiencing problems with the use of aggregate tables: for make aggregate tables I used Pentaho Aggregate Designer and I successfully created the DDL, populated the…
flatlopa
  • 111
  • 8
2
votes
2 answers

Apache tomcat unable to create a JDBC connection to Apache drill

I am using Mondrian OLAP FOR Analytics, We've been using Mysql but have decided to migrate to Apache drill. Now I have configured Apache Drill and I am able to connect is to Apache drill over external clients like SQuirreL Client, but When I am…
Kartik Shanbhag
  • 59
  • 2
2
votes
0 answers

Modify X-axis measures in Saiku

I have created one line chart using saiku. When I integrate it to a dashboard , its x-axis fields are getting overlapped. how can I eliminate this issue? My MDX query is given below. WITH MEMBER [Measures].[Price] as…
Juhan
  • 1,187
  • 1
  • 10
  • 26
2
votes
0 answers

Get XMLA Service working with Saiku CE?

I have been using Mondrian as a standalone app, but since Pentaho decided to not ship it completely I find it too hard to install standalone nowadays. After some research I found Saiku to be a good bundle to get Mondrian up and running smoothly. A…
wessman
  • 92
  • 6
2
votes
0 answers

MongoDB analysis with Saiku Community Edition

I am unable to connect Saiku with MongoDB using optiq even.I already copied Jars into saiku lib and web-inf lib. As saiku add data Source console doesn't have any Catalog field and also the url part too.
user3156128
  • 31
  • 1
2
votes
0 answers

SQLException: invalid schema name - saiku analytics pentaho using db2

I am using pentaho 5.2 for saiku analytics. I created a cube, published using schema workbench. The cube appears in the saiku list of cubes. But when I set the columns and rows to generate the report, I get an error saying "SQLException: invalid…
ArunKumar
  • 85
  • 1
  • 12
1
2 3
…
10 11