Error processing a cube while transactions are made to the database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ron - 27 Oct 2005 18:33 GMT

Hi,

I am testing SASS by trying to process a cube while bombarding the
transactional database with new records. The process fails.
It works only when I stop making transactions.

Is there some configuration that enables cube processing while transactions
are still being made ?

Thank you.

Reply to this Message

Peter Yang [MSFT] - 28 Oct 2005 04:30 GMT

Hello Ron,

Based on my scope, it is usually suggest that we do not perform normal
transactions on data warehouse unless when use DTS/SSIS to import data from
OLTP database. I think it is not support to process cube from database
warehouse while perform transactions at the same time.

You may want to consider incremental update feature. This will allow
contents of a cube current without requiring to reprocess the cube in full
when you add new data. The server creates a copy of the object that is
being processed and works on the copy until a commit request is received.
This permits the Analysis Services server to continue answering queries
against existing objects.

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

>From: "Ron" <ron@newsgroups.nospam>
>Subject: Error processing a cube while transactions are made to the

database

>Date: Thu, 27 Oct 2005 10:33:32 -0700
>Lines: 12
[quoted text clipped - 19 lines]
>
>Thank you.

Reply to this Message

Pablo Mugica - 29 Oct 2005 00:20 GMT

But it´s that tweaking the new "proactive cache" & using snapshot isolation
you should be able to do easy incremental processes.
HTH

Pablo S. Mugica
MCDBA, MCSA

> Hello Ron,
>
[quoted text clipped - 53 lines]
>>
>>Thank you.

Reply to this Message