Migrating cubes from SQL Server Analysis Services 2000 to MS SSAS 2005

Hello

I am fairly new to SQL Server and wanted to know the best way of converting a .CAB cube created in SSAS 2000 to SSAS 2005 and then associate it with a database.

Rgds

Ankur

Backups done in AS2000 cannot be restored in AS2005. Your best course of actions is to restore the .cab backup on AS2000 system, and then migrate it to AS2005 system.

Migrating AS Repository Advantages

Is there any performance gain on migrating Analysis Services Repository from
.mdb to SQL Server 2000 database ?IMHO the repository will be more manageable, more robust and more secure.
I personally create a seperate DB for the repository i.e. AS_REP
The default is to migrate to MSDB. The problem with that being your jobs
and DTS packages amongst other things are also in there.
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Sws" <anonymous@.discussions.microsoft.com> wrote in message
news:50311460-D284-46A9-BE92-8A1B172C5F7A@.microsoft.com...

quote:

---

> Is there any performance gain on migrating Analysis Services Repository

---

from .mdb to SQL Server 2000 database ?|||synchonizing backups of the repository and the data folder are much easier if you use a
dedicated database. For more information, see the Analysis Services Operations Guide a
nd the Analysis Services Performance Guide at /url]
/bianalysis.asp
Posted using Wimdows.net NntpNews Component - Posted from SQL Servers Largest Community
Website: [url]http://www.sqlJunkies.com/newsgroups/" target="_blank">www.microsoft.com/sql/eveluation/bi...com/newsgroups/

Migrating Analysis Services Roles

Hi,
I have an Analysis Services database that contains 5 cubes. Is it possible
to migrate the database and cube roles from a development machine to a
production machine by performing a file copy? If so, exactly what has to
copied. If not, what is the best way to do it if it is possible.
Thanks!
Look at the Release Management section in the AS Operations Guide
http://www.microsoft.com/technet/pro.../anservog.mspx
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:7204F1A0-8FA6-47BB-8023-FB18D845CAF0@.microsoft.com...
> Hi,
> I have an Analysis Services database that contains 5 cubes. Is it possible
> to migrate the database and cube roles from a development machine to a
> production machine by performing a file copy? If so, exactly what has to
> copied. If not, what is the best way to do it if it is possible.
> Thanks!
sql

Migrating Analysis Services Roles

Hi,
I have an Analysis Services database that contains 5 cubes. Is it possible
to migrate the database and cube roles from a development machine to a
production machine by performing a file copy? If so, exactly what has to
copied. If not, what is the best way to do it if it is possible.
Thanks!Look at the Release Management section in the AS Operations Guide
http://www.microsoft.com/technet/pr...n/anservog.mspx
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:7204F1A0-8FA6-47BB-8023-FB18D845CAF0@.microsoft.com...
> Hi,
> I have an Analysis Services database that contains 5 cubes. Is it possible
> to migrate the database and cube roles from a development machine to a
> production machine by performing a file copy? If so, exactly what has to
> copied. If not, what is the best way to do it if it is possible.
> Thanks!

migraiton from Analysis Service 2000 to 2005

I get this error during migraiton from Analysis Services 2000 to 2005

Unable to cast COM object of type 'System.__ComObject' to interface type 'Interop.Dso.IDbGroup90Ex'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{CE55E9E9-9597-4214-B21F-30C7683467B1}' failed due
to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

IMRAN

Recently I successfully migrated OLAP database from 2000 to 2005 didn't see this error even I had to run few times migration wizards. Best guess, may be some thing not installed or configured correctly. However if you give at what step of migration you get this error that will help.

-Ashok

|||Databases:
FoodMart 2000
Data sources:
FoodMart
Dimensions:
Account
Category
Customer Pattern
Customers
Department
Education Level
Employees
Gender
HR^Pay Type
Marital Status
Position
Product
Promotion Media
Promotions
Store
Store Size in SQFT
Store Type
Time
Warehouse
Yearly Income
Years in the Company
Cubes:
Budget
HR
Sales
Trained Cube
Warehouse
Warehouse and Sales
Mining models:
Customer Pattern Discovery
Member Card RDBMS
Unable to cast COM object of type 'System.__ComObject' to interface type 'Interop.Dso.IDbGroup90Ex'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{CE55E9E9-9597-4214-B21F-30C7683467B1}' failed due
to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).|||

Try upgrading your AS 2005 to SP2.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

migraiton from Analysis Service 2000 to 2005

I get this error during migraiton from Analysis Services 2000 to 2005

Unable to cast COM object of type 'System.__ComObject' to interface type 'Interop.Dso.IDbGroup90Ex'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{CE55E9E9-9597-4214-B21F-30C7683467B1}' failed due
to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

IMRAN

Recently I successfully migrated OLAP database from 2000 to 2005 didn't see this error even I had to run few times migration wizards. Best guess, may be some thing not installed or configured correctly. However if you give at what step of migration you get this error that will help.

-Ashok

|||Databases:
FoodMart 2000
Data sources:
FoodMart
Dimensions:
Account
Category
Customer Pattern
Customers
Department
Education Level
Employees
Gender
HR^Pay Type
Marital Status
Position
Product
Promotion Media
Promotions
Store
Store Size in SQFT
Store Type
Time
Warehouse
Yearly Income
Years in the Company
Cubes:
Budget
HR
Sales
Trained Cube
Warehouse
Warehouse and Sales
Mining models:
Customer Pattern Discovery
Member Card RDBMS
Unable to cast COM object of type 'System.__ComObject' to interface type 'Interop.Dso.IDbGroup90Ex'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{CE55E9E9-9597-4214-B21F-30C7683467B1}' failed due
to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).|||

Try upgrading your AS 2005 to SP2.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Microsoft.AnalysisServices.AdomdClient.AdomdCacheExpiredException

Hello,

I have a asp.net application that connects to a cube in Analysis Service 2005 to do graphs. It's possible that other user might be using the same cube at the same time and make changes to the cube. If I use the graphing tol right after the cube is updated, I sometimes get an error message : "Microsoft.AnalysisServices.AdomdClient.AdomdCacheExpiredException : The Cubes collection has been updated on the server".

Is there a way to refresh the cache or refresh the cube collection? Any suggestion on how to handle this exception is appreciated.

Thank you,

Sincerely,

Annie

I beleive the better solution for the user in this case is to prompt your user to re-connect.

User session on the server has been disvalidated as a result of the some else's activity. To see consistent picture prompt your user to reconnect and refresh all the stuctures.
BTW this is behavior you would see in SQL Management Studio's Cube browser. The minute cube becomes invalid cube browser will asks you to re-connect.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Microsoft.AnalysisServices.AdomdClient

Can anyone tell me if it's possible connect analysis services to an mobile application using AdomdClient..
If yes, how i do this?
If you are asking - is there a version of AdomdClient written for Windows Mobile, the answer is no. However, you can use XMLA directly to send queries to an Analysis Services server from any client|||Thank you. I can get data from Analysis Services, but now i want to show decision trees on mobile.. Do you know some king of AnalysisServices Viewer component for Mobile ?
|||There isn't that I know of, maybe you can modify the sample web viewer (inlcuded with SQL 2005) for this purpose?