mondrian_开发者

Please suggest ways to start building Business Analytics solutions using existing mysql databases

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.[详细]

2023-04-07 04:13 分类：问答

How to calculate recent row average value using MDX?

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[详细]

2023-04-06 13:52 分类：问答

Display property of member in mdx query

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:[详细]

2023-04-01 17:27 分类：问答

Mondrian Olap drilldown algorithm

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[详细]

2023-03-31 19:37 分类：问答

MDX - Filter on measure value?

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[详细]

2023-03-28 05:28 分类：问答

How to get current row value in a WITH MEMBER calculation MDX?

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.[详细]

2023-03-26 20:35 分类：问答

How to get first level data members after apply filter in third level (Mondrian MDX)

I am having a dimension named PERIOD with three levels YEAR, QUARTER and MONTH. I have filtered out third level data as follows:[详细]

2023-03-24 17:46 分类：问答

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[详细]

2023-02-24 10:21 分类：问答

Pentaho Mondian : Mondrian Schema xml Vs Pentaho metadata domain xmi Vs CDA cda files

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[详细]

2023-02-23 03:08 分类：问答

How do I create a System DSN

I need to create a System DSN called Mondrian开发者_如何学PythonFoodMart that points to /MondrianFoodMart.mdb file. The instructions to do this are very[详细]

2023-02-13 12:01 分类：问答