Ok.

So, I guess this is a problem related to the service pack. If you have the SP4 on server I think you may need to update the client objects too,...

Hello.

Thanks for your answer.

Just check the following.

Have your user rights to access (perform a select) the cube's data source or only the OLAP Administrator Group?

This may answer why they...

Hello pdelpreo.

1) What about Setht3 questions?

2) If you installed SP4 on server, did you perform the same on client machine (update client components)?

Let us know.

Regards.

Hello.

Did you remove some registers from your dimension table?

This usually happens when you are trying to Incrementally update a shared dimension and some members were deleted from the dimension source...

Hello.

Have Your user the rights to access the cube's data source or only the OLAP Administrator Group?

Let us know.

Best Regards.

Hello Ikhsan.

Check if you have secutiry authorization to access the Analysis Server through direct connection or http (you may use this methor just adding http: when registering).

From BOL.

"...if the Analysis...

Hello.

The incremental update needs a filter to work properly; otherwise you will have duplicated data in your cube. Analysis Services reads the fact table to process the cube sending an...

Hi.

Just to share other way:

EXEC MASTER..XP_CMDSHELL 'DTSRUN.EXE /S <server> /N <dtsnamewithOlapProcessingTask> /E'

I use this call in stored procedures.

Hope it may help.

Great.

I've been working with Analysis since it was called OLAP Services in SQL Server 7 (beta versions). It's good to see an interview with somebody directly involved with SQL Server,...

Hello.

You don't need to split your fact table in two or more tables to use the Sourcetablefilter and perform Incremental Update.

Here you may find usefull information in how to proceed...

Hi.

If you want to perform an incrementall update in an existing partition you must set the SourceTableFilter property correctly if the source table is the same as the original data.

In Books...