Mondrian is an open source OLAP (online analytical processing) server, written in Java. It supports the MDX (multidimensional expressions) query language and the XML for Analysis and olap4j interface specifications. It reads from SQL and other data sources and aggregates data in a memory cache. It is owned and maintained by Pentaho
Questions tagged [mondrian]
476 questions
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
4
votes
3 answers
MDX query to get all dates where dateis greater than
For example i am need to take all dates where year is greater than 2013. This code return all dates.
SELECT
{[Measures].[In]} ON COLUMNS
,Filter
(
[Date].MEMBERS
,
[Date].[Year].CurrentMember > [Date].[2013]
) ON ROWS
FROM…

Nodon
- 967
- 11
- 24
4
votes
2 answers
Mondrian 4 documentation
I am about to start creating OLAP using Mondrian. Is there an official Mondrian 4 documentation? The documentation I found at mondrian.pentaho.com/documentation doesn't seem to cover the latest Mondrian version. I thought virtual cubes are replaced…

Luky
- 45
- 1
- 9
4
votes
2 answers
Merge 2 facts in cube?
Is it possible to merge 2 facts tables to create a cube in a Mondrian schema
example the case of sales and cost ?

Fierto
- 59
- 6
4
votes
2 answers
mondrian.xml schema files pentaho location
I'm creating cubes (xml schemas) via schema-workbench or ivy schema editor.
When I'm publishing it, I would like to know where the schemas (mondrian.xml files) are actually saved,What is the location of these files?
Thanks,

matlabit
- 838
- 2
- 13
- 31
4
votes
1 answer
Non-time level inside a time dimension
I have a time dimension defined something like the following:
…

user3113189
- 41
- 1
4
votes
2 answers
Cannot find a handle to Mondrian's CacheControl
I am using Mondrian as my server olap engine.
I have a scenario where some of my dimensions data is changing. When this happens I would like to clear mondrian cache.
I cannot understand how I can get a handle to Mondrian's cache control.
I have a…

yosi
- 639
- 1
- 12
- 21
3
votes
0 answers
How to create virtual cube in mondrian cube framework?
I have got two tables through which I need to generate a cube report, I need to displayy measures from columns of both the tables. I browsed through the documents on the website and learned that VirtualCube is the way to go if I am to accomplish…

Juzer Ali
- 4,109
- 3
- 35
- 62
3
votes
1 answer
Mondrian Olap drilldown algorithm
I didn't found but may be someone could me explain - OLAP cube is a combination of all possible aggregation, so related to Mondrian - leaf level is data in fact table or it is a minimum aggregate (cell) ?
Thanks.

user710818
- 23,228
- 58
- 149
- 207
3
votes
1 answer
How to add multiple fact tables in a single mondrian cube in pentaho?
Need to associate multiple fact tables with a mondrian cube. The schema workbench doesn't allow to do so. How can we achieve this?

Akira
- 47
- 6
3
votes
1 answer
Mondrian/Saiku - Closure Table - Null Pointer Exception
I am currently doing a PoC and facing a problem with closure table. I am using Saiku CE and database is postgres. Everything works until I add a closure table.
If I remove closure table hierarchy, I don't get any error. If keep it I get the error. I…

Puneet Tayal
- 31
- 1
3
votes
1 answer
How to use a PostgreSQL DB as XMLA datasource?
Basis:
PostgreSQL database with normal and reporting data
Downloaded the Mondrian zip from here
I have a client pivot grid component (DevExtreme Web)
As i understand it so far, i have to use a OLAP-server that functions as connector between MDX…

Spenhouet
- 6,556
- 12
- 51
- 76
3
votes
2 answers
Two Conditions Where MDX Query
i'm new in MDX world and i'm having some doubt in where clausule.
I have this query
WITH
SET [~ROWS] AS
{[Product].[All Products]}
SELECT
NON EMPTY {[Measures].[Quantity]} ON COLUMNS,
NON EMPTY [~ROWS] ON ROWS
FROM [SteelWheelsSales]
WHERE…

Caio Granero
- 31
- 1
- 2
3
votes
1 answer
Pentaho Mondrian MDX - removing parent titles
I am new to Pentaho, Mondrian & MDX. I started to use Pentaho CE 5.0.1 as my OLAP tool. I am struggling with a MDX query and hoping someone can give me some pointers on my issue.
I have the following time dimension mondrian schema:
`