OAC-Semantic Model -Cutom/ManualQuery

Hasan Sd

Hii OCA Community…..In direct dataset creation there is option for Manual/custom query . But in Semantics model ,we couldn't find this option .Can anyone pls advise how to create tables using Manual/Custom query in Semantics Model .Thank you.

Gianni Ceresa

Hi,

You just change the source of your physical table from "Table" to "Select Statement", and then enter the query in the columns tab.

This is your database SQL language, not LSQL or things like that. You should also consider to create a view in your database directly, this would give you a better auditing and tracking instead of hiding business logic into the select statement behind a physical table in your model.