Print Page - How to build a cube with incrementally updating by year

Title: How to build a cube with incrementally updating by year
Post by: damzI on 01 Nov 2016 11:19:01 AM

I have a large cube (about 6 gigs) and have partitioned the cube by the Date Dimension.
I want to be able to incrementally update it by year, instead of building the whole cube at once.
The issue I am running into is the the incremental update checkbox gets disabled when I set up the partition :(
Is there any way I can build my partitioned cube in 2-3 separate builds (by year).

Thanks in anticipation...
- D

Title: Re: How to build a cube with incrementally updating by year
Post by: stan.parker on 01 Nov 2016 11:35:11 AM

I've been building Transformer cubes since 1997 and I'm not aware of any way to partition a cube in 2-3 separate builds.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: damzI on 01 Nov 2016 11:19:01 AM