tags:

views:

100

answers:

0

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