Assume the scenario where I have an Employee table in universe. Now I have another table in the universe called Employee_Master.
Is it possible to restrict rows of Employee table based on Employee_Master ?
The problem is that if I include the Employee_Master table in the rule but the use selects only Employee table for his report, this rule will give a SQL error as Employee_Master is not included in the FROM of SQL query.
Any suggestions ?
Thanks
Binayak