nVision processes slowly in 3 tier but not in 2 tier
We have just upgraded from HCM 9.0 to HCM9.2 PeopleTools 8.54.25.
Since the upgrade, when running nVision reports (MS Office 2013) in 3 tier some run as long as 25 hours but in 2 tier they run in 30 minutes.
We have also run the queries that are used to run the one particular nVision and they run within 4.5 minutes.
Any suggestions?