HPCA (Usage Manager) provides several scripts and materialized views that can be applied to the Microsoft SQL Server and Oracle databases to enhance the reporting performance.
The scripts and views are available at:
Media\Usage\Optional Features\SQL Server
for Microsoft SQL Server databaseMedia\Usage\Optional Features\Oracle
for Oracle database