View Complete Post
How to set Cach refersh option for a SSRS report that using SSAS cube to bind data
when i tried to store credential in data source getting error as show below
"Non-Windows user credentials were supplied for a non-http connection to Analysis Services. The Microsoft SQL Server Analysis Services data extension requires Windows Integrated Security unless connecting via
http or https."
I have a cube deployed on an SSAS Server. Is there any way I can modify the cube's MDX online (without taking it offline) via a C# App?
Appreciate your soon reply!
Is it possible to migrate a cube from SSAS 2008 to SSAS 2005?
We have created an offline cube on a network drive from SSAS 2008 and users are able to successfully access this serially using the Excel 2003 cube add-in or Excel 2007, in concert with version 10 driver, but when a user is already connected, the second
attempt to connect will get the message :
Connection to <filename> server, <dbname> database, <cubename> cube failed. OLAP Server error: The following system error occurred: The process cannot access the file because it is being used by another process. ., File system
error: An error occurred while opening the '<filename>' local cube file.
This is regardless of whether users connect specifying read-only and we have found it impossible to connect to a cube if the file has the read-only attribute set.
Is there any way to solve this without users taking copies onto their workstations?