Forum Discussion
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...
You can create Book in that
1. Create a Parameter and Assign a Variable1="Entity Name" and Make it Change Variable to True.
2. Create an another Parameter and Change Pov = True and in Member Script Assign E#|Variable1|
3. Keep changing the Variables in the Book and calling the E#|Variable1| in report and it will run for all the locations.
Note : This method we used because of the formatting requirement and we require only 5 Entity in one page.
If you don't have any formatting issues then you can loop through the variables in the parameters and generate the book.