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
0
votes
1 answer
Filter empty results in Pentaho Mondrian 3.2
I am using Pentaho Mondrian 3.2.
I want to count the number of days in a specific range having [Measures].[CNT] > 0. The following MDX query counts all days including null and empty results:
WITH
MEMBER [Measures].[numofday]
AS Count( Filter(…
0
votes
1 answer
Mondrian: Help picking the right aggregator for Measures?
There are some measurements I calculate that don't roll up in the same way as something like sales, or revenue. In sales if you wanted to calculate sales for the quarter you could sum all entries in the sales for each month falling in that quarter.…
chubbsondubs
- 37,646
- 24
- 106
- 138
-1
votes
1 answer
Can we integrate Pentaho and Google Visualization API or to flex?
I have developed one Mondrian schema and cube. I have deployed schema file in Pentaho BI server. I would like to know is it possible to connect these Pentaho schemas and UI technologies like Google Visualization API or Adobe Flex?
While searching…
Shekhar
- 11,438
- 36
- 130
- 186
-1
votes
1 answer
How to store data for mondrian queries?
I'm trying to understand how I should store data in order to query it with MDX queries processed by mondrian. I am having trouble storing data as i don't know if I should include redundancy in the data.
For example, I have facts for YEAR_2017 and…
apa
- 95
- 7
-1
votes
1 answer
Saiku 3 standalone with PostgreSQL - Mondrian Error on Select
I'm using the latest Saiku 3.8.3 standalone and I'm having some problems using the database PostgreSQL 9.1 with different schemas then PUBLIC.
I made the datasource and it connected correctly, here is the data source I'm using without personal…
Fizard
- 11
- 4
-1
votes
1 answer
Duplicates when filtering by group with Mondrian
I'm trying to create a Mondrian schema to be used in Saiku. The rest of the schema is working correctly, but the main filter isn't.
I have tried several ways on making this work, but so far I always get duplicates.
This issue can be duplicated with…
jmriego
- 335
- 3
- 15
-1
votes
1 answer
KendoPivot and Mondrian XML/A server
I would like to know if anyone has implemented KendoPivot accessing an instance of Mondrian as XML/A server. In theory this should work but I'm wondering if there are any compatibility issues.
ps0604
- 1,227
- 23
- 133
- 330
-1
votes
1 answer
Which cache system is better for mondrian SegmentCache
Which cache system is better for mondrian SegmentCache?
Memcached, Redis, Hazelcast or anything else?
Radik Ziyangirov
- 1
- 2
-1
votes
1 answer
Star schema imperative for using Mondrian?
I am seeing different implied answers to this question. Can a single 'flat' fact table be used simply referencing the different columns from the Mondrian schema?
Forward
- 9
- 2
-2
votes
1 answer
Exploring Apache Kylin cubes with Power BI?
I had some conflicts with my teammates about if it is really the Power BI can read and explore Apache Kylin Cubes or it is just exploring the Data source,
I had some problems with saiku exactly in the Mondrian schema that's why I am using Power BI,…
Khalil Mejdi
- 132
- 1
- 8
-2
votes
1 answer
Unable to convert mondrian 4 schema file to mondrain 3.x schema file
We have Mondrian 4 schema file (Cube file .xml) , which is created in Mondrian 4, but the Mondrian Schema workbench(It is a beta version) currently not available. Now we are using stable version of Mondrian Schema Workbench (3.6.1) so we want to…
Tushar Mali
- 7
- 1