Hi

I am completely new to OLAP. My company wants to report on the same table(s)
over multiple databases on the same server. I imagine the way to do this
will be with cubes?
Can someone please point me in the right direction or recommend a good
tutorial?

Many Thanks

there is a restriction in AS 2000.
You can't create a cube based on multiple sources. All your dimensions +
fact table must come from the same database.

So I recommand to create some views in a database which retrieve data from
another database. In this case AS is connected to 1 database and access data
from another database. your different databases will share some dimension
like the product list and you must have the same IDs used in your different
databases.

or you can load data into 1 database using DTS prior to load the cubes. this
allow you to clean your data by doing some transformations. This helps you
to convert product ids is these ids are different from 1 database to
another.


"JACO WESELLS" <jacowess (AT) blueyonder (DOT) co.uk> wrote

Thanks. Can you create multiple cubes from multiple sources and link them?



"Jéjé" <willgart (AT) BBBhotmailAAA (DOT) com> wrote

You can create multiple physical cubes and link them using virtual cubes....

"JACO WESELLS" <jacowess (AT) blueyonder (DOT) co.uk> wrote

but here is restrictions:

each cube will have its own dimensions!
so a "customer" dimension for 1 cube is not useable with the cube 2
So your virtual cube will have 2 customers dimensions (1 for each cube).
You have to create a lot of MDX calculated measures to "link" the 2
dimensions and display only 1 customer dimension to the end user.

so, if you are new to OLAP, think using 1 database, you'll simplify your
architecture and you'll have better results and easy to manage solution.


"Michael Vardinghus" <michaelvardinghus (AT) hotmail (DOT) com> wrote