Building OLAP Cubes

Hi,
In spite of my bad english, i hope you'll understand my question =)
I've to build an olap data cube which contains 3 data table... But i couldnt find any document about it. I've heard Adodb, Adomd and Mdx concepts but i have no idea about tehem, i ll be grateful if you help me...Hello,
hope I understood you well.
a cube has exaclty 1 fact table. You'll have to join the 3 table into one in a proper way.
If you mean, these three tables still have to become dimensions or facts, and you did not get the concepts of dimensions and facts, search for examples in internet, there are plenty.
Hope this helps
Tobias|||I have a similiar problem which i hope someone can help me with.

What i would like to know is how to create a Cube from a programming perspective (not using the various wizards provided)

For a relational database, i create a connection to the database and then execute SQL commands on it using the SqlCommand object. I can then create a table in the database by having the SqlCommand execute "CREATE TABLE ... etc".

For a muli-dim database, i connect to it using a AdomdConnection object. I can then execute MDX commands on it using an AdomdCommand object.
But the MDX syntax doesn't seem to support the creation of Cubes. I can create a local cube or a session cube, but not a cube from scratch.

Am i missing something?
Is there another way of creating cubes?

Building cube with more than one datasources

How to build a cube with multiple datasources in case we have two separate databases? Is it possible to a build a cube with more than one dataview or datasources ?Yes its possible.

You could create multiple datasources and then add the tables to one or more datasourceviews.
You cold then built a cube based on this scenario.

Hannes

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.

Build a Data Cube?

Hi,
I am a new comers in the fieled of SQL server 2000. I have to buid a data cube having the dimensions year,application number and student details.Please give me the suggestion with the query. I have create just one table with the attributes year,application number and studen details(name, address,marks ). I request you all please help me.

Pranjal,
Gauhati UniversityHey u have analysis services in sql server 2000 which helps u to build data cubes over the table(s). Please check that if u have analysis service installed in ur machine.