Analysis Services 2005

Hi,

For Reporting I am using reporting services using the Analysis Services Cube and i am using SSIS to process the cube.

My doubt is if the cube is processing at the same time the report is running the report is not running.

Can you please let me know what to do to runt he same process at the same time.

Thanks * Regards

Dinesh

You could always process it on another server and then sync it across if the database is not too big, otherwise backup and restore.

Matt

|||

Thanks for reply.

This is a huge database, i cannot take backup and restore.

In SSAS there is an option for doing this task is selecting Automatic MOLAP in partitions tab in the cube.

Thanks

Dinesh