MLOAP dimension capacity

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi all

I am using Analysis Service 2005 64 bit.

My dimension has 50 million rows now and will grow upto 300 millions
or more in future.

I set the storage type as ROLAP for dimension but the query runs very
slow.
So I change it to MOLAP and query runs fine

I want to know can MLOAP handle such big number of rows in dimensions?
What is maximum capacity of MOLAP Dimension to hold number of rows?
Is there some special method to handle large dimension?

Thanks

.

Relevant Pages

  • Re: Performance Benchmarks?
    ... adding memory on the server can help you; more data can be cached on the ... Here is my test query. ... )} DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ... I have created aggregations (Partitions tab in cube design). ...
    (microsoft.public.sqlserver.olap)
  • Re: SSAS: Processing Cube hangs
    ... Your LEFT JOIN query should not be that much faster than the query that ... syntax that is effectively be equivalent to using inner joins. ... The query optimizer in SQL Server knows how to work with both syntaxes ... Dimension User: about 200 records ...
    (microsoft.public.sqlserver.olap)
  • Re: VLDM Slow performance on Client PC
    ... from the server to the client. ... you can force the execution of the query on the server side rather the ... it creates another system process to hold the dimension in memory. ...
    (microsoft.public.sqlserver.olap)
  • Re: Analysis Server 2005 returns wrong results (from cache)
    ... have you setup a specific slice for these partitions? ... a query containing several restrictions and after that make a similar ... A Year dimension with one member '2007' ... Analysis Server returns this result if You run Query 2 as first query. ...
    (microsoft.public.sqlserver.olap)
  • Re: Analysis Server 2005 returns wrong results (from cache)
    ... have you setup a specific slice for these partitions? ... a query containing several restrictions and after that make a similar query ... A Year dimension with one member '2007' ... Analysis Server returns this result if You run Query 2 as first query. ...
    (microsoft.public.sqlserver.olap)