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

Mondrian drill through table in oracle shows integer values with comma

I have a problem using mondrian and JPivot The problem is that when I connect my application with an Oracle database, and access to the drill through table, all the values are shown with the format 2.010,00 that refers to the year 2010. This problem…
sebasto
  • 1
  • 1
0
votes
1 answer

Design OLAP cube and MDX query for my needs

I have an OLAP cube with a time dimension [year > month > day month > hour]. Now I need to create some reports very fast such as report for all sales of yesterday (like: 07:00 AM - 265 sales), all sales for last month (like: 1st February 2013 -…
Eli_Rozen
  • 1,301
  • 4
  • 20
  • 31
0
votes
1 answer

Mondrian doing sub-select on group by oracle

When I do this dimension:                
Michel Miola
  • 3
  • 2
  • 5
0
votes
2 answers

Mondrian olap - DriverManager.getConnection error

In my gwt web-app i'm using Mondrian. I have a method: private Result executeMdxQuery(String queryString, Schema schema) throws InterruptedException { CatalogLocatorImpl locator = new CatalogLocatorImpl(); Connection mdxConnection =…
Vadym Kovalenko
  • 699
  • 1
  • 11
  • 27
0
votes
1 answer

How to bring the XML from Pentaho report

After I look around the Pentaho application/plugin. There're many applications/plugins that related to Pentaho report. Does anyone know that if I want to have the XML that be able to link the Pentaho report(even my database to build the report),…
Supajak Thamwongsa
  • 19
  • 4
0
votes
1 answer

How can i write a dimension with snow flake schema ? . Details below

There are three tables - 1) Student - My fact Table (References Addresses with FK ADDRESS_ID 2) Addresses - This table Contains FK COUNTRY_ID references COUNTRY 3) Country - this has a NAME COLUMN which i would display. (PK IDENTIFIER) I have…
Rajeev A N
  • 105
  • 3
  • 9
0
votes
1 answer

Select one hierarchy on a dimension with multiple hierarchies

I do have a cube V that has a measure Q and some dimensions D, F. In the dimension D I wanna have 2 hierarchies that share some common members, here they are (the 2 hierarchies are A and T and the common members are M and I): -D -A +A …
rano
  • 5,616
  • 4
  • 40
  • 66
0
votes
2 answers

Pentaho Mondrian - Olap drilldown in java program

I'm using Mondrian 3.4 as the Olap Server to my application written in Java. Currently i wanted to perform some typical Olap operations in a cube, but i could't find any pointers that guided me to how to perform a drilldown operation in a cube with…
Paulo Rodrigues
  • 593
  • 14
  • 32
0
votes
3 answers

Is there any native client for Mondrian?

Now I'm start to study Pentaho and still working on Mondrian right now I confusing that does it have a native client for Mondrian? How do I start? Is there any document, tool or source that I should to understand Thanks for every answer.
Supajak Thamwongsa
  • 19
  • 4
0
votes
1 answer

mdx query - merging two queries to one

I'm using Mondrian and I have this query (Let's call it [query A]): SELECT NON EMPTY {Hierarchize({[Games].[**Some Game Name**]})} ON COLUMNS, NON EMPTY {Hierarchize({[Users].[User Name].Members})} ON ROWS FROM [Games_G] Which returns me a list of…
Eli_Rozen
  • 1,301
  • 4
  • 20
  • 31
0
votes
1 answer

Running MDX query on Mondrian Cube in PHP using olap4php

I am using olap4php to connect to the Mondrian's default FoodMart XML schema and I need to run an MDX query on it to see whether I can get it to work. My current code is as below :- require_once( 'olap4php/autoload.php' ); use…
ilight
  • 1,622
  • 2
  • 22
  • 44
0
votes
1 answer

MDX object not found in cube

I have districts with areas. and i'm trying to fetch data from my cube. the problem is: i add new area to district in database. the data in cube is recalculated only once a day. so rigth after i have added new area it will be not present in my…
user1178399
  • 1,028
  • 8
  • 17
  • 32
0
votes
2 answers

MDX Calculated Members not recognised

I am using Mondrian. When I use following query : with MEMBER [Added_On].[2011].[4].[tot] AS '[Added_On].[2011].[4].[4]+[Added_On].[2011].[4].[5]' select {[Added_On].[2011].[4].[tot] } on columns, {([Measures].[Count])} on rows from…
User756
  • 13
  • 7
0
votes
1 answer

Get the root level of dimension in Mdx using olap4j Api

I have a problem that's really killing me. BTW I am new to Mdx and using olap4j Api to construct MDX Query. My problem is with the root element, Following is the code snippet: Query myQuery = new Query("Generated Query", sales); // where sales…
Patton
  • 2,002
  • 3
  • 25
  • 36
0
votes
1 answer

Perforce Connection Failing for Mondrian Source Code Repository

I am attempting to follow http://mondrian.pentaho.com/documentation/developers_guide.php in the download and compilation of the Mondrian source code. I have installed the P4V client from www.perforce.com/downloads/complete_list on a fresh install of…
Mazrick
  • 1,149
  • 8
  • 10
1 2 3
…
31
32