OLAP Manager
This topic provides troubleshooting steps for OLAP Manager issues.
What I can do to improve my cubes that are running slow?
Within the nec-centralpoint.xml, the parameter EnableOlapSliceLoadParallellism is available to help improve the performance of the cubes.
By setting this parameter to True, it can help in the following use cases:
-
When the database server is powerful.
-
When the Columnstore Indexes flags are configured within the Environment & Datasources screen and the Cube Details popup in the OLAP Manager.
When parameter EnableOlapSliceLoadParallellism is enabled:
-
It will build and load the slices of the cubes in parallel.
-
The SQL feature 'with(TABLOCK)' is used to insert data in parallel, when the Columnstore index feature is also enabled.