SYMPTOM:
When running an Intelligent Cube report from a Strategy Intelligence Server 9.x - 10.x clustered environment, the following error occurs in one of the nodes:
"The Intelligent Cube must be published before this report can be executed"
This occurs even though the cube was successfully created and published on another node in the cluster.
CAUSE:A possible cause of this issue is that the server definition used by the cluster nodes are different and the corresponding folder that stores the Intelligent Cube files is set differently between the definitions.
Refer to the following Strategy Knowledge Base technical note for another possible cause:
KB31536: "The Intelligent Cube must be published before this report can be executed" error occurs when running subset reports on a MicroStrategy Intelligence Server 9.x clustered environment"ACTION:Ensure that all nodes of the cluster either use the same server definition or have properly set the same folder location for the Intelligent Cube files:
