Hello, We are evaluating flexmonster for use in our application. Flexmonster in combination with pentaho mondrian.
Is it currently possible to include query scoped calculated members in a flexmonster result?
For example, we would like to create and select a member like below which is dynamic on the current date. But we rather not set it in the cube, as its specific to this instance of the widget, and we rather not have to reload the mondrian cube for performance reasons.
We would like to add something like: WITH MEMBER [Time].[Current Year] as [Time]. and have this available in the widget selection.
Thank you for writing.
Flexmonster Pivot does not support calculated members on the client side. The recommended approach here is to generate JSON reports dynamically. The report should include the necessary filter. For example to include only 2018 year.
Please let us know in case of any other question.