Question

Views

  • 23 October 2017
  • 1 reply
  • 57 views

can one view pull columns from a derived table and a real table?


1 reply

Userlevel 2

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