Can I extend my view with another view, and have derived table at the same time?
Solved! Go to Solution.
That’s right. Derived table is a source table for your view and so is sql_table_name, hence it has to be one or the other.
If what you want to add can’t be built off the existing measures and dimensions (otherwise you could use a refinement) then it should be in your Data Model (aka. change the view itself)