Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can someone direct me to link/video/example that tell under what scenario is it beneficial to use Qualify?
There aren't many in a production situation. ironically I encountered one just today. It goes like this:
A data model needs to be secured with section access so that individual users can only see the sales transactions that they were responsible for. These transactions have many attributes like location, date, product etc... The section access makes sure that users can only see the possible products, locations etc... that were tied to their transactions...and in this way may only have the ability to toggle between 2 products even if the data model has 100+ products simply because of the section access.
Now the twist is that the dashboard should have global totals at the top. These totals are grand totals for all locations, products etc... and the users can actually filter those based on the dimension values they see. So if they sold 2 products, they can see what the TOTAL sales across all users are for those products.
One way to do this is to have a 2nd data model that is unattached to the first that has many of the same fields as the original data model, but it does not have a user or transaction field in it. The totals are calculated from the 2nd data model and filtered using SET MODIFIERS with values from the first model.
Because there are many like named fields in both the detailed+secured model vs the summary model and you don't want any joins, its easy to just use qualify * for the summary fields to ensure that none of them join .
Thats my example : )
Hiii,
The main use of Qualify Statement is to asscoiate field names of a table with table name:-
for exp:- We have a table Student and its fields are Name,RollNo etc.
And when we will qualify these field then field name will be like:-
Student.Name,Student.RollNo.
and suppose we want to map some table with other table then we unqualify the field in both tables to map b/w these two tables.
please find the attached example for detail:-