The performance for opening some Centrify reports on SQL Server 2014 is not good enough if its database compatibility level is 120.
For the same SQL query, SQL Server 2014 cardinality estimator (CE) uses different execution plans if the database compatibility level is 120.
Changing the database compatibility level to 110 using the following SQL statement will help alleviate this issue:
ALTER DATABASE <database name>
SET COMPATIBILITY_LEVEL = 110