Reg:Problem with SSAS

45 pts.
Tags:
SQL Server 2005
SQL Server 2008
SQL Server migration
SSAS
SSAS 2005
Hi team,

This is the first time i registered in such communities. I have a problem with SSAS. We planned for a migration from 2005 to sql 2008 which also involves cubes. I am trying to point out SSAS 2005 cubes to 2008 sql server. Is it possible to do this way or do I need to first migrate the cubes to 2008 and only then point them to 2008 server.

Please try to put in your suggestions. Your help is greatly appreciated.

Thanks in advance.



Software/Hardware used:
SSAS

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can load SSAS 2005 cubes from any data source including SQL Server 2008. What kind of cubes are they? What storage model are you using? How are you loading the cubes?

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 481021
    I am nto sure exactly because i find the cube reports are available in .htm files. When i export them to excel i am able to see the pivot tables concept and all the other formats exactly as we see in SSAS cubes. The cubes are loaded using Analysis services processing task. Any idea how to add these htm files to my SSAS solution? I am actually new to this project whihc is developed long back.
    45 pointsBadges:
    report
  • 481021
    Also i Keep getting this error Progress: Building indexes for the 'history' partition has started. - 0 percent complete "There is not enough space on the disk". I tried pointing my cubes to 2005 server and also 2008 and got the same error.
    45 pointsBadges:
    report
  • Denny Cherry
    I've got no idea how the HTML files are being generated. That's probably being done through Reporting Services or another report generation tool. As for the processing error you need to look at the free disk space that is available on the disk that the SSAS database sits on. I'm guessing you'll find that it is out of space.
    66,140 pointsBadges:
    report
  • 481021
    Hi Denny thanks a lot for the reply but the error message i get is Errors in the OLAP storage engine: An error occurred while processing the indexes for the history partition of the history measure group of the history cube from the BROKER_DW_UAT database. I tried to process the dimensions one by one and then ran the ssis package and am finally abel to resolve it...... But i need one more help......how to do migration of cubes from 2005 to 2008......
    45 pointsBadges:
    report
  • 481021
    Hi denny.....i figured out the htm file...actually the excel cube reports are generated and then published as a web page which are again integrated to .net pages. So final thing is need to check on how to migrate form 2005 to 2008.
    45 pointsBadges:
    report
  • Denny Cherry
    I'm not a BI specialist by any stretch of the imagination, but if I remember correctly you should just be able to take the Visual Studio project which has the schema for the cube and simply deploy it to the new SQL 2008 SSAS instance. It you don't have the project I think you can script out the cube using SQL Server Management Studio and create an xlma file which you can then take to the SQL 2008 server and run it in SQL Server Management Studio to create the new cube. Then just right click on the cube and tell it to populate.
    66,140 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following