Showing results for 
Search instead for 
Did you mean: 

Validation using a matrix table - SAC Analytics Story

0 Kudos


I have two dimensions that need to be combined following specific validation rules. Unfortunately, I can't use the validation option on the model.

Instead, I'm using a matrix table where I mark authorized combinations with "1" and unauthorized ones with "0". I'm not sure if this is the best practice, so if you have a better approach, please let me know.

However, with this method, I don't know how to prevent data insertion in the unauthorized combinations. How can I achieve that?


View Entire Topic
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Deb_

    I guess you can't really prevent enter data on invalid combination without using validation rule.  You can only 'suggest' in this case. 

Best regards, William