Hello everyone.
I'm trying to add Data Constraints to some physical tables, but without any success.
I have physical table PT_USER_ACCOUNT, business BT_USER_ACCOUNT related to PT_USER_ACCOUNT.
So, in metadata editor i'm trying to add simple constraint: double click on physical table, add Data Constraints -> Global Constraints,
Code:
CONTAINS([BT_USER_ACCOUNT.BC_USER_ACCOUNT__USER_NAME]; "root")
After publishing that metadata file to server, i'm trying to create new report, adding fields from USER_ACCOUNT table, but in report I see all entries from user account.
what i'm doing wrong?
Thanks.