Process the Viewpoint OLAP Database
BI dashboard reports rely on the Viewpoint OLAP database.
OLAP information is static; the system processes the Viewpoint OLAP database in specified intervals. Processing can be resource-intensive, so it typically occurs during off-hours.
You may want to do this when you add new users to the system or update security for the BI dashboard reports. Refreshing the Viewpoint OLAP database takes a significant amount of time and system resources. Make sure that you pick a time that will cause minimal disruptions to your organization’s daily activities.
To process the Viewpoint OLAP database prior to the scheduled interval:
- Open VA Business Intelligence.
Click the Process and
The system automatically processes and refreshes the Viewpoint OLAP database. If you have established datatype security (VA Data Security Access), the system applies the security to the SSAS Database during processing.