For the following mdx statement -
select {[xx].[xx]} on 0,
Non Empty({[Date].[Calendar-Y-Q-M-D].[Day].&[7]&[2]&[2010]:[Date].[Calendar-Y-Q-M-D].[Day].&[9]&[2]&[2010]}*
{[xx].[xx].&[**/DOWNLOAD/D/0/D/D0D2D81B-0D7C-400C-BEAD-6CC67B48EB72/WINDOWSAZURESDK-X86.MSI**]}*
{[yy].[yy].[yy]}) on 1
from [xx Cube]
If I use #1 connection string, it will be failed.
1. <add key="ConnectionString" value="Provider=MSOLAP.4;Persist Security Info=False;Data Source=xx;Initial Catalog=xx;Integrated Security=SSPI;Compression Level=0;Transport Compression=None;"/>
2. <add key="ConnectionString" value="Provider=MSOLAP.4;Persist Security Info=False;Data Source=xx;Initial Catalog=xx;Integrated Security=SSPI;Compression Level=0;Transport Compression=None;"/>
The errror message is as follows :
System.Data.OleDb.OleDbException: 'MSOLAP.4' failed with no error message available, result code: E_FAIL(0x80004005).
at System.Data.OleDb.OleDbDataReader.ProcessResults(OleDbHResult hr)
at System.Data.OleDb.OleDbDataReader.NextResult()
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.OleDb.OleDbCommand.ExecuteReader()
at Microsoft.AnalyticsPortal.DataIntegration.Impl.ProductDownloadTask.Run()
select ...
What makes me suprised, if I change the following part of the above mdx statement it will be successful. => /DOWNLOAD/D/0/D/D0D2D81B-0D7C-400C-BEAD-6CC67B48EB72/WINDOWSAZURESDK-X86.MSI