Thanks for all the replies. It looks like we need to thoroughly test our applications before applying SP4 on a production database ... which sounds like a risky task! I...

Thanks.

How about Analysis Services cubes and dimensions? Should I just migrate the Access mdb file to the new server, then import it in Analysis Manager?

Thanks,

Del Piero

Thanks. Is there a particular advantage of backup/restore over detach/attach option?

Also, should I first restore the master database from backup, then attach the other databases, or vice versa?

Thanks,

Del Piero

Thanks a lot Carl.

delpiero

Thanks Jonathan, Your method works fine.

But is it possible to specify a network drive or UNC path for the excel file? I found that I always got an "failure...

Hey Steve,

      Finally I have come with your "basic table" solution ... and it works .. I think this looks like a typical method of isolating transactions ...

Thanks a lot!

delpiero

Thanks a lot steve. Your solutions helped me a lot!

Best regards,

delpiero

Actually if I run a statement in Query Analyer like:

select * from openquery(<Linked Server Name>, ' <MDX Create Cube statement>')

The cube is actually created, but at the...

Thanks Steve, the dummy measure really works for my case.

In my dimension, I have 3 levels:

Status:     active, non-active

Credited:   credited, non-credited

Customer_name:   customer names sorted in ascending order

If I issue the...

Thanks steve,

        (1)       I think the BASC can help me, but is that the ORDER function requires 3 parameters? I dunno exactly what I should put as the 2nd parameter in...

Thanks,

      I am trying to build a local version of an online cube, having a cube in Analysis Services with SQL 2000 DB as data source, and I wanna build...

Thanks Steve,that's what you have taught me some time ago. Sorry to have forgotten ...

Del Piero

Steve,

    The main reason to rebuild the cube is to refresh the data from the source table. There is no user-based query in my application ... Treat all users viewing...

Hello again,

         I have adopted these steps to retrieve data from my cube:

(1)    Load data from the fact table into a view which filters out unnecessary records.

(2)    Process the...

Thanks Phil, I think what I missed out was to process the shared dimensions before processing the cubes. Now it seems OK.

Thanks,

delpiero