I think Andrey's solutions are going to be your best bet, given the limitations imposed. If you're able to work in Ad Hoc Analysis or Analysis Workspace to get this data, that might be more ideal since then you won't have to adhere to the segmentation architecture that data warehouse follows.