In an earlier post we investigated how to use command line utility to obtain analytical view recommendation for complex SQL statements such as unions.
In this post we want to show how we can use the UI to obtain the same recommendations. Instead of creating LV as part of the data setup, we can create a Dataset from SQL as shown below which contains the same UNION statement:
We can then start building our dashboard on top of this dataset. The system will start capturing the visual queries.
Then use “Smart Acceleration” to obtain analytical view recommendations:
Note how the same two analytical views as was recommended by the command line utility.