Restoring SQL 2005 Analysis service database backup on SQL 2000

Hello
I think the subject line says it all.
Is there any way to import my cubes, measures from SQL 2005 Analysis
service to SQL 2000 Analysis service database.
Madhur> I think the subject line says it all.
> Is there any way to import my cubes, measures from SQL 2005 Analysis
> service to SQL 2000 Analysis service database.
I do not think so. If you have a data warehouse, you can create a fresh OLAP
2000 cube. If not, you have problems. What you could do is you could
regenerate a SSAS 2005 project with BI Dev Studio, then generate the DW
schema in a relational database from the project, and finally generate the
OLAP 2000 cube from the DW. You have to export the data from the SSAS UDM to
the DW and then process the OLAP 2000 cube.
maybe I am wrong, but at the moment, I cannot imagine an easier process.
--
Dejan Sarka
http://www.solidqualitylearning.com/blogs/

Restoring SQL 2005 Analysis service database backup on SQL 2000

Hello
I think the subject line says it all.
Is there any way to import my cubes, measures from SQL 2005 Analysis
service to SQL 2000 Analysis service database.
Madhur> I think the subject line says it all.
> Is there any way to import my cubes, measures from SQL 2005 Analysis
> service to SQL 2000 Analysis service database.
I do not think so. If you have a data warehouse, you can create a fresh OLAP
2000 cube. If not, you have problems. What you could do is you could
regenerate a SSAS 2005 project with BI Dev Studio, then generate the DW
schema in a relational database from the project, and finally generate the
OLAP 2000 cube from the DW. You have to export the data from the SSAS UDM to
the DW and then process the OLAP 2000 cube.
maybe I am wrong, but at the moment, I cannot imagine an easier process.
Dejan Sarka
http://www.solidqualitylearning.com/blogs/