Re: Cube and Dimension Processing

Hi Fernando,

We are using a dedicated server for SSAS.

We were planning to do full process on dimensions and process add on
cube for situation 3. But it seems the best solution would be to do
Refrsh/ProcessUpdate on dimension and with Changing Dimension property
true.

Thank you very much for the help.

Mahesh



On Jun 29, 9:46 am, Fernando Ponte <ponte1...@xxxxxxxxx> wrote:
Hello Mahesh

Well, I guess you have enough power for process your cubes each hour.
Will you use a dedicated SSAS server to perform this process or will
you do this direct in your users querying server?

About process. As far as I know, If you perform a Full process in one
dimension you will need to perform a Full process in you cubes.

According to BOL you may use Impact Analysis before process an SSAS
object to see which relate to it.

Quote from BOL 2005.
"Before you process an Analysis Services object, you can analyze the
effect on related objects by clicking Impact Analysis in one of the
Process Objects dialog boxes. Unless explicitly specified otherwise,
objects that depend on another object are not processed when the
object to which they relate is processed. Therefore, if the dimension
that you process is used in several cubes, those cubes will be marked
as unprocessed when you process the dimension. This means that the
cubes must be processed separately before they can be queried. In such
a case, you can take advantage of batch processing settings to process
both the dimension and the related cubes at the same time. For more
information about processing related objects together"

Hope this help.

On Jun 28, 11:44 am, Mahesh <shrestha.mah...@xxxxxxxxx> wrote:



Hi Fernando,

Thanks for the response.

We have about 5 years of data in our datawareshouse.

Smallest fact table has 100,000 rows
Biggest fact table has 10 million rows.
Biggest dimension table has 500,000.

We are planning planning to populate data warehouse and process cubes
every hour. So the processing should not take more than few minutes.

One more question: if we do 'Process Full' on dimension, is it
necessary to do 'Process Full' on dependent cubes? Will 'Refresh' or
'Process Add" work in this situation?

Thanks
Mahesh

On Jun 28, 7:18 am, Fernando Ponte <ponte1...@xxxxxxxxx> wrote:

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.- Hide quoted text -

- Show quoted text -


.

Relevant Pages

  • Re: Checking if all records are processed.
    ... The cubes are processed at night, ... some members is missing. ... > switch on the option to fail the processing on dimension key errors? ...
    (microsoft.public.sqlserver.olap)
  • Re: Hiding Dimension Members
    ... it depends on in what context you are hiding things. ... If for *all* users, then you can hide complete cubes, dimensions, levels, ... and Properties Pane (Dimension Editor Data View). ... If you are hiding members for only certain users then this is what Mosha ...
    (microsoft.public.sqlserver.olap)
  • Re: Cube and Dimension Processing
    ... I guess you have enough power for process your cubes each hour. ... Will you use a dedicated SSAS server to perform this process or will ... dimension you will need to perform a Full process in you cubes. ... addition of new members but no changes in existing members ...
    (microsoft.public.sqlserver.olap)
  • Re: Delete member from dimension without reprocessing
    ... Doing a full process on any dimension will ... force the reprocessing of any partition that uses that dimension. ... > I have built a datawarehouse and am loading the data from the ... The cubes are partitioned by month. ...
    (microsoft.public.sqlserver.olap)
  • RE: Analysis Services Processing Task Not Doing a Full Process
    ... Some cubes are not processed by the process database operation ... They are set to rebuild the dimension ... | packages: same thing. ...
    (microsoft.public.sqlserver.dts)