Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Shipped
Workspace Jedox Platform
Created by Guest
Created on Jul 2, 2019

Check calculation period of Subset Data.Filter

Problem: When an user executes an Excel-Subset with a Data.Filter and this Data.Filter has unsufficient restrictions on every dimension, then the subset calculation will need a high amount of Server resources and the olap service is likely to crash. Reason: User don't realise, how much resources the calculation might take or User are fast inserting a subset without checking the restrictions of the data.filter. Solution: Before executing a Subset with a Data.Filter check the estimated amount of resources for the calculation. If the amount is to high: display a warning for the user. If he clicks "yes" then the calculation will proceed. If "no", then the Data.Filter will be not included into the subset and no calculation will happen.
  • ADMIN RESPONSE
    Jul 4, 2019

    to cover the described scenario, in Jedox release 2018.3, we have updated the Subset Editor in Jedox Web - DFilter will now by default restrict each dimension to the first root element, which should prevent users from unintentionally generating extremely large DFilter areas. Since Jedox 2019.2, Jedox Excel Add-In uses Subset Editor based on Jedox Web, and utilizes the same functionality.