Re: Disadvantages in using cube partitions

From: anonymous red (anonymousrd_at_yahoo.co.uk)
Date: 10/25/04 

Date: Mon, 25 Oct 2004 06:31:15 -0700

 In fact I have a cube of size 100 MB with about 8 dimensions that
contains data for 24 months. There are only isolated reports that do not
use the whole 24 months data altogether. In fact, the time taken for the
processing of the cube or the complexity of development does not matter
much for my case: the main focus is access time on reports. What I would
like to know is that how I can have an idea of how much the majority of
my reports (which are based on the 24 months altogether) will suffer if
I start managing partitions in my cube based on the time dimension.
Basically, how significant is the overhead for a query consuming data
across all the members of a dimension when the cube bears N partitions
based on that dimension itself as compared to a single partition or to
how many number of partitions per MB of a cube does this overhead become
an issue.

 

I would be most grateful if you could provide me with some information
pertaining to the above issues.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: SSAS2005 - When do partitions need to be processed?
    ... InsertCubeProcessingLog("Process Dimension All End", 1, 1, BeginTime, Now, ... The actual processing of partitions doesn't appear to be significant here ... Processing Cube 'Sales Current' completed successfully. ... With AS2005 there is a proactive caching option at the dimension level, ...
    (microsoft.public.sqlserver.olap)
  • Re: SSAS2005 - When do partitions need to be processed?
    ... InsertCubeProcessingLog("Process Dimension All Begin", 1, 0, BeginTime, Now, ... The actual processing of partitions doesn't appear to be significant here ... Processing Cube 'Sales Current' completed successfully. ... With AS2005 there is a proactive caching option at the dimension level, ...
    (microsoft.public.sqlserver.olap)
  • Re: SSAS2005 - When do partitions need to be processed?
    ... My guess here is that it is not aggregations but rather indexes being ... The actual processing of partitions doesn't appear to be significant here ... Processing Cube 'Sales Current' completed successfully. ... aggregations when the dimension is updated. ...
    (microsoft.public.sqlserver.olap)
  • Re: long processing time
    ... currently it is processing 2 partitions in parallel. ... >1) Have you ran the Optimize Schema wizard in the Cube ... >the RDBMS (SQL Server or Oracle), ... >> The cube which took 9 days to process has time dimension ...
    (microsoft.public.sqlserver.olap)
  • Re:Overhead in Cube Partitioning
    ... processing of the cube or the complexity of development does not matter ... the main focus is access time on reports. ... I start managing partitions in my cube based on the time dimension. ...
    (microsoft.public.sqlserver.datawarehouse)
Loading