sql server data warehouse: Joining cubes -- sql server data warehouse

Re: Joining cubes

Jeje
3/7/2007 6:51:42 PM

there is no join option for cubes.

but you can use virtual cubes (in AS2000) or link the cubes (SSAS2005)

when you link 1 cube in another, the user is able to access the measures of
the 2 cubes at the same time.
you have to use shared/common dimensions to be able to analyze the measures
of the 2 cubes at the same time. (like 1 common time dimension)

[quoted text, click to view]

Re: Joining cubes

Gilgamesh
3/8/2007 3:11:14 PM

How do you share dimensions? I tried nameing them the same in all thecubes,
but when I drag and drop the dimensions to the browser it creates separate
columns even though they're called with the same name.
-G

[quoted text, click to view]

Re: Joining cubes

Gilgamesh
3/8/2007 6:15:42 PM

Ok. I'm getting very close. How can I combine three fact tables into one? In
other words, how can I JOIN them?
-G

[quoted text, click to view]

Re: Joining cubes

Jeje
3/8/2007 7:19:04 PM

do you use AS2000 or 2005?
is AS2000 shared dimensions are created in the shared dimension tree of the
management console.
use the SAME dimension in both cube to be able to analyze the measures of
the 2 cubes at the same time.

in 2005 all the dimensions are shared by default, so use the same dimension
in both cubes.

having the same name is not enough.

[quoted text, click to view]

Re: Joining cubes

Jeje
3/8/2007 9:43:21 PM

well... joining 3 fact tables its different.

can you explain what are the 3 tables and the 3 associated cubes you have.
and the version of the tools (SQL2000 or 2005)

take a look at the foodmart sample or the adventure works sample to see how
different fact tables are combined into 1 cube.

[quoted text, click to view]

Re: Joining cubes

Gilgamesh
3/9/2007 12:11:03 PM

I'm using AS2005. I started by creating three differentd data source views
and then created one cube for each view. i.e. one cube for Orders, one for
Invoices, and one for Receipts. That part works fine. Now I need to either
create a fourth cube, or maybe somethings else, whcih allows me to comine
the records of three fact tables into one view. I'll need specifcally six
columns of each fat tables, which have been named the same, to be included
in the new fourth cube.

The issue is not to combine multiple fact tables into one cube. The issue,
maybe, is to combine multiple fact tables into one fact table and then use
that table in a cube.
-G

[quoted text, click to view]

Re: Joining cubes

Jeje
3/10/2007 1:58:28 PM

ok, now I see

first use only 1 DSV and add all the tales used in this unique DSV; add the
correct relationship between fact tables and dimension tables.
after, create only 1 cube and 3 measure groups each one linked to the 3
tables;
now you have 1 cube with the measures from the 3 source tables.
the cube wizard will create everything for you if the DSV contains enough
information (ie good links).

again, take a look at the adv. works sample to see how this works.

if your tables come from 3 different database, and if you are not familiar
with SSAS, try to copy your tables into the same database to simplify your
project.
or use the linked servers + views, but try to have only 1 source database
for your cubes.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server data warehouse group.