SYMPTOM:
When running a subset report, from a Strategy Intelligence Server 9.x cluster node, where the Intelligent Cube is not published, the following error occurs:
The Intelligent Cube must be published before this report can be executed
Additionally, the following error message can be found in the DSSErrors.log of the installation:
Intelligent Cube (Intelligent Cube) for locale XXX is not published. The Intelligent Cube must be published before this report can be executed.
CAUSE:
A possible cause of this issue is that the folder that stores the Intelligent Cube files on the node where the Intelligent Cube is published is not shared with the name 'ClusterCube' on the Strategy Intelligence Server machine(s).
ACTION:
The default file location for Intelligent Cubes is defined in the Project Configuration as '.\Cube\ServerDefinition', where ServerDefinition is a name to reference the folder containing the caches. This folder needs to be shared as 'ClusterCube'.
It must be ensured that the Windows NT account used to run the Strategy Intelligence Server on every node has access to the shared folders.
For more information, refer to the following Strategy Knowledge Base technical note:
KB6022: MicroStrategy Intelligence Server Cluster Configuration Guide
