I have Data in the following format in .
AS I understand MBU - BU Is a regular dimension and BU to order no is Many to Many dimension and Order No to PO No is a Many to Many dimension .
I am looking at a Bridge Table or Factless Fact for Order No and BU and Another Bridge Table for PO NO and Order No.
Would that be correct. Please help.
Could you please tell us why you need these factless table? or what do you want to calculate with these factless tables in your OLAP system?
The following article describing factless tabels might be helpful for you.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?