Re: Error executing MDX query

No the same bug does not exist in AS 2000. Sorry about that I should
have read to the end of the post. I saw the "error on prepare" from a
linked server and the error I had seen on AS 2005 came to mind.

What are the sizes of the two dimensions that you are crossjoining? It
looks like your query must be returning a resultset with a lot of rows.

I am pretty sure that you only get "Unable to Allocate Memory For
FlexGrid" when an enormous resultset comes back which exceeds the limits
of the grid control in the MDX sample. This means you might have in
excess of 64,000 rows.

Have you tried putting a NON EMPTY clause in front of your rows

eg.


With Member Measures.PeerGroup As
'LowNall2CustDim.currentmember.parent.parent.uniquename'
select { Measures.[PeerGroup], Measures.[baseamt], Measures.[Count]} on
columns,
NON EMPTY {crossjoin(LowNall2CustDim.[Id].members, [RecvPay].
[RecvPay].members)}
Dimension PROPERTIES [Id].Name,
[RecvPay].[recvpay].Name on rows
from LowNall2 where ([bookdate].&[2006].&[1].&[3])



--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <#M6M1gCTGHA.2156@xxxxxxxxxxxxxxxxxxxx>,
bzakharin@xxxxxxxxxxxxxxxxxxx says...
I am actualy using AS 2000 (8.4.194). Is the bug present in this version as
well? If so, what would be a workaround?

"Darren Gosbell" <jam@xxxxxxxxxxxxxxxxx> wrote in message
news:MPG.1e86a0f0a6a1e1719898c5@xxxxxxxxxxxxxxxxxxxxx
Unfortunately I think you have hit a bug in AS 2005. I have details of
it on my blog here
http://geekswithblogs.net/darrengosbell/archive/2006/01/14/65848.aspx

From what I understand this is meant to have been fixed in SP1, but I
have no idea when this is due. I would guess that it would still be at
least a few months away.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <#H0UByUSGHA.4452@xxxxxxxxxxxxxxxxxxxx>,
bzakharin@xxxxxxxxxxxxxxxxxxx says...
I am trying to execute a query against Analysis Services from within
Query
Analyzer (at this point). Here is the query:
With Member Measures.PeerGroup As
'LowNall2CustDim.currentmember.parent.parent.uniquename'
select { Measures.[PeerGroup], Measures.[baseamt], Measures.[Count]} on
columns,
{crossjoin(LowNall2CustDim.[Id].members, [RecvPay].[RecvPay].members)}
Dimension PROPERTIES [Id].Name,
[RecvPay].[recvpay].Name on rows
from LowNall2 where ([bookdate].&[2006].&[1].&[3])

I get the following error:
Server: Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing a query for execution against OLE DB
provider 'MSOLAP'.
[OLE/DB provider returned message: The operation requested failed due to
timeout]
OLE DB error trace [OLE/DB Provider 'MSOLAP' ICommandPrepare::Prepare
returned 0x80040e14].

When trying to execute this query from the MDX application I get the
following:
Unable to display opened cellset
Unable to Allocate Memory For FlexGrid

This only happens for a few cubes. Other virtually identical cubes
return
data just fine.

.

Relevant Pages

  • Re: Error executing MDX query
    ... Blog: http://www.geekswithblogs.net/darrengosbell ... An error occurred while preparing a query for execution against OLE DB ... Other virtually identical cubes return ...
    (microsoft.public.sqlserver.olap)
  • Re: Error executing MDX query
    ... Blog: http://www.geekswithblogs.net/darrengosbell ... An error occurred while preparing a query for execution against OLE DB ... Other virtually identical cubes ...
    (microsoft.public.sqlserver.olap)
  • RE: MDX Named Set and OPENQUERY
    ... I also agree with the suggestions at the end of your blog. ... Is restructuring the query to move the set definition inline in the ... string, [SelectedStores], was parsed.". ... I proceeded to copy the query from the above error message into an MDX ...
    (microsoft.public.sqlserver.olap)
  • Re: hiding contacts (ojbect) from directory search (LDAP)
    ... what you are saying is that a group of people are able to query ... # Jorge de Almeida Pinto # MVP Windows Server - Directory Services ... BLOG --> http://blogs.dirteam.com/blogs/jorge/default.aspx ... * This posting is provided "AS IS" with no warranties and confers no rights! ...
    (microsoft.public.windows.server.active_directory)
  • Re: Forcing Global Catalog Replication
    ... # Jorge de Almeida Pinto # MVP Windows Server - Directory Services ... BLOG --> http://blogs.dirteam.com/blogs/jorge/default.aspx ... the results of the query to change. ...
    (microsoft.public.windows.server.active_directory)