Monday, March 12, 2012

Newbie help needed with MDX expression

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