Many to Many Dimensions

Question

Hi ,

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.

MBU	BU	Order No	PO No
Software	MS	001	P01
Software	MS	002	P01
Software	SAP	001	P02
Manufacturing	Cars	003	P03

Thanks,

Gautam

Answer 1

Hi Gautam,

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.

http://dwbi1.wordpress.com/2011/07/28/bridge-table-with-multiple-instances/

Regards,
Jerry