Dz0001


Hi There,

For dimension that grows every day, for example, customer, invoice, when process the AS database in SQL 2005, should I process these growing dimension first before processing cubes

I got error if I process cube first saying "could not find xxxid...",

Thanks





Re: Slow Growing Dimension

Bryan C. Smith


Two ways to address this. One, you can skip processing the dimension and have SSAS substitute the Unknown Member in place of the unrecognized dimension reference. (Search Books Online for "Unknown Member".)

The other (and preferred) method is to process your dimension before processing your cube. If a full reprocess is a challenge, take a look at incremental updates. (Search Books Online for "Incremental Updates".)

Bryan







Re: Slow Growing Dimension

Dz0001

Thanks Bryan again for your advice, I will test the second method you suggest, I am wondering how I can specify process dimension before processing cube in SSIS





Re: Slow Growing Dimension

Bryan C. Smith

One way to do this would be to add an Analysis Services Processing Task to your SSIS package. Connect to your OLAP database, and click the Add... button under your Object List. In the Add Analysis Services Object dialog, expand the OLAP database, expand the Dimensions folder, and then select the dimensions to process.

(Another way to handle this is to write an AMO script. This is significantly more difficult to do but is more dynamic.)

Hope that helps,
Bryan