Restrict users from selecting Objects when creating WEB-I reports
My universe has 6 Dimension and 2 Fact tables.
The Fact tables are not joined to each other.
Each of the fact tables are joined to all the dimension tables and seperate contexts are created for each of the fact tables.
I would like to know if we can restrict or prevent the users from selecting data from both the fact tables in a single query in a Web-I report.
Ex. customer_name, product_name, country, F1.Quantity, F1.Amount, F2.cost, F2.percent
dimension objects --> customer_name, product_name, country
The user adds the following objects to the above query
Fact 1 measures --> Quantity, Amount
After adding the data from Fact-1 the user should be restricted or not allowed to select objects from class containing Fact-2 measures.
Is there a way the above can be implemented?
Thanks in advance for the quick reply