Databases Reference
In-Depth Information
Figure 2-5
We strongly recommend that you run the Upgrade Advisor utility, analyze all
the errors and warnings reported, and take the necessary actions. In certain
cases you might have to perform some operations on your existing Analysis
Services 2000 database. For example, if you have a writeback partition in
Analysis Services 2000 that contains data, the recommended approach is to
convert the writeback partition to a MOLAP partition, upgrade the database to
Analysis Services 2005, reprocess the partition, and then re-create a new
writeback partition. Similarly, you might have to perform several steps either
before or after the upgrade on your Analysis Services database to ensure
your existing applications will work correctly.
Once you have analyzed the Upgrade Advisor report on your Analysis Ser-
vices 2000 databases you are ready for upgrade. Install the product and se-
lect the option to upgrade your Analysis Services 2000 OLAP databases.
Analysis Services 2005 only upgrades the metadata of your OLAP data-
bases. So, you will need your relational data source available so that source
data can be populated once again into your cubes. You need to process all
the databases that have been upgraded from your Analysis Services 2000 in-
stallation as well. Once this is completed, all your cubes and dimensions will
be available for querying. If warnings in Upgrade Advisor indicate that names
of dimensions or hierarchies would be changed and if you have invested a lot
Search WWH ::
Custom Search