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

how to find shared dimensions in two or more cubes in Mondrian

i have many cubes A B C ,... and i want to find all the common dimensions between these cubes by Mondrian notice shared dimensions in each cube could have different names so using of cube.getDimensions().getUniqeName() Or…
samira
  • 117
  • 9
2
votes
1 answer

Get a olap4j.OlapConnection from a org.h2.jdbc.JdbcConnection

Is there a way to get a olap4j.OlapConnection from a org.h2.jdbc.JdbcConnection? Right now I am trying this (as shown there ): Class.forName("org.h2.Driver"); Class.forName("mondrian.olap4j.MondrianOlap4jDriver"); Connection conn =…
Drahakar
  • 5,986
  • 6
  • 43
  • 58
1
vote
0 answers

olap4j errors after update Microsoft Analysis Server

I use olap4j 1.2.0 and olap4j-xmla 1.2.0 to request a Microsoft Analysis Server 11.0.5058.0 cube with MDX requests. No problem at all. Since a migration to Microsoft Analysis Server 14.0.249.14 (New cube, but same Cube) an error…
Maxime
  • 11
  • 2
1
vote
0 answers

Performance difference in SSAS query in MSS Studio vs Java MDX

For context, I am not an SSAS expert, or even an avid user, I'm primarily a Java developer. We have a data science team that uses SSAS to write, develop and test various models. In order to integrate the output of these models with other…
Matt
  • 3,303
  • 5
  • 31
  • 53
1
vote
0 answers

How to generta MDX query from cube? How to call using olap4j?

Iam developing java spring batch. one task i need to call and execute SSAS cube process. How to generate MDX query from cube? and how to call mdx query using OLAP4j? Thanks
Vinoth KRM
  • 11
  • 1
1
vote
0 answers

SSAS cube access from java

We are rewriting a .NET application with MDX, Microsoft.AnalysisServices.AdomdClient. In Java it is not easy to connect to Microsoft SQL Server Analysis Services, SSAS. We have 5 big MDX queries. Maybe to use this, as I understand, in this case…
user3136131
  • 1,028
  • 1
  • 10
  • 13
1
vote
2 answers

Are there any JOLAP or Olap4j driver available?

Are there any driver available for JOLAP or Olap4j to access existing OLAP services? I think on OLAP services like Oracle, MS SQL, etc. We want start a OLAP project with Java? With which of the both API should we start?
Horcrux7
  • 23,758
  • 21
  • 98
  • 156
1
vote
1 answer

olap4j errors after migrating to WildFly

Used olap4j 1.2.0 and olap4j-xmla 1.2.0 With JBoss 5.1 no errors, when app running on WildFly see next errors in logs: org.olap4j.OlapException: Internal error: hierarchy '[dimP].[ID P]' not found in cube 'LCube' and java.lang.RuntimeException:…
Rustam
  • 1,397
  • 1
  • 13
  • 17
1
vote
0 answers

Examples using Primefaces with Pivot4J

Sorry if this is a noob question. I am currently looking at using Primefaces as the front end to display data from a OLAP4J cube and MDX. I have looked at the Pivot4J analytics app and this works fine, but would like a simpler example to retrieve…
AndyC
  • 11
  • 1
1
vote
1 answer

How to add member name in MDX query

I have just started to work with OLAP Cubes. I have some questions about MDX queries. I have a query like: WITH MEMBER [Balance].[NegEXPENSE] AS '-[Balance].[Type].[EXPENSE]' SET BalanceTypeSet AS {[Balance].[Type].[INCOME],…
berkant.erdogan
  • 41
  • 1
  • 6
1
vote
1 answer

add where condition make MDX query slow (olap4j)

I'm using MONDRIAN server and OLAP4j API in a Java Web application, i have a performance issues when adding a where close to my queries. MDX query like : SELECT CrossJoin( {[Product.ProductHierarchie].[AllProduct]} ,…
Adnan.moe
  • 31
  • 4
1
vote
1 answer

MDX query takes forever to run in jPivot

I am working on a BI project. I am using mondian olap server and jPivot. I am using star model in schema file. The mdx query takes forever to run when I click on the last plus button for drilldown (coming from the right). In the DB there are only…
Tuhin Subhra Dey
  • 970
  • 6
  • 19
1
vote
1 answer

Olap4j/mysql, how I can generate or create Cube?

I do not know how I can generate or create Cube with Olap4j/Olap connection, when I have Cube I can load it and work with it, but I have database and I want from code generate Cube and save it as xml. So how many ways we have for it? Connection…
Armen Arzumanyan
  • 1,939
  • 3
  • 30
  • 56
1
vote
0 answers

dynamicreports mdx sample?

Does any one has a tutorial or a sample with dynamicReports using MDX query ? I'm trying to create dynamic reports from the result of an MDX query using Mondrian as a ROLAP engine and olap4j as a driver.
Kassandra
  • 87
  • 1
  • 14
1
2
3 4 5