Cubeview - Looping multiple entities into one Excel file?

How do I generate reports in a loop for each member (branches) and send it to single excel file? I have a cube view report which I'm trying to run for multiple entities member (100+ locations). Any i...