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
1
vote
1 answer

Connect MS OLAP with Java

I have a data source which has a provider MSOLAP I want to connect to this source via java based application. I used the following: public static void main(String[] args) throws Exception { // Load the driver …
Muhammad Bekette
  • 1,396
  • 1
  • 24
  • 60
1
vote
1 answer

org.olap4j.metadata.Cube or mondrian.olap.Cube?

I'm developping an olap web application, for the object Cube I have 2 type of import : org.olap4j.metadata.Cube or mondrian.olap.Cube. What should I use ?
Kassandra
  • 87
  • 1
  • 14
1
vote
0 answers

Olap4j is not working with Jboss-5.1

I am developing a web application using JSF 2. In this application I am using SSAS Cube for fetching data. I am using Olap4j for connection with SSAS. But when I am trying to deploy my application in JBoss it is giving me following error: ERROR…
Abhay
  • 687
  • 4
  • 13
  • 22
1
vote
2 answers

Mondrian Olap ClassNotFoundException: mondrian.olap4j.MondrianOlap4jDriver

I have build a schema file with help of mondrian and sql server. Now I am writing code in java for database connection using olap4j. Code is : try { Class.forName("mondrian.olap4j.MondrianOlap4jDriver"); String…
Abhay
  • 687
  • 4
  • 13
  • 22
1
vote
1 answer

Query with calculated measurement using olap4j QueryDimension

I am using olap4j to query my rolap cube (underlying implementation is pentaho). I could not found any way to add on-the-fly calculated measurement to the query while using the org.olap4j.query package.(there is a way when using the low level api in…
yosi
  • 639
  • 1
  • 12
  • 21
1
vote
4 answers

Is it possible to process and query mondrian cubes without deploying to pentaho bi-server?

If yes, please give a reference. I did a little googling with no result. I want to use olap4j to query the cubes and use the result in a web application. But, I don't need any of the features of bi-server. According to tutorials, the olap schemas…
Farshid Zaker
  • 1,960
  • 2
  • 22
  • 39
1
vote
1 answer

Date range query with mondrian and olap4j

I am using olap4j to query a mondrian cube. I have defined a standard TimeDimension in my schema xml: …
yosi
  • 639
  • 1
  • 12
  • 21
0
votes
1 answer

Please suggest ways to start building Business Analytics solutions using existing mysql databases

I believe there are three layers to build up- 1) Presentation Layer/Data Visualization Layer 2) Constucting olap server(like mondrian) to access mysql database and produce results. 3)Using Olap Client API(olap4j) to build OLAP cubes that store…
user961053
  • 1
  • 1
0
votes
1 answer

Mondrian tries to optimize Segment.load weirdly resulting in partial or fully empty results

I feel like I am missing something: I have simple MDX query and rather simple Mondrian code, yet, it still behaves weirdly - that is the results of the query differ depending on whether XML schema contains unrelated to query dimension(s). At this…
SitaNVGS
  • 40
  • 1
  • 5
0
votes
1 answer

Unable to connect to XMLA/Mondrian using olap4j

I'm trying to connect to XMLA webservice through the java api (olap4j) in order to execute MDX queries over Mondrian cube which is sit in BI tool hosted in localhost. This is my code below : try { …
Brahim SLIMANI
  • 310
  • 1
  • 8
0
votes
1 answer

What should I use instead of deprecated mondrian.olap.Connection::execute?

So I am trying to use Mondrian 3.14 in Java 1.8, so I did something like this : String catalogFilePath = "/mdx_schema.xml"; String connectUrl = "Provider=mondrian;" + …
TheWildHealer
  • 1,546
  • 1
  • 15
  • 26
0
votes
1 answer

Apache Pool 2 library - connections not closed automatically

I have the following code in Scala that uses the Apache pool2 library. The object to pool is OlapConnection (an olap4j class, similar to an SQL connection). Problem is that I can't make the pool close the connections automatically when the number…
ps0604
  • 1,227
  • 23
  • 133
  • 330
0
votes
1 answer

How to access SSAS datapump url from UNIX box with windows authentication on

I'm trying to access SSAS through the data pump URL (http://SERVERNAME/OLAP/msmdpump.dll) with windows authentication on. 1) I was able to access the data pump URL through olap4j using windows machine. But how do i pass username and password for…
Omal Withanage
  • 85
  • 7
0
votes
1 answer

MDX Query returning different results

SO community, I'm having a problem with my BI application: I have a schema built on the Schema Workbench, and it works perfectly and accurately when I use the built-in query tester. However, the same schema returns different cell values for the…
J. Sallé
  • 213
  • 1
  • 8
0
votes
1 answer

Cannot connect to OLAP Cube via Olap4J API

I'm trying to connect to an OLAP Cube using Olap4J. I'm using jdk14 and olap4j-1.0.0.445.jar. I know the IP address of the server and the Catalog. But I'm unable to connect. The following exception seems to be the biggest problem: Server returned…
Martin Erlic
  • 5,467
  • 22
  • 81
  • 153
1 2
3
4 5