Do I made the things more commplicated? I found that to populate the
fact table is very difficult, even with dimemtion more than 4. Say if
you have 4 dimensions S,W,Y,Z. For each measure, you need to identify
a record (s,w,y,z) prove to be humongious task, particularly when you
business data are very complicated. There must be some professional
way to do that which I am not aware of. Can anyone point me at the
correct direction? Are there any books or articles I can reference to?
You help will be greatly appreciated.