Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

Add calculated member per instance

Martijn asked on September 26, 2018

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].[2018] and have this available in the widget selection.

1 answer

Dmytro Zvazhii Flexmonster September 26, 2018

Hello Martijn,
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.

Please login or Register to Submit Answer