Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Future consideration
Workspace Jedox Platform
Categories Other
Created by Guest
Created on Jul 2, 2019

Inverse rule like in SAC

in SAC there is the possibility to create such a rule: [Marketing Cost] = [Revenue] * [Marketing Cost % of Revenue] | INVERSE ( [Marketing Cost % of Revenue] := [Marketing Cost] / [Revenue] ) it allows you making Marketing Cost % of Revenue and Marketing Cost as well as an input (and "holding" Revenue constant) this in jedox is now only possible using SupervisionServer. This would be really helpful if this could be a standard feature
  • ADMIN RESPONSE
    Dec 11, 2020

    Hi. This is a good idea. We have thought about this idea internally. While we cannot commit to a specific target version, we will consider adding it to our future internal backlog. If you can add further information about the context of this feature, please add it here so we can evaluate it more fully. Can you please give some more context and examples ?

  • Guest
    Reply
    |
    Nov 19, 2020

    BOARD also includes such a feature. it's becoming a state-of-the-art feature. Would be really helpful since it would avoid using SVS!

  • Guest
    Reply
    |
    Jul 2, 2019
    You may want to use IF() and STET() combination in Jedox for this feature.
  • Guest
    Reply
    |
    Jul 2, 2019
    no can do, since a measure cannot be defined as rule-based and input at the same time as stated the only possibility is to use svs and asynchronous calculation, by saying : "if input is marketing cost % of revenue then calculate marketing cost" or "if input is marketing cost then calculate marketing cost % of revenue" imha this cannot be achieved using if and stet()