Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 OLAP design joining two fact tables

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-09-08 : 09:02:41
Varadarajan writes "hi:

I am having a problem with two facts having many-many relationships among themselves. I have configured them as two facts. Let me take an example.

If i have categories and products such that one product can be in many categories and one category can have many products. In such a situation how do i configure the OLAP fact.

Regards
Varda"
   

- Advertisement -