Stack Overflow
Stack Overflow

Questions tagged [olap4j]

olap4j is an open Java API for OLAP. It is used by many open source BI projects including Saiku, Pentaho, Palo, Mondrian and JPivot.

72 questions
59
votes
1 answer

Mondrian: Cannot seem to get Aggregation Tables to be used

I have been struggling to get aggregation tables to work. Here is what my fact table looks like: employment_date_id dimension1_id dimension2_id dimension3_id dimension4 dimension5 measure1 measure2 measure3 I'm collapsing the employment_date_id…
chubbsondubs
  • 37,646
  • 24
  • 106
  • 138
12
votes
2 answers

Why use ROLAP instead of plain MySQL?

Are there any performance advantages in using a ROLAP server such as Mondrian on top of a MySQL database, as opposed to simply querying the MySQL database? I am asking this in the context in which most of my queries will be relatively simple (such…
Epicurus
  • 2,103
  • 7
  • 29
  • 39
10
votes
1 answer

Does spring-boot support any dynamic OLAP report generation tool?

I need to add OLAP report support into my existing spring boot web application. I have come across multiple BI tools like BIRT, JasperServer Report and Saiku but for all of them, I have to use an already created cube. In case, there is any…
Dharita Chokshi
  • 1,133
  • 3
  • 16
  • 39
4
votes
1 answer

Presentation of data from Mondrian OLAP engine + Olap4j

I'm doing a little bit of planning of an application that uses Mondrian OLAP engine with Olap4j and should present/display data to user. I understand all the back-end stuff, but I'm not sure how should I display the data in the view layer. For…
lisak
  • 21,611
  • 40
  • 152
  • 243
3
votes
0 answers

Olap4j mdx query is taking too long to execute on SSAS cube

While executing MDX query from olap4j through http services(msmpupm.dll) its taking too long. As a test the following query on predefined cube(adventureworksdb) is taking 3 seconds on ssas and 180 seconds from olap4j. SELECT NON EMPTY {…
smali
  • 4,687
  • 7
  • 38
  • 60
3
votes
1 answer

Microsoft SSAS OLAP Connection from Java Code

I am new to the concept of OLAP DB. Please excuse me if I missed out something in the Connection String. I am trying to connect to connect to Microsoft Analysis Server(which is in different Domain) from my System. While Connecting I am getting below…
siddhartha chakraborty
  • 425
  • 1
  • 5
  • 12
3
votes
1 answer

exception while trying to connect to SSAS cube?

when i try to connect the SSAS cube using the olap4j drivers,this exception just came out,and search the internet ,just cannot get any information! the exception output just as below: Exception in thread "main" java.lang.NoClassDefFoundError:…
user3197462
  • 31
  • 2
2
votes
1 answer

Pentaho Mondian : Mondrian Schema xml Vs Pentaho metadata domain xmi Vs CDA cda files

I have been exploring the Pentaho ecosystem. Please forgive any naive things in the question. There are a couple of things about these config files ( containing domains names and its mappings etc ) that I can't seem to put my finger on. So, if you…
smartnut007
  • 6,324
  • 6
  • 45
  • 52
2
votes
1 answer

'No suitable driver' exception implementing Olap4J XMLA Server

I'm trying to implement olap4j-xmlaserver to access Mondrian via HTTP/XMLA. I compiled the project, created a war file (including a web.xml file) and deployed it in Tomcat 7. Problem is that I'm getting an exception when the pivot client application…
ps0604
  • 1,227
  • 23
  • 133
  • 330
2
votes
1 answer

Is OLAP4J dead and is there a replacement equivalent?

Is OLAP4J (Java library for connecting to XMLA services) dead? The things that suggest it is are: The web site hasn't been updated since 2013. The last message on the dev mailling list was in May 2016. The last available release build was 1.2.0, in…
jon hanson
  • 8,722
  • 2
  • 37
  • 61
2
votes
1 answer

Issue with Maven dependencies on a 32bit and 64 bits platform

I have an issue with my pom.xml file. I have a project made with Spring MVC and uses this dependency: net.sf.jasperreports jasperreports 6.3.0 The…
georgeguitar
  • 95
  • 8
2
votes
0 answers

Pentaho reports with OLAP data source and SAP BW - poor performance

I have few BEx queries (OLAP cubes for third-party client) and .prpt reports in Pentaho that uses these BEx via OLAP data source (OLAP4J, MDX). When I execute these BEx in SAP BW or even directly as SOAP service (XML/A execute command via SoapUI),…
semenchikus
  • 730
  • 8
  • 17
2
votes
1 answer

olap4j. MDX (XMLA) query takes too long

I have simple MDX query. It takes less than 1 second to execute it: SELECT NON EMPTY { } ON COLUMNS, NON EMPTY {[Z_OP].[LEVEL01].MEMBERS * [Z_NV].[LEVEL01].MEMBERS * [Z_DT].[LEVEL01].MEMBERS } ON ROWS FROM [Z_TEST/Z_TEST_REQ] However…
Aries
  • 433
  • 7
  • 17
2
votes
0 answers

Pentaho BI data source for custom OLAP (XML/A) provider

I need to be able to create simple ad-hoc reports on Pentaho BI using plugins like Pivot4j or Saiku. My data provider is SAP with XML/A interface. So the question is how could I create an OLAP data source that based on XMLA protocol? Or it is…
semenchikus
  • 730
  • 8
  • 17
2
votes
0 answers

Unable to connect to SSAS using olap4j on Linux

I wish to connect to SSAS 2012 using Java and have tried olap4j driver for the same. I am working on Linux (Ubuntu 14.04) platform. I have read that Olap4j works for Windows but will it work on Linux ? I have written some Java code which gives…
Anjali
  • 31
  • 2
1
2 3 4 5