Need Information about Processing and Aggregations (Update / Referenced Dimensions / Many to

HI!

I am looking for some information about processing of complex big models with partitioning.

facts:

we need a lot of aggreations

have several dimension with 2 mio. members

have partitioned the cube and want to process only a few and not all partitions

want to process dimension by update (does not unporcess old partitions) or increment update

have some dimensions with references relationship to the partitions

may have linked measuregroups

questions:

update dimensions processing

does this unprocess a cube or partition?

we have the problem that our partitions get unprocessed?

maybe if its referenced by ohter dimension

or it is an parent child dimensions

are there any circumstances where an update dimension unprocess the cube?

how well are aggregations if we process update dimension

how well are aggregations if we process update referenced dimension

howto aggregate with a many to many measuregroup and update dimension

Links to any good documentation would be really interesting.

THANKS

HANNES

Some good material about AS2005 processing model: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2k5_asprocarch.asp

First. In AS2005 you have 2 types of processing that update dimension.

One is ProcessUpdate and another one is ProcessAdd.

update dimensions processing|||

Hi Hannes,

Did you find what was the problem that your partitions become unprocessed?

I have the same problem, i'm doing processing to new partitions and the old ones become 'Unprocessed'

Thanks in advance.

|||

It was because this was a test environment and we changed metadata. Added some attributes. This always need to be a full process.

LG, HANNES

|||

thanks for your answer.

I'm doing Process Full to the partitions, and I have the problem above.

the source database was changed but my query that reads the data hasn't changed, means that i have new columns in the fact table and i haven't add it to my query, does it matter? , i didn't changed my measure group at all.

Do you have any suggestion?

Do I need to do ProcessFull to dimensions as well?

thanks.

|||

If you do a full process of a partition the processing state of a cube does not change

(if the cube was prcessed before if is processed after

if the cube was not processed before it is not processed after - als log as you process by the xmla commands!)

Hannes