import AS to BID project - how to change cube storage location

After import of AS database to a new project I need to change the cube storage location because it probably points to a location on the server that is not valid in dev.

How can I change the cube storage location in the project (not from management studio)?

Regards,

Right click on the project in the solutions explorer window. Select properties and later deployment.

Regards

Thomas Ivarsson

|||

Thanks for your ansver.

In solution explorer properties I can change the project path - but - I can't see how I can change the storage location of the cube?

My problem is that I can't deploy my project after import of AS database to a new project.

Any ideas are welcome.

Regards,

|||

You can change the name of the database under server in the deployment option?

Thomas Ivarsson

|||

Yes - but it is the storage location of the cube - not the name.

|||

I understand. In the management studio you can right click the cube(properties), after deployment, and change the storage location property. You also have a datadir property for the whole SSAS2005.

I have not changed these properties myself so I do not know about any problems. I have not found any settings for this in the BI-Dev Studio.

Edit:I have. Right click the cube in BI-Dev and choose properties. Change the storage location for the cube.

Regards

Thomas Ivarsson

|||

Well - no.

I have tried that - it does not help.

My problem is that I can't deploy and I suppose it is because my project (after import) can't see my dev AS db.

In prod SQL server is installed at E:\...

in dev SQL server is installed at C:\... on 2 different boxes.

Do you know if you can create a project with the import AS template from the server and then move then project to my laptop to do dev?

Regards,

|||

Sorry. Back from the golf course.

I have tried the same thing without any problems. You say that you are unable to deploy the solution, it is not about file directories. You cannot deploy with standard settings?

Do you have security roles in your imported project that does not match the location /server that you would like to deploy to?

Next, are you using a network share for your data folder, like \\server\logicaldisk\program files ....?

Regards

Thomas Ivarsson

Import Analysis Services 2005 cube into Siebel Analytics

Hi,

I'm trying to import a cube I've created with Analysis Services 2005 into Siebel Analytics Physical Layer.

I've installed XML For Analysis SDK on the SQL Server and created a virtual directory which contains the file msxisapi.dll.

When I try to import I get the following error message fro the server :"Error proccesing request".

I think the problem occurs because the xmla service doesn't "know" I want to import the cube from it.

I'm very new to the issue and we don't have knowledge in our company to solve the problem.

I'll very appreciate it if someone could help me.

Thanks in Advance,

Moving to the SQL Server Analysis Services forum.

import a cube created in AS 2000 into SSAA 2005

Is there any way to import a cube created in AS 2000 into SSAA 2005? If not
a direct import is there any way to make that job easier? Any
suggestions/pointer/comments would be helpful. I have a lot of AS 2000 cube
s
and I am really sick of that development environment!there is no import option
you can try to upgrade your AS2000 server to AS2005.
install AS2000 on a new server, restore your databases and try to upgrade.
if you are a lucky man, then the install can upgrade the cubes, if not, then
there is no choice, you must recreate your cubes.
and, personnaly, I recommend a complete redesign of the cubes because there
is a lot of changes between the 2 versions.
this takes some times, but insure that your cubes will works fine and take
adavnatge of the new capabilities.
"maddog" <maddog@.discussions.microsoft.com> wrote in message
news:125B0852-A1BD-4254-BD29-5F4FC4B9B867@.microsoft.com...
> Is there any way to import a cube created in AS 2000 into SSAA 2005? If
> not
> a direct import is there any way to make that job easier? Any
> suggestions/pointer/comments would be helpful. I have a lot of AS 2000
> cubes
> and I am really sick of that development environment!