Multiple data sources, single cube?

Newbie question...

I need to create a report with data coming from two entirely separate data sources, the only common factor being the date.

I can see that I could create a single DSV and cube by using views to point to the second database. But is it considered best practice to create a second cube and join the cubes with MDX?

Thanks

This is not so much of a technical question as a how you solve these problems generally. If there is a point of joining information in separate sources you should do it, not in the cubes, but in a data warehouse.

These integration problems should be handled in extract-, transfer-, load processes before you build a cube.

Have a look here(http://www.kimballgroup.com/) for support and ideas.

HTH

Thomas Ivarsson

|||

Thanks Thomas,

That ties in with advice from the Project REAL docs too.