Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 11 Oracle Analytics Lounge
- 194 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.5K Oracle Analytics Forums
- 6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 68 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
OAC-Semantic Model -Cutom/ManualQuery
Hasan Sd
Rank 5 - Community Champion
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.
0
Best Answer
-
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.
1
