I believe there are three layers to build up- 1) Presentation Layer/Data Visualization Layer 2) Constucting olap server(like mondrian) to access mysql database and produce results.
My data example: idvalue_a 11.0 22.0 33.0 44.0 which I want is id / value_a / recent_n_avg 11.00.33 22.01.00 33.02.00
I have a Mondrian/MDX query where I grab data within a date range, but I\'d like to return time as the value of its property in the result.My current query is like:
I didn\'t found but m开发者_运维百科ay 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 minimu
I want to write an MDX expression that uses a measure value in the WHERE statement. For example: suppose I want to show the income from sold products in stores in different cities, but I only want t
I would like to calculate a Measure based o开发者_如何学Pythonn the current row. Problem is I can\'t find a way to get the current row in a WITH MEMBER part.
I am having a dimension named PERIOD with three levels YEAR, QUARTER and MONTH. I have filtered out third level data as follows:
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
I have been exploring the Pentaho ecosystem. Please forgive any naive things in the question. There are a couple of things about these config files ( containing domains names and its mappings etc ) t
I need to create a System DSN called Mondrian开发者_如何学PythonFoodMart that points to /MondrianFoodMart.mdb file. The instructions to do this are very