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 web-app that will connect my 3 tables in a MySQL to a Mondrian web-app that allows MDX queries?
Any help appreciated.
This is a very good tutorial for beginners: Mondrian 4 get ready
http://mondrian.pentaho.com/documentation/“rel=“nofollow”
If you are a first time user, you can have a look at this site http://pentaho-en.phi-integration.com/mondrian/configuring-mondrian-sample/jpivot-pivot-table
I need to create a System DSN called MondrianFoodMart that points to /MondrianFoodMart.mdb file. The instructions to do this are very confusing. More specifically I am trying to do section 2.1 of ...
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 ...
I an using mondrian and I have this issue: using a query mdx I need to concatenate in each member name belonging to a certain level, its name and a the value of a certain level properties for that ...
I m new to mdx and have been trying to solve the following problem for about a day now. Any help would be appreciated: My Query: select {[Measures].[Kunden]} ON COLUMNS, NON EMPTY Hierarchize(Union({...
My datawarehouse table just contains a single date SQL column, but I want to be able to drill down using the usual year/quarter/month/day levels. I could manually create new column using Pentaho ...
Suppose I have a [Sales] cube which has a [Store] level and a store has a "type" property. Which query should I use for showing the sum of sales for all the stores of type "Supermarket"? (e.g. You ...
I m stuck on a MDX query, I m trying to retrieve the following results: [Time].[2009] [Time].[2010] [Time].[Months].Members [Measures].[Sales] [Measures].[Sales] ...
I am building a Mondrian Cube that shows information for a large range of dates. One of the measures for this cube is an average of a percentage value. Because some of the items in the cube should ...
