This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 52%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
I have built an Analysis Services Multidimensional project using Microsoft Visual Studio Professional 2022 with the SQL Server Analysis Services 16.0 extension connected to Analysis Services on a remote SQL Server 2019 instance.
The Visual Studio project is able to read the Data Source with an OracleClient Data Provider and load data, but
In other words, Analysis Services 2019 is able to read data from the data source in the views, but not while performing a multidimensional analysis.
It’s important to note that a similar project connected to a SQL Server 2005 Analysis Services instance is perfectly able to read data and process a multidimensional analysis.
May anyone help me to understand why Analysis Services is able to read data in the views and not while processing a multidimensional analysis?
Thanks
It looks like a different identity is being used interactively to test the views, and then programmatically during processing.
Yes, it seems. Thanks for your answer.
Also when using SQL Server Management Studio cubes don't work. The identity should be the one I used to connect to Studio
Why the same architecture works in SQL Server 2005 Analysis Services, where both views and cubes load data ?
It looks like something is working differently in Analysis Services 2019 connections.
Thanks