Hi Folks -
I need some suggestions as to what kind of design the users like when it comes to modelling Header and Lines. Let's say we have Order Header and Order Line so when the users use the package do they like to see one query subject in which items form Header and Fact are merged together or do they like to see one Query subject for Order Header and another query subject for Order Lines?
How do you prefer it yourself?
Thanks
Steve
How is it modelled in the data mart?