I have the following MDX Expression:
Code Snippet
select{Measures.Members} on columns,
[AccountNumber].Members on rows
from
BudgetCube
This gives me a nice tabular output with both account numbers and measures in each row.
When I run the query in MDX sample application its work like a charm.
However when I run the query from SQL Server 2000 via a Linked Server like this:
Code Snippet
SELECT*
FROM
OPENQUERY
(
SERVER_OLAP,
'
select
{Measures.Members} on columns,
[AccountNumber].Members on rows
from
BudgetCube
'
)
I get the following error:
Server: Msg 7358, Level 16, State 1, Line 1
Could not execute query. The OLE DB provider 'MSOLAP' did not provide an appropriate interface to access the text, ntext, or image column '[MSOLAP].[AccountNumber].[AccountNumber].[MEMBER_CAPTION]'.
OLE DB error trace [Non-interface error: Could not get a storage interface for BLOB the column: ProviderName='MSOLAP' TableName='[MSOLAP]', ColumnName='[AccountNumber].[AccountNumber].[MEMBER_CAPTION]'].
How do I correct the error? I suspect I need to create a caption for AccountNumber?
I would like to remove the "All AccountNumber" row from the result, how can I do this in MDX?
I need to filter the results based on a Date Dimention, as a range how can I do this?
Thanks
1: was fixed via http://support.microsoft.com/kb/916287
No comments:
Post a Comment