Re: Processing Cube fails after adding new Fact table rows

#1

have you reprocess the dimension too?

this error mean that the fact table contains a key value which is not found
in the currently processed dimension.
Like the row is associated to a new customer, but if you don't update the
dimension first, the customer doesn't exists in the dimension which cause an
error.

"Todd C" <ToddC (AT) discussions (DOT) microsoft.com> wrote

Quote:

I am a newbie with SSAS 2005. I have a simple cube with two Fact tables
(about 1000 and 1500 rows respectivily) and two Dimensions.

I built the cube with the wizard in BIDS and it processed fine the first
time. After that, I used SSIS to add additional rows to the Fact tables.
Now,
when I go to process the cube again in BIDS, it bombs out with error
messages
that indicate that it does not like the newly added rows in the Fact table
(it mentions specifically a Key value that happens to be the first of the
newly added rows in the fact table).

What am I doing wrong? Where do I look or what settings can I check on?

Thanks in advance.
--
Todd Chittenden

#2

I see it now. One of the Fact tables is realy a hybrid and doubles as a
dimension too.

Be setting up the SSIS task to process the object as a Dimension instead of
as a fact, it seems to be OK.

Thanks for your input!
--
Todd Chittenden

"JÃ©jÃ©" wrote:

Quote:

have you reprocess the dimension too?

this error mean that the fact table contains a key value which is not found
in the currently processed dimension.
Like the row is associated to a new customer, but if you don't update the
dimension first, the customer doesn't exists in the dimension which cause an
error.

"Todd C" <ToddC (AT) discussions (DOT) microsoft.com> wrote in message
news:6739364B-5A86-42A7-8125-B1CCC03572A2 (AT) microsoft (DOT) com...
I am a newbie with SSAS 2005. I have a simple cube with two Fact tables
(about 1000 and 1500 rows respectivily) and two Dimensions.

I built the cube with the wizard in BIDS and it processed fine the first
time. After that, I used SSIS to add additional rows to the Fact tables.
Now,
when I go to process the cube again in BIDS, it bombs out with error
messages
that indicate that it does not like the newly added rows in the Fact table
(it mentions specifically a Key value that happens to be the first of the
newly added rows in the fact table).

What am I doing wrong? Where do I look or what settings can I check on?

Thanks in advance.
--
Todd Chittenden

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Processing Cube fails after adding new Fact table rows

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: Processing Cube fails after adding new Fact table rows - 12-22-2006 , 01:10 PM

Re: Processing Cube fails after adding new Fact table rows - 12-27-2006 , 07:00 AM