Analytics and SQL Query#
- Change URL manually to "analytics" like https://<server>/analytics
- Top Right > Click "Catalog"
- Button "New" (second one, which looks like a chart) > Data Model
- Marked is "Data Sets", Click on button "Plus" > SQL Query
Name = any Data Source = ApplicationDB_HCM Type = Standard SQL SQL Query like: Select * from PER_PERSON_TYPES WHERE SYSTEM_PERSON_TYPE = 'EMP'5. Run > Data > View > set Row = 200 > Table View
