BW: Business warehouse for SAP, it uses a facttables and dimensions. In order to set it up correctly a one must get a good understanding of Oracle partitioning since the design of factables for InfoCubes must be setup a cross partitions to increase BW performance. So I'm looking for people whom actual done this for advice and expertise.