Re: Error executing MDX query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

The cubes this error occurs for are 1.08 MB and 13.2 MB. They each use three
dimensions. The *CustDim can have variable number of members and, I suspect,
is the largest. The other 2 are 1680 and 2 members each.

"Darren Gosbell" <jam@xxxxxxxxxxxxxxxxx> wrote in message
news:MPG.1e8b1a4d95762af69898c7@xxxxxxxxxxxxxxxxxxxxx
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: Hiding Dimension Members
    ... See the respective discussion in the SSAS Performance Guide, ... >> If for *all* users, then you can hide complete cubes, dimensions, ... >> a ragged hierarchy -- by hiding some members. ...
    (microsoft.public.sqlserver.olap)
  • Re: Analysis Manager Operations extremely slow
    ... > cubes each with about 9 regular dimensions, ... > I checked the mdb repository size to be close to 10MB. ... I migrated the repository to a local SQL Server instance ...
    (microsoft.public.sqlserver.olap)
  • Re: Processing of complex AS 2005 DBs - only reliable from BI Dev
    ... Could you run SQL Profiler and make sure that this is happening? ... You would see at the beginning statements to process all dimensions. ... is there anything special to cubes that fail? ... SQL Server Management studio. ...
    (microsoft.public.sqlserver.olap)
  • Re: Processing of Cubes/Dimension hangs
    ... Yes if a OLAP db has 5 cubes and 20 odd dimensions then ... and then hangs? ...
    (microsoft.public.sqlserver.olap)
  • Re: Is Excel a reasonable platform for this?
    ... I'm thinking that a server ... > You can create different cubes for different purposes. ... You can simply add new elements to your dimensions and just ... >>done is written an application which uses automation to open each model, ...
    (microsoft.public.excel.misc)