can one view pull columns from a derived table and a real table?
Hi Sebastian,
Thanks for reaching out. The good news is yes, you can ‘pull’ columns from an existing view or PDT.
To achieve this while writing either a dimension or a measure you can reference view_name.field_name
as per this discourse
If you want to reference an entire view you can use include: view_name
in the model file.
Alternatively you can use the extends parameter to extend a view.
This discourse explains how this process works and what prior knowledge you will need for this process.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.