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.

163 questions
2
votes
2 answers

Saiku-CE 3.0 standalone: virtual cube not visible

I'm running Saiku Community Edition 3.0 with a simple schema: 3 shared dimensions and two cubes like this:
grzaks
  • 1,404
  • 2
  • 18
  • 31
2
votes
1 answer

saiku mdx performance issues with * operator for crossjoin

Can anyone explain why SELECT NON EMPTY {Hierarchize({[Measures].[Quantity]})} ON COLUMNS, NON EMPTY ([Time].[Years].Members * [Markets].[City].Members * [Product].[Product].Members * [Customers].[Customer].Members) ON ROWS FROM…
bluesony
  • 459
  • 1
  • 5
  • 28
2
votes
2 answers

Dimension properties of mondrian for saiku

I am designing a Cube in Mondrian schema for Saiku server. Following is the Dimension of the demo Foodmart schema which I need to replicate even for the cube I will be creating. I am not able to understand the role of 'Property' under 'Level'. Also,…
Ishani G
  • 21
  • 2
2
votes
1 answer

Creating a new cube with Saiku plugin on Pentaho

I have installed Pentaho Community Edition 5.0.1 and successfully created a new data source from a MySQL database (both hosted on my PC).I now want to perform OLAP analysis on this data, but am not entirely sure how to proceed (So please provide…
BOENDAGGER
  • 423
  • 5
  • 21
2
votes
1 answer

how to use saiku api webapp

I am new to saiku ,recently I want to use saiku api eg:http:///saiku/serverdocs/resource_QueryResource.html when I access my url :[your saiku domain] then I select one cube and some Dimensions,I could see the data,then I saved this…
user3678043
  • 23
  • 1
  • 3
2
votes
1 answer

Pentaho - How to add Saiku Analytics component on dashboard using CDE

I have a community edition of Pentaho and also installed 'Saiku Analytics' and 'Community dashboard editor' CDE. How can I add an interactive report on dashboard and have this dashboard available for a particular user.
mshakeel
  • 604
  • 6
  • 21
2
votes
1 answer

Mondrian saiku - vertica query translation error

Hi trying to use saiku with vertica. Vertica has the concept of db -> schemas -> tables. So in the xml file, instead of the table name, I am giving schemaName.tableName
amrk7
  • 1,194
  • 5
  • 13
  • 33
2
votes
1 answer

Saiku ui deployed separately saiku No query found with name

I am trying to integrate saiku-ui with my custom web application (say x.com). This communicates with saiku-server deployed somewhere else (say y.com) I've modified security settings so that users are authenticated anonymously which I got using these…
amrk7
  • 1,194
  • 5
  • 13
  • 33
2
votes
0 answers

Is there any way to add range in 'Date' dimension for saiku-analytics 2.3 plugin for pentaho-bi-server 4.5?

I am using Pentaho bi-server for data analytics purpose with saiku plugin as its community edition, It is working fine with normal dimensions but when i want feature like date range or dates greater than some specific date, there is no such…
Hardik Sheth
  • 198
  • 1
  • 12
2
votes
0 answers

Mondrian: null pointer exception when running MDX query for a role

I'm getting the following exception while running the MDX query "select {[Measures].[X]} on columns from [Metrics] where [Time].[2013].[May2013]". But there is no exception when i run with admin role. let me know if there is any issue with Role…
Arvindkumar
  • 184
  • 2
  • 16
2
votes
3 answers

How to create a Mondrian schema (xx.mondrian.xml) for MySQL data base

I am going to customise Saiku analysis tool for my local MySQL data base. For that I have to change the their existing data source as following manner,…
Channa
  • 4,963
  • 14
  • 65
  • 97
2
votes
3 answers

Edit JDBC connection string in Saiku

I am using Microsoft SQL Server as database for my web application. I'd like to use Saiku as part of the application. I found the solution to set up the JDBC connection string as…
Tipporn L.
  • 21
  • 2
2
votes
1 answer

Modify pentaho home page button

I'm beginning to work with pentaho. On the PUC i'd like to change the "new report" and "new analysis" buttons and replace them with (respectively) "saiku reporting" and "saiku analytics" For saiku analytics I found out how to do it I went in…
joris
  • 435
  • 1
  • 7
  • 18
2
votes
2 answers

Java Projects on Django?

ok, So i searched net for the possible implementation but all that I managed to find is Django projects implementation on Java platform through Jython. But I want to do the reverse, i.e. implement/integrate java project ( which in my case is SAIKU…
fassi786
  • 39
  • 7
2
votes
1 answer

Is the Pentaho Web service complete?

I want to build RESTful web service for communicate between Pentaho (Mondrian) and my application on Windows 8 Tablet (Javascript) and I found this site http://code.google.com/p/pentaho-cws/ but when I try to use the code in this project it seem…
user2073661
  • 21
  • 1
  • 2
1
2
3
…
10 11