Questions tagged [mondrian]

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

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:
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…
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: `