building cube using AMO

hi,
i am developing an application which enables the user to create a cube on the fly. I know that i can use AMO to create a Analysis Services 2005 cube.

but my question is :

Is it possible to use AMO to create a Analysis Services 2000 cube ?

Cheers

Anil

The answer to your question is: No, you cannot use AMO to create cubes in Analysis Services 2000. There are too many differences betwee AS 2000 and AS2005. Analysis Services in version 2005 has been rebuilt almost from the groud up. The techologies and protocols used in AS2005 are new.

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

|||

I am in the process of converting a DSO and SQLServer 2000 process which programmatically creates data sources (now DS views), dimensions, and cubes to AMO and SQL Server 2005, and I've been struggling. Can anyone suggest a good book or documentation source which clearly describes the new AS object model and gives comprehesive, well explained AMO examples (preferably in VB)?

Thanks in advance.

|||how can we use AMO to build cubes on the fly?|||

Thanks for your help edward.

Cheers
Anil

|||

I suggest you guys start a new thread.

Just shorly:

To learn AMO it often better to take a look at number of AMO samples provided with SQL Server 2005 installation.

There is already abundance of information you can search for with people posting on how to use AMO.

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

building an .asdatabase file from the command line

Hi,

I was wondering if anyone knew how to 'build' an 'analysis services' project (i.e - generate the .asdatabase file) from the command line, so that I could have it done automatically during a build process.

Thanks,
Kobi Reiter

Play around with the devenv.exe executable at the command-line. Although I have not tried it, you might be able to use it with your project file and with a "/build" option. The executable is the what launches when you run BI Dev Studio. Typical setup has it located at:

"C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\devenv.exe"

Dave Fackler

|||

Unfortunately, when I try to run devenv with the /build switch, it fails:

Package 'Visual Studio Source Control Integration Package' failed to load.
Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED))

|||I'm also interested in this. Need to automate the build of our deployment package. Haven't been able to find any information on this.
|||I am also interested in this topic .... Anyone can contribute any idea(s). Thanks.|||

hello,

i would expect something like the following to work

devenv.exe <your_solution_name>.sln /build Development /Out out.log

Note that you might need an SP1 build for this.

hope this helps,

building an .asdatabase file from the command line

Hi,

I was wondering if anyone knew how to 'build' an 'analysis services' project (i.e - generate the .asdatabase file) from the command line, so that I could have it done automatically during a build process.

Thanks,
Kobi Reiter

Play around with the devenv.exe executable at the command-line. Although I have not tried it, you might be able to use it with your project file and with a "/build" option. The executable is the what launches when you run BI Dev Studio. Typical setup has it located at:

"C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\devenv.exe"

Dave Fackler

|||

Unfortunately, when I try to run devenv with the /build switch, it fails:

Package 'Visual Studio Source Control Integration Package' failed to load.
Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED))

|||I'm also interested in this. Need to automate the build of our deployment package. Haven't been able to find any information on this.|||I am also interested in this topic .... Anyone can contribute any idea(s). Thanks.|||

hello,

i would expect something like the following to work

devenv.exe <your_solution_name>.sln /build Development /Out out.log

Note that you might need an SP1 build for this.

hope this helps,

building an .asdatabase file from the command line

Hi,

I was wondering if anyone knew how to 'build' an 'analysis services' project (i.e - generate the .asdatabase file) from the command line, so that I could have it done automatically during a build process.

Thanks,
Kobi Reiter

Play around with the devenv.exe executable at the command-line. Although I have not tried it, you might be able to use it with your project file and with a "/build" option. The executable is the what launches when you run BI Dev Studio. Typical setup has it located at:

"C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\devenv.exe"

Dave Fackler

|||

Unfortunately, when I try to run devenv with the /build switch, it fails:

Package 'Visual Studio Source Control Integration Package' failed to load.
Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED))

|||I'm also interested in this. Need to automate the build of our deployment package. Haven't been able to find any information on this.
|||I am also interested in this topic .... Anyone can contribute any idea(s). Thanks.|||

hello,

i would expect something like the following to work

devenv.exe <your_solution_name>.sln /build Development /Out out.log

Note that you might need an SP1 build for this.

hope this helps,

Build Report Model from Analysis Service Database

I try to build a report model that have data source point to AS Database, but
i can't.
This is what i try: change the provider to OLE Db AS 9.0 and select the AS
database, but the data source view can't detect a data source.
another way i try is using an existing AS project, but the project combo box
is empty.
Pls let me know way to do this. Thank you.Just to add-on: I am using Microsoft SQL Server 2005 CTP version
"Chai Ling" wrote:
> I try to build a report model that have data source point to AS Database, but
> i can't.
> This is what i try: change the provider to OLE Db AS 9.0 and select the AS
> database, but the data source view can't detect a data source.
> another way i try is using an existing AS project, but the project combo box
> is empty.
> Pls let me know way to do this. Thank you.