MS SQL Server OLAP - RE: Can I use fact-constellation in MSAS and if not then where I can u

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

RE: Can I use fact-constellation in MSAS and if not then where I can u

Joerg

2005-12-29, 7:23 am

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/?....asp?frame=true

HTH
Jörg

"Bhuvan" wrote:

> 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
>
>

Sponsored Links