SAC Model defined threshold with bw live query models, how?

[attila_kiss]

Dear Community,

Is it possible to create Model defined Threshold that could be applied to multiple measures within that Model?

Optimized Story Experience + BW Live Query Model (Planning)

Many thanks!

Attila

SAP Analytics Cloud SAP Analytics Cloud for planning 

[vishalakshmi]

For example, Create Restricted Measure for Sales:

Open your SAC story and navigate to the model.
Select Sales and create a restricted measure where Sales > 10000.
Name this measure Sales Above Threshold.

Conditional Formatting in Story:

Use the Sales Above Threshold measure in your visualizations.
Apply conditional formatting to highlight these values, for instance:
Red for values above 10000.
Green for values below or equal to 10000.
Combining SAC Features with Custom Scripting

Use SAC Scripting Capabilities:

SAC scripting (Analytics Designer) can offer more advanced customization.
Write scripts to evaluate thresholds dynamically if your use case allows for scripting.

Dynamic Input Using Input Controls:

Allow users to set threshold values dynamically using input controls (if working with planning models or if some workaround is feasible).
Use these input values in your custom calculations or scripts to dynamically adjust thresholds.

Static thresholds are easier to implement with live models.

For dynamic thresholds, consider workarounds like using input controls and scripting.

Note: Be mindful of performance implications, especially when working with large datasets and complex calculations in live models.