Dear freelancers,
I need assistance to guide me through an issue with our database. No remote access will be possible, you would have to guide me while I narrate the issue.
My cubes were working fine and were processed daily in SSMS until some Microsoft security updates were installed & the server was restarted. I receive the error message when processing the cubes and dimensions. I already deleted the security updates but I am still getting the same error.
In the windows services -> SQL Server Analysis i have a service account with all the rights in SQL server (read, write, process, admin). I am working on SQL Server 2014.
I tried to:
restart the SQL Server Analysis
set up new accounts with read,process and admin rights on the SQL server and analysis server.
to put in the "SQL Server Analysis" to put the Local account
Create a new cube but Dimension can still not be processed.
change the provider from "SQL Server Native Client 11.0" to "Microsoft OLE DB Provider for SQL server" and we also checked the "allow inprocess" checkbox in SSMS in Server Objects -> Linked Servers -> Providers.
Nothing worked of the points above. I hope someone can help us.
Error message:
OLE DB error: OLE DB or ODBC error: Incorrect syntax near the keyword 'JOIN'.; 42000. Errors in the OLAP storage engine: An error occurred while the dimension,
Hi,
I am an MSBI expert with proficiency in creating SSAS cubes and writing SQL queries. Let me know if you would like me to hire for this position so that I can show my skill to you.
I am expert in SQL and SSIS development with more than 10 years of experience. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. I only take projects which I am sure I can do quickly.