I have sales, finance, orders, HR etc. fact tables in my DWH. I want to build cubes now. Users may want information from more than one cube at a time. If I make four cubes I have to set drill through property and it will again display information in separate window. So is it advisable to keep all the facts in one cube though they are at different levels of granularity? Will it be complex to maintain? What about performance?
Any help regarding the same is highly appreciated.