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
0
votes
2 answers

Saiku,Mondrian performance degrades with large amount of data

We are using mondrian olap schema with saiku to analyse our records.We are using star schema model.We have one fact table which contains around 3000000 records. We have four dimension tables timestamp,rank,path and domain. Timestamp is almost unique…
DEVANG PANDEY
  • 147
  • 1
  • 14
0
votes
1 answer

How can use another database instead of foodmart

I am not much familiar with saiku reporting. When I run the saiku reporting this display cube for foodmart db. But I want to use database from postgresql. For that I made one connection file. Added driver.jar file in to web-inf/lib folder. But I…
Shyam Solanki
  • 87
  • 10
0
votes
2 answers

Adding a Saiku Plugin - Saiku Chart Plus

I'm trying to run Saiku with a plugin, Saiku Chart Plus (http://it4biz.github.io/SaikuChartPlus/) without Pentaho BI. I've followed the instructions on the download page for the advanced installation, editing the saiku/ui/index.html file and adding…
orange1
  • 2,349
  • 2
  • 22
  • 50
0
votes
0 answers

Error loading pentaho cube using saiku

Saiku plugin 2.5 for Pentaho 4.8, windows 7 , oracle 10g. When starting the Saiku analytics view i'm getting this error: name:puc1 driver:mondrian.olap4j.MondrianOlap4jDriver url:jdbc:mondrian:Provider=mondrian;…
haki
  • 8,571
  • 12
  • 51
  • 101
0
votes
1 answer

schema designing in data warehousing and mining

I am bit confused between fact and dimension tables and I am not able to clear my doubt . Thing is I have to design a schema where there is one keyword table . And corresponding to each and every keyword we have a date table and site table(that…
DEVANG PANDEY
  • 147
  • 1
  • 14
0
votes
2 answers

Deploying Saiku UI on Glassfish

When I try to deploy saiku-ui-2.4.war to Glassfish I get "There is no installed container capable of handling this application ROOT. Please see server.log for more details." The server.log…
MrRaymondLee
  • 538
  • 5
  • 12
0
votes
1 answer

Issue connection to MySQL through jDBC with saiku

This is my file…
dani herrera
  • 39,746
  • 4
  • 87
  • 153
0
votes
1 answer

How I manage the sample datasource in Saiku

I installed the Saiku as a plugin in Pentaho 4.8. Saiku comes with the sample data which is SteelWheels. The user is able to choose "Select a cube" in the dropdown box. I just need to know how can I modify the data in that sample data? Where is the…
Supajak Thamwongsa
  • 19
  • 4
0
votes
1 answer

Adhoc saiku queries

With no luck finding on net, I am bound to ask this here. How does Saiku makes queries to mondrian? If some one can kindly point to the exact path of query generation to result display it will be just perfect. Thanking in advance =)
fassi786
  • 41
  • 7
0
votes
1 answer

Report, Ad hoc report and Dashboard in pentaho

I'm currently working on a project to implement a BI solution. I chose Pentaho There are many tools to create: reports (report designer) adhoc reports (WAHQR ou PIR) Dashboard (dashboard designer or CDE) Analyze (analyzer or saiku) (in big the one…
joris
  • 435
  • 1
  • 7
  • 18
-1
votes
1 answer

Saiku 3 standalone with PostgreSQL - Mondrian Error on Select

I'm using the latest Saiku 3.8.3 standalone and I'm having some problems using the database PostgreSQL 9.1 with different schemas then PUBLIC. I made the datasource and it connected correctly, here is the data source I'm using without personal…
Fizard
  • 11
  • 4
-1
votes
1 answer

Where to download old version 2.6.x of Saiku

I have downloaded Saiku CE from http://community.meteorite.bi/. Information in REAME file: " SAIKU README Saiku Suite V2.1 GA OSGI Ltd ... … Important known problems There is an issue with XML/A connections with Mondrian XML/A instances. This issue…
Vittery
  • 25
  • 6
-2
votes
1 answer

Exploring Apache Kylin cubes with Power BI?

I had some conflicts with my teammates about if it is really the Power BI can read and explore Apache Kylin Cubes or it is just exploring the Data source, I had some problems with saiku exactly in the Mondrian schema that's why I am using Power BI,…
Khalil Mejdi
  • 44
  • 7
-3
votes
2 answers

How to convert this SQL query into MDX query?

I'm using pentaho saiku analytic to perform cube analysis. But in some case, i need to build my own query with MDX query. below is my sql query. select idAction,count(idAction) from table1 group by idAction; note: idAction is one of the measures…
user1234
  • 1
  • 3
1 2 3
…
10
11