search

mysticfall / pivot4j

Pivot4J provides a common API for OLAP servers which can be used to build an analytical service frontend with pivot style GUI.
Other
128 stars 99 forks source link

Expression language support in MDX query. #37

Closed mysticfall closed 11 years ago

mysticfall commented 11 years ago

Need to support expression language support in MDX query :

Requirements

  1. EL implementation should be pluggable.
  2. Snippets should be preserved during possible query transformation like drill down, sort, and more.
  3. EL is NOT allowed to change the structure of the query.
mysticfall commented 11 years ago

It should provide a flexible alternative to Mondrian specific Parameter/ParamRef pseudo functions.

mysticfall commented 11 years ago

Checked current level of support for Parameter/ParamRef functions in JPivot. It seems the statements are preserved when applying sorting on a measure but not when drilldown operations are performed unless they are on slicer axis.

mysticfall commented 11 years ago

Turns out JPivot fails to preserve parameter definitions on the slicer axis when a Place*OnAxis transform is performed.

For now, we should aim at providing EL support for members and literals and preserve them if they're on the slicer axis for all of builtin transformations which does not change the slicer itself.

mysticfall commented 11 years ago

As a result of the latest refactoring, MDX parameter only support value bindings for now.