10 Replies Latest reply: Feb 29, 2016 3:23 PM by Gustavo Felhberg RSS

    Generating reports over 5,000 times changing dimension filter

    Gustavo Felhberg

      Hi folks,

       

      I have a word report with general information of Brazilian cities. There are 5,570 cities in Brazil and the idea is having one report for each city (same report, just changing the city dimension filter). In some days I’ll have to start generating these 5,570 reports every weekend and I’m trying to find the best way to do that. I could create 5,570 tasks with 5,570 filters, but I’d like to run away from this effort.

       

      Any ideas? Is there any way to import some kind of spreadsheet with the list of cities and create filters/tasks in some automatic way?

       

      Thanks in advance.