Analytics and SQL Query#

1. Change URL manually to "analytics" like https://<server>/analytics
2. Top Right > Click "Catalog"
3. Button "New" (second one, which looks like a chart) > Data Model
4. 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