If you ever have a requirement in which you need to create an Analysis but do not find the right Subject Area for it, then you can use the "Create Direct Database Query" that OBIEE offers.
Or if you want to place the results of a BIP sql query on a Dashboard (by creating an Analysis).
Depending on your requirement, you may choose to use this option.
Lets look at the steps to do this:
1. Login to OBIEE (BI Tool)
2. Select New > Analysis > Create Direct Database Query
3. On the Criteria tab
a. Connection Pool = "HCM_OLTP"."Connection Pool" (add the quotes as well)
b. SQL Statement = SELECT Last_Name from PER_PERSON_NAMES_F
Note: For FSCM use "FSCM_OLTP"."Connection Pool"
4. Click the "Validate SQL and Retrieve Columns"
5. Select the Results tab
You should see the results that your query returned
6. Save the Analysis
Regards,
Brendon Charles
