📄️ dR Views
The Foundation of Your Model: Understanding dReveal Views
📄️ dR SQL View
dR SQL Views are a specialized type of dR View that empowers modelers to bypass the standard wizard interface and directly craft SQL syntax. This feature proves invaluable when traditional dR Views encounter limitations for specific operations, as it allows you to create Views from custom SQL statements.
📄️ Rearranging
As you create an increasing number of dR Views, maintaining an organized structure becomes essential. Proper organization can significantly enhance your workflow efficiency. You can achieve this by positioning your views in the correct sort order.
📄️ Relationships
Exploring dR View - Relationships
📄️ Conditions
Conditions in dReveal Views are a powerful tool for filtering data, enabling you to narrow down your dataset wherever data filtering is necessary. The flexibility of conditions allows you to apply them at any level within your model.
📄️ Distinct
In the dR View options, located in the right-bottom panel, you will come across a valuable feature called 'Distinct'
📄️ Group by and Aggregation Functions
In the dR View options, specifically in the right-bottom panel, you'll encounter the powerful 'Group by' feature.
📄️ Joins vs. Unions
By default, dReveal automatically establishes Join relationships between objects when you add more than one to a dReveal View. This functionality, referred to as 'dReveal Joins,' is enabled as the default setting.
📄️ Nesting and Reusability
We've already covered how to create a dR View and perform table joins within its scope. Now, you can begin to leverage the abstraction that a dR View offers.
📄️ Preview and SQL Query
Once you start developing and adding join conditions or reusing your dR Views, you can always preview or review the SQL statements generated for all your actions created.