olap4j is an open Java API for OLAP. It is used by many open source BI projects including Saiku, Pentaho, Palo, Mondrian and JPivot.
Questions tagged [olap4j]
72 questions
0
votes
1 answer
Execute query on SASS cube with XmlaOlap4jDriver on Weblogic
I wrote a java class with the main() method to connect to "msmdpump.dll" and execute MDX on cube and retrieve a result. like this :
public static void main(String[] args) throws ClassNotFoundException, OlapException{
…
soheilz92
- 127
- 2
- 19
0
votes
1 answer
How to report the result of an olap4j query?
I wan't to create report from the result of an olap Query, the result type is a cellSet. Does any one have any idea.
thx
Kassandra
- 87
- 1
- 14
0
votes
1 answer
How do I access these xml files from some other machine?
I need to access the cubes through olap4j API in java application. XML cubes files will be available in some other IP server. For Example, XML files will be in 192.168.1.1 IP and C:\Program Files\Apache Software Foundation\Tomcat…
user3027299
- 217
- 1
- 4
- 7
0
votes
1 answer
How to use olap4j api to get the mysql column names from the schema file
I am beginner with the BI concepts and mondrian .I am using olap4j API with mondrian server and my requirement is to get the mysql column names mapped in the schema file or metadata about the database . Basically i am able to connect and can execute…
Naresh G
- 11
- 4
0
votes
1 answer
How do I put measures in MDX query using Olap4j
Olap4j documentation gives a good example of constructing simple MDX query:
Query myQuery = new Query("SomeArbitraryName", salesCube);
QueryDimension productDim = myQuery.getDimension("Product");
QueryDimension storeDim =…
ivstas
- 1,203
- 1
- 16
- 31
0
votes
1 answer
Not able to access MSSQL analysis services cubes
I am using the following code to access mssql analysis services cubes from java using OLAP4j 1.1.0
Class.forName("org.olap4j.driver.xmla.XmlaOlap4jDriver");
OlapConnection con = (OlapConnection)…
Anurag Saxena
- 11
- 1
- 3
0
votes
0 answers
JasperReports: fillReport in Java with XML-A datasource (Olap)
I have a Java service that I generates reports with the JasperReports 4.0.5 library. It works well with standard JDBC datasource.
Now I am trying to run it on olap datasource, then connecting me to a XML-A server.
In the design phase with iReport,…
T. Phanelly
- 189
- 5
- 17
0
votes
1 answer
olap4j connection to Analysis Service
hi i am trying to connect to microsoft analysis service through olap4j but i got this error every time "org.olap4j.OlapException: This connection encountered an exception while executing a query"
This Full Description of Error :
22:30:45.331…
Kromer
- 125
- 1
- 2
- 9
0
votes
1 answer
Symbol not found - Java
I'm using Olap4j to connect to the OLAP server in GWT. However, when I try to iterate through rows and columns I get a 'Symbol not found' error during compilation.
My code
for (Position axis_0 :…
Crowlix
- 1,269
- 9
- 19
0
votes
2 answers
Play Framework 2.1.0 - NoClassDefFoundError when registering JDBC driver using Class.forName
I am trying to use olap4j with Play 2.1.0 but am having great difficulty in getting some olap4j code to work in a Play controller, this same code works just fine in a separate Eclipse Java project, hence I have ruled out any issues with olap4j or my…
user2162484
- 91
- 2
- 8
0
votes
1 answer
Get the root level of dimension in Mdx using olap4j Api
I have a problem that's really killing me. BTW I am new to Mdx and using olap4j Api to construct MDX Query. My problem is with the root element, Following is the code snippet:
Query myQuery = new Query("Generated Query", sales); // where sales…
Patton
- 2,002
- 3
- 25
- 36
-1
votes
1 answer
java.lang.ClassNotFoundException: org.pentaho.reporting.libraries.resourceloader.ResourceException
I'm trying to create a report from an olap4j datasource
DriverConnectionProvider provider = new…
Kassandra
- 87
- 1
- 14