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
Use INT vs. DATE in where clause
I have two tables in a data warehouse: balances and dates. Balances has the following structure:
Surrogate Key Date | Date | Account | Balance
1 | 2017-02-01 | 100 | 1234
1 | 2017-02-01 | 200 | 5151
2 …
ps0604
- 1,227
- 23
- 133
- 330
0
votes
1 answer
How to read column header and row header in mdx using olap4j
I have a mdx query which gives me the result as shown in the attached image.
I want to read the dimensions i.e column headers and row headers in from java using olap4j libraries.
Using getCell method I can read the values, can anyone tell me which…
RGowda
- 1
- 2
0
votes
0 answers
olap4j and Microsoft Analysis Services cache
I'm using olap4j 1.2.0 to connect to Microsoft Analysis Services.
My code is
Class.forName("org.olap4j.driver.xmla.XmlaOlap4jDriver");
OlapConnection olapConnection =…
fightlight
- 946
- 1
- 11
- 12
0
votes
1 answer
how to read data from 2nd column in mdx query using olap4j
I have mdx query and which results data in 2 columns.
How do I read the data in second column using CellSet in java.
I'm using CellSet.getcell(index) to read data from the 1st column in the mdx query.
| Column1 | Column2 |
| 111 | 222 |
user3566201
- 47
- 1
- 7
0
votes
1 answer
Performance issue with MDX query
I'm trying to get top 5 records from MySQL database based on some filters using below MDX query and cube definition.But, this query takes more time for execution and this works fine when we have less no.of FILE_NUM's in where condition. Please…
sgelle
- 53
- 1
- 2
- 10
0
votes
1 answer
How do I get .AllMembers of Hierarchy in olap4j?
I have an MDX query like this:
SELECT {[Gender].[Gender].AllMembers} ON COLUMNS,
{[Geography].[Country].AllMembers} ON ROWS FROM [myCube]
And I am trying to get this query as an olap4j object. I do this to set my dimension:
QueryDimension…
mmaceachran
- 3,178
- 7
- 53
- 102
0
votes
1 answer
OLAP4J: How to connect to a Cube using username and password
I am using olap4j libraries and trying to connect to a SSAS Cube.
I understand that the general syntax is,
Class.forName("org.olap4j.driver.xmla.XmlaOlap4jDriver");
Connection conn = DriverManager
…
Harish
- 181
- 1
- 3
- 11
0
votes
1 answer
Pivot4j/Olap4j adding condition to where clause of generated query
I have a ROLAP cube - Pivot4j 0.9, Olap4j 1.1.0, MySQL.
When I run the following MDX I can see an additional condition in the where clause which causes the resulting statement to return no rows.
SELECT Hierarchize({[Measures].[Unique Users]}) ON…
JohnnyD
- 477
- 1
- 4
- 19
0
votes
2 answers
How to include members with specific children in MDX query cross join?
I'm new to MDX, and I have following scenario. I have to calculate revenue across specific department (product dimension), specific store (location dimension) and across specific time range.
I have my cube levels as follows.
Product <- Department…
gowtham
- 3
- 3
0
votes
1 answer
AssertionError on Olap4j with SSAS 2012
We are trying to run a OLAP query with olap4j against SSAS. I've managed to setup the XML/A endpoint, and SSMS connects to the endpoint correctly and works fine.
However each time I try to run a query from JAVA it…
Aron
- 15,464
- 3
- 31
- 64
0
votes
2 answers
Exception getting olap4j connection in pentaho 5.2
I have two Pentaho plugins. One made in GWT work in 5.0-5.2 and return all dimensions I need. Now I need refactoring without gwt. I put conection code in my new REST service and code work well in pentaho 5.0 but fail in 5.2. I believe the problem is…
Manuel Molina
- 83
- 1
- 9
0
votes
1 answer
spatial mdx date aggregation function is not working with date like 01/01/2014
This is my mdx that is emitting error:
`with member [Measures].[incident_type] as '[incident].CurrentMember.Properties("incident_type")'
member [Measures].[incident_desc] as '[incident].CurrentMember.Properties("incident_desc")'
member…
Ranjeet Paswan
- 111
- 10
0
votes
1 answer
olap4J - calculations on member grouping
I'm trying to write an olap4j (Mondrian) query that will group the rows by ranges.
Assume we have counts of cards per child and the children ages.
i want to sum the cards amount by age ranges, so i will have counts for ages 0-5,5-10,10-15 and so…
Yogev Caspi
- 151
- 12
0
votes
1 answer
Can't get data from Essbase
I'm new at OLAP services.
I want to get data from Essbase using olap4j.
I'm sending this request:
SELECT {[Year].[Jan]} on COLUMNS from [Demo.Basic]
and get an error that database Basic does not exist:
XMLA provider gave exception:…
vdj TAB
- 31
- 7
0
votes
1 answer
Getting org.postgresql.util.PSQLException: Method org.postgresql.jdbc4.Jdbc4Connection.unwrap(Class) is not yet implemented
I have setup datasource in server.xml in tomcat like below
user3731509
- 11
- 3