SAC validation rules

[michele_medaglia5]

Hi SAC Friends

I implemented the validation rules and SAC doesn't allow me to plan on incorrect combinations and that is fine, I am happy with that.

I have one question: is there a way to avoid showing in the report the combinations unplannable?

At the moment the report shows me all the combinations as you can see in the screenshot

thanks

Michele

[N1kh1l · Accepted solution]

The validation rules only get triggered during data save and prevent any data writing on unwanted combination. It will not prevent the combination to be displayed in stories. There is a request raised in the idea place to enable feature to expand story tables based on attribute values of dimension so that only valid combination in attributes can be shown.

There is a workaround where you use data action to write a value 1 on valid data combination on a particular version and then in tables bring this version and other version required for planning. Finally uncheck show unbooked. This will ensure that only valid combination are shown in table.

Please upvote/accept if this helps you.

Regards

Nikhil

[TahaKocyigit · Accepted solution]

Hi Nikhil,

If I need to use more than one costcenter for an account, how can I match this?