Analytics Load Times

[Former Member]

I have extracted and created the analytics data using orgchart 2.1 staged, but when I log in with a manager or executive user and go to view the analytics or demographics in the details panel, the analytics take a very long time to load, sometimes it seems like it requires me to swap to a different org unit and back to the original before it loads. The analytics never load, and after a while, the Loading icon swaps to u201CNot Applicableu201D. I changed the logging level to 1 in the Settings.xml, and the error I get in the log file is this:

INFO Nakisa.SAP.Custom.OTFProcessor_CacheList.logCommand() : WhereClause {(OrgUnitId = u201850105367u2019})

INFO BAPI_SAP_OTFProcessor_CahceList.CacheDataSetGet() : Dataset not found in cache. Key : SAPOTFProcessorSessionKey ###2342abcd##

INFO Nakisa.SAP.Custom.OTFProcessor_CacheList.logCommand() : WhereClause {(OrgUnitId = u201850105367u2019})

WARNING Detail u2013 CurrentAgeLinkedDetails : FetchData : Could not fetch data for details

WARNING Details u2013 CurrentAgeTableDetails : Render : Failed because no data is available

I have checked the views in the database directly, and they are populated with data, so Iu2019m not sure what is causing these errors. Any ideas?

[lukemarson · Accepted solution]

Hi Luke,

Are all of those transactions near each other in time? What I'm wondering is whether the application is trying to read the analytics from SAP instead of your database. In the data elements in SAP you need to define whether they Live or Staged connection is being used. I'm not sure if there is a global parameter in the Admin Console that defines this, generally because I only configure using the XML files etc.

Luke

[Former Member · Accepted solution]

Those transactions were all within the same second. You were correct in that the AppResources had the analytics set to load from Live, as opposed to Staged. Just a little confused on how it could do that, since you canu2019t even select the Live option in the Admin console, but they do load now. A search and replace for u201CLiveu201D to u201CStagedu201D made everything work perfectly. Thanks.

[lukemarson · Accepted solution]

Hi Luke,

To be honest I'm not sure how to change it in the Admin Console, although I tend to do most of my config in the XML files anyway. If I find out I'll post it up.

Luke