I'm trying something similar and creating a dynamic schedule, but I'm not getting any data. It doesn't reel through the data, it just creates an empty file.
I have done what the help file shows, but it does not work for me.
Simply create a bursting schedule. The schedule allows you too burst based on grouping. So if you group on store and store is defined as Group 1. You Group 1 as your source.
I have several schedules bursting using this method...