Hi,
I am working on MSAS, IBM DB2 olap server. I need to know how we can
use 2 fact tables in one cube. Is it the same as fact-constellation. Is
it only a theoretical term, if not then which olap supports this. I
also want to have a faq for general questions on olap server. Please
reply at the earliest


Bhuvan

Hello,

In AS2000 only one fact per cube is possible.
You can build two cubes and build a vitual cube on top.

In AS2005 a cube can build on multiple fact tables.

FAQs:
http://www.mosha.com/msolap/
and
http://msdn.microsoft.com/library/?u...asp?frame=true

HTH
Jörg


"Bhuvan" wrote: