Re: Cube and Dimension Processing

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

Hello Mahesh.
Answers below.

Remember. In all cases the dimension processing option has a direct
effect in the fact (cube) processing option.
I'm not considering the Proactive Cache option in the answers
(SSAS2k5).

What will be the best processing option under these four situations?

1.
Dimensions: addition of new members but no changes in existing members
Fact: new records but no changes in existing records.

Dimensions: Incremental
Fact: Incremental

2.
Dimension: addition of new members but no changes in existing members
Fact: new records as well as possibility of changes in existing
records.

Dimensions: Incremental
Fact: Refresh

3.
Dimension: addition of new members as well as changes in existing
members like moving under new parent.
Fact: new records but no changes in existing records.

Dimensions: Refresh
Fact: Refresh/Full

4.
Dimension: addition of new members as well as changes in existing
members like moving under new parent.
Fact: new records as well as possibility of changes in existing
records.

Dimensions: Full
Fact: Full

Will the processing option be different if the changes in existing
records are extremely rae vs very frequent changes? Any response will
be very much appreciated.

What is the volume of data to be processed?
How much time do you have to process it?

These questions will have more influence in your processing options.
Hope this help in some way.

.

Relevant Pages

  • Re: Cube and Dimension Processing
    ... make sure your dimension use the flexible relationship between your members if you anticipate some changes between these attributes. ... remember if you have a rigid relationship between 2 attributes and if there is a change in the content, you must do a full process (of the dimension and also the cubes). ... In all cases the dimension processing option has a direct ...
    (microsoft.public.sqlserver.olap)
  • Re: Named Set Alias
    ... > see the "parent" calculation but this will not let you drill down. ... > 2) Introduce duplicate members into the dimension to create a fake ... > the secondary hierarchy from affecting the "All member" totals. ... >> I have a named set with 5 non-leaf members from the same dimension, ...
    (microsoft.public.sqlserver.olap)
  • Re: Cube and Dimension Processing
    ... Biggest fact table has 10 million rows. ... Biggest dimension table has 500,000. ... In all cases the dimension processing option has a direct ... addition of new members but no changes in existing members ...
    (microsoft.public.sqlserver.olap)
  • Cube and Dimension Processing
    ... What will be the best processing option under these four situations? ... addition of new members but no changes in existing members ... Dimension: addition of new members but no changes in existing members ... members like moving under new parent. ...
    (microsoft.public.sqlserver.olap)
  • Re: Apply a calculation based on criteria
    ... How about adding a unary operator column to your account ... Account dimension in Adventure Works, ... noncalculated members of the parent attribute. ...
    (microsoft.public.sqlserver.olap)