Re: Analysis Server Incremental Update on Changing Dimensions

From: mark hill (mark_at_mark-hill.com)
Date: 09/11/04 

Date: Sat, 11 Sep 2004 19:26:43 GMT

How about processing them on a different server and then copying them over
with robocopy or something when they are done.

Mark

"Joseph Ollero" <jollero@wizardsgroup.com> wrote in message
news:7e9001c4957e$72b92250$a501280a@phx.gbl...
Dear Anyone,

Our OLAP users reported inconsistencies with their
reports. To better describe the problem please refer
below:

Item 1 -- 2
Item 2 -- 5
Item 3 -- 3
Item 4 -- 1
Total -- 15

We noticed the following error in the application event
log:

Error during lazy aggregation of partition
Broadcast_Response_2004_07 in cube Broadcast_Response:

Error during lazy aggregation of partition
Broadcast_Response_2004_06 in cube Broadcast_Response:

Error during lazy aggregation of partition
Broadcast_Response_2004_08 in cube Broadcast_Response:

The errors above has led us to the following knowledge
base articles:

http://support.microsoft.com/default.aspx?scid=kb;EN-
US;325289

http://support.microsoft.com/default.aspx?scid=kb;en-
us;259677

http://support.microsoft.com/default.aspx?scid=kb;en-
us;820358

Our OLAP Application Setup
Cubes: 2
Cube Partitions: Monthly
Average Number of Records per Partition: 23M
Active Partitions: 8

Distinct Count: Yes

Virtual Cubes: 1
Changing Dimension: 2

Operation: Incremental Update of All Partitions Everyday
                Incremental Process of Cubes Every Day

BI Accelerator: Yes

Our main concern is that the knowledge base articles
instructs us to re-aggregate the entire cube in order for
us to work around the problem. The problem is we
incrementally update our changing Dimensions everyday. To
add to this, we measured how long it takes to full re-
aggregate one partition - it took more than 45 minutes to
finish one. Totalling all the time it takes for our
process to finish, the time involved in the suggested
work around would be impractical for us.

I hope you give us some insights and suggestions with
this problem.

Thank You

P.S.

If we remove all user designed aggregations from all our
cubes, will we still end up with the same problems?

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

Joseph R. Ollero
MCP, MCSD

Associate Technical Specialist

dB Wizards
Microsoft Gold Certified Partner for Learning Solutions

Microsoft Gold Certified Partner for Business Intelligence

Authorized Prometric Testing Center

Authorized VUE Testing Center
28/F 88 Corporate Center 141 Valero cor Sedeņo St.
Salcedo Village, Makati City, PHIL
Tel. (632)757-4889 Fax. (632)757-4890
email:jollero@wizardsgroup.com
URL:www.wizardsgroup.com

"Your Partner of Choice!"

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

dB Wizards named CTEC of the Year by Microsoft
Philippines!

Relevant Pages

  • RE: Incrementally updated dimensions and lazy processing
    ... I would not triplicate your shared dimensions just so you can have unshared ... we have a cube containing historic ... processing the newly added month partition. ... lazy aggregation of all the cube partitions in the background. ...
    (microsoft.public.sqlserver.olap)
  • Analysis Server Incremental Update on Changing Dimensions
    ... Error during lazy aggregation of partition ... Broadcast_Response_2004_07 in cube Broadcast_Response: ... Microsoft Gold Certified Partner for Business Intelligence ...
    (microsoft.public.sqlserver.olap)
  • Re: Several Partitions vs Several Cubes
    ... > the work required to "merge" these cubes into 1 virtual cube and create ... With the partition option you must reprocess all partitions, ... > districts ("all districts" not available and no district comparison ...
    (microsoft.public.sqlserver.olap)
  • Re: Validating a cube prcoessing job
    ... thanks for the reply Dave. ... Then have your application bind to the cube ... > Being able to "unprocess" a partition is a new feature in 2005. ... >> Think of this as commiting a transaction in SQL. ...
    (microsoft.public.sqlserver.olap)
  • Re: DSO ERROR
    ... But another question," multi-user concurrently process different partition ... With regards to whether or not two users can be processing the same cube; ... >> Program Manager ...
    (microsoft.public.sqlserver.olap)