Hello,

I need to work with 2 databases:
in the first I have informations about the turnover, so it's possible to
built a cube with the measure turnover and the dimension product.
in the second I have informations about the product, product groups, special
information like colour, price etc. It is not possible to built any cube
because there is no measure.

So I need a cube with the measure turnover (from my first database) and the
dimension product with an hierarchy: product group, colour, product.(from my
second database).

Is it possible?
Do I need Microsoft SQL Server Enterprise Edition?

Thanks in advance,

Reiner

If I understand you right, you want to create a cube with the measures in
one database, and dimensions in another. I assume there is some kind of join
condition between the two. If you can make sure your fact table stays in one
database and dimension tables stay in another, you may be able to do it
without requiring JOINs between those tables.

You can use the "Optimize Schema" feature in the Cube Editor. If all
dimensions are optimized, MSAS would retrieve all tables separately without
using JOIN. So you could even have each dimension in a different database!

But if you cannot optimize some dimensions, you need to rely on the
heterogenes join feature, which I'm not sure if MSAS supports it. It should
be easy to find out.

- Yubo Fan

"Reiner Wahnsiedler" <wahnsiedler (AT) t-online (DOT) de> wrote

Hello,

thank you for the response.

You are right. That is exactly what I want.

I will try it. Thank you.

Reiner