Hi there! Good morning, evening, or afternoon - depending on where you are :) Hope you are well today! The error you're encountering while building the OLAP Cube on SharePoint Subscription Edition Central Admin indicates that the required Analysis Management Objects (AMO) client library is either missing or not properly installed. Here's how you can resolve this issue: 1. Install the Correct AMO Version
Download and install the Analysis Management Objects (AMO) client library.
The latest versions of AMO are available as NuGet packages. You can find them here.
Ensure that you install the version compatible with your SQL Server Analysis Services (SSAS) instance. For Version 15.0.0.0, you may need to install the AMO library for SQL Server 2019 or later.
2. Verify Dependencies
The error suggests that some dependencies for the AMO library might be missing. Ensure that the following components are installed:
Microsoft OLE DB Provider for Analysis Services
SQL Server Management Studio (SSMS) (latest version)
Microsoft .NET Framework (ensure the required version is installed).
3. Update SharePoint and SQL Server Components
Ensure that your SharePoint Subscription Edition and SQL Server Analysis Services are updated to the latest cumulative updates or service packs.
4. Check File Paths and Permissions
Verify that the Microsoft.AnalysisServices.dll file is located in the expected directory.
Common path: C:\Program Files (x86)\Microsoft SQL Server\150\SDK\Assemblies.
Ensure that the account running the OLAP Cube build process has sufficient permissions to access this file.
5. Test in a Sandbox Environment
Before applying changes to your production environment, test the setup in a sandbox environment to ensure the issue is resolved.
Hope this helps !
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
4
Share
Report
All responses (
Answers (
