Error processing a cube while transactions are made to the database

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.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.
========================================
=============
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
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <OiOgOyx2FHA.2624@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.datawarehouse
>NNTP-Posting-Host: 209-77-216-34.utopy.com 209.77.216.34
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.datawarehouse:2381
>X-Tomcat-NG: microsoft.public.sqlserver.datawarehouse
>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.
>
>|||But its that tweaking the new "proactive cache" & using snapshot isolation
you should be able to do easy incremental processes.
HTH
Pablo S. Mugica
MCDBA, MCSA
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:Z8Rvp$22FHA.3936@.TK2MSFTNGXA01.phx.gbl...
> 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.
> ========================================
=============
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> --
> database
>