Rule Debugger/Impact Analysis Tool

It would be useful to have a rule debugging feature in the platform, rather than having to go to 'Browser.Live.{Client}.Jedox.com'.

The browser feature is useful to identify rules that are most impactful on performance, but having it only accessable on the browser is not easy for a majority of clients.

Ideally a few key items would be helpful in the short term:

• The ability to troubleshoot from the rule manager or see which rules are most impactful immediately

• Having a feature similar to the spreadsheet advisor to help identify potential/common performance issues

  • Flagging/tagging problem rules

  • Highlighting if there is a circular reference

  • Identifying if rule positioning is causing issues

  • Marking any rules that are not being 'fed' properly i.e. calculating on many unnecessary elements or that the rule is to broad

Long term it would be great if the tool could also:

• Identify/suggest better ways to optimize rules i.e. 'theres too many nested statments' or 'try using null instead of 0'

• Automatically determine/suggest rule position placement

• Have a testing feature, within rules that shows impact of edits before you turn it on/update rules templates

  • You have to create a new paste view and switch to the designer in order to troubleshoot and test rules

• Create a number of pre-defined rule templates to that are used most clients in order to minimize mistakes with writing their own (EBIT, CYNI, Gross Margin %, etc)