Able to make a SQL Server Analysis Service (SSAS) in Spotlight successfully, but the overview window shows various yellow triangle exclamation marks (!) which gives no data.
To test if the classes are present on the SSAS box, try the following:
1. Open the run command and type: webemtest.
2. Click connect (root user is pre-filled). Click the "enum classes" button.
3. Choose the Recursive radio option and click OK to search for all classes.
4. The needed OLAP classes should be listed. If not listed, then that would cause the issue.
Required to patch or reinstall SSAS on the server.