Stack Overflow
Stack Overflow

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

Mondrian: Cannot seem to get Aggregation Tables to be used

I have been struggling to get aggregation tables to work. Here is what my fact table looks like: employment_date_id dimension1_id dimension2_id dimension3_id dimension4 dimension5 measure1 measure2 measure3 I'm collapsing the employment_date_id…
chubbsondubs
  • 37,646
  • 24
  • 106
  • 138
14
votes
1 answer

What is difference between Numeric and Integer types, and how I can use timestamp level type in Mondrian?

While reading manual of Mondrian I found that it has not so much types including Integer and Numeric - what's difference between this types? And how can I use timestamp level type?
champion
  • 339
  • 1
  • 2
  • 12
13
votes
1 answer

R clients to OLAP MDX servers

Has anyone tried to access an OLAP server offering a XMLA API (such as Mondrian) from R? I'd love to run MDX queries from R against Mondrian and retrieve result sets.
Xavier Guardiola
  • 2,699
  • 3
  • 19
  • 11
12
votes
2 answers

Why use ROLAP instead of plain MySQL?

Are there any performance advantages in using a ROLAP server such as Mondrian on top of a MySQL database, as opposed to simply querying the MySQL database? I am asking this in the context in which most of my queries will be relatively simple (such…
Epicurus
  • 2,103
  • 7
  • 29
  • 39
11
votes
2 answers

OLAP - Calculate run-off triangles, sample data and cube included (PostgreSQL/Mondrian)

Reality description: We do have a list of projects. In every project there is a lot of accounts. You can do a lot of actions on every account. I do have the following dimensions and fact table defined (simplified): Dimensions and attributes: …
Tomas Greif
  • 21,685
  • 23
  • 106
  • 155
10
votes
5 answers

Where can I find Mondrian tutorial?

I am having trouble finding how to create a simple web-app to analyse its data on OLAP cubes with Mondrian. I have a small database that consists only of one fact table and 2 dimension tables. Is there a tutorial or a reference on how to build a…
Flethuseo
  • 5,969
  • 11
  • 47
  • 71
10
votes
1 answer

Is there a (open-source) MDX-based in-memory OLAP server?

I was wondering if there is a in-memory OLAP server which can handle MDX. I found the Wikipedia article. But it says nothing about in-memory functionality... The only one I know of them is Mondrian, which is also one of the two open-source solutions…
DennisH
  • 383
  • 3
  • 11
7
votes
3 answers

MDX date range query with a missing boundry date

I need an MDX query for Mondrian filtered by date, where one or both of the boundry dates may not exist. I'm using the query below that works as long as both 2013-01-01 and 2013-01-08 dimensions exist. If one of the two dates does not exist then…
Dynamite
  • 93
  • 4
7
votes
1 answer

Connecting to Database Cube that uses MySQL database from PHP (using JDBC)

My database team has set up a database Cube using MySQL database. I need to connect to this Cube from PHP and get the data using MDX queries. I can't find how to do that. Could someone please help me with this ASAP? Reference document :- Creating…
ilight
  • 1,622
  • 2
  • 22
  • 44
6
votes
4 answers

Are Mondrian / OLAP the wrong tool for joining large dimensions/sets?

Summary: Most of the examples I've seen of MDX joins have involved joining relatively small sets, say with tens or hundreds of items each. But I find myself also wanting to try joining (in particular "non-empty joining") sets that have thousands or…
Chris
  • 9,986
  • 8
  • 48
  • 56
6
votes
4 answers

Which pentaho mondrian library to include in a Java application to have mapping MDX to SQL

I want to implement an application that provides support for MDX queries. For this purpose I would like to use one of libraries from pentaho mondrian (an open source OLTP server with the MDX interface) that transforms MDX queries into SQL of…
Skarab
  • 6,981
  • 13
  • 48
  • 86
5
votes
1 answer

Mondrian: calculating filter totals

I have this MDX query: with member [Measures].[count] as '[Measures].[NUMBER]' ** member [Measures].[total] as 'sum({[RECORD_TYPE.VALUES].[All VALUEs].children})' ** member [Measures].[% records] as '([Measures].[count] /…
Rafael Segovia
  • 247
  • 3
  • 11
5
votes
1 answer

Debugging BI Stack : MySQL + Mondrian + Saiku server

I'm trying to learn how to build a BI stack, but I'm stuck at understanding what part of the process failed : Designing a star schema : done Loading data from my OLTP database (MySQL) to my star database (MySQL too) : done with Pentaho Data…
AsTeR
  • 7,247
  • 14
  • 60
  • 99
5
votes
5 answers

Can a Mondrian Cube be Browsed By Microsoft Excel?

Is it possible to browse a Mondrian Cube through Microsoft Excel? like it is done with Microsoft SSAS? If not is there a possibility to use Sharepoint as a front end to browse a Mondrian cube?
picmate 涅
  • 3,951
  • 5
  • 43
  • 52
4
votes
1 answer

Mondrian Can't find Schema in VFS when used in a Webapp

I have a webapp that I'm trying to use Mondrian within. And I'm getting the following exception when I try to open a connection: Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Virtual file is not readable:…
chubbsondubs
  • 37,646
  • 24
  • 106
  • 138
1
2 3
…
31 32