I have a synthetic table in my dashboard that has 2 dimensions - CourseId and ClassId. Can I use AutoNumberHash128(Field1&Field2&) ASNew Fieldin my script to get rid of synthetic table and expect the dashboard to function correctly when a user filters the dashboard by CourseId and ClassId?
A synthetic key is linking two or more tables. You would need to create the new key field in all linked tables and if you need the originial key fields, only keep them in one of the tables, where all values are stored.
Maybe it's easier to help you if you describe your model a bit closer.
