Subject Area is timingout when connected to in OAC

Question

Summary:

I have been trying to import the Workforce Profiles - Person Profile Real Time subject area into OAC, but it has been failing.

Content (required):

I want to show employees' last 3 years ratings in columns for a simple employees detail table along with current compensation info.

Bret Grinslade - Oracle Analytics-Oracle · Answer

The message is saying the query it taking too long.  If your report creates a query that is too slow from the source system - you can try creating separate charts or you can see if adding a filter such as per employee is sufficient.

For example, make a list of employees and then have a drill through or details chart with a filter set to a specific employee. Alternatively, reach out to the team that owns the subject area and ask them to help make your current query faster.

Steve F-2 · Answer

* Limits Querying Data (Data Visualization Projects, Classic Analyses and Dashboards)

Dir_Pal · Answer

How many Records do u have in this subject area?