Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-26 : 08:52:52
|
| Mahabub writes "I'm trying to execute MDX query on SQL Query Analyzer but there is an error like..select * from Openquery(FOOD,'select {[Measures].[Unit Sales]} on columns, order(except([Promotion Media].[Media Type].members,{[Promotion Media].[Media Type].[No Media]}),[Measures].[Unit Sales],DESC) on rowsfrom Sales')Error: Server: Msg 7358, Level 16, State 1, Line 1Could not execute query. The OLE DB provider 'MSOLAP' did not provide an appropriate interface to access the text, ntext, or image column '[MSOLAP].[Promotion Media].[Media Type].[MEMBER_CAPTION]'.OLE DB error trace [Non-interface error: Could not get a storage interface for BLOB the column: ProviderName='MSOLAP' TableName='[MSOLAP]', ColumnName='[Promotion Media].[Media Type].[MEMBER_CAPTION]'].Would someone please tell me how can i resolve that." |
|
|
|
|
|
Olap Service Access through SQL Query Analyzer