Creating automated data extracts

Summary:

I have several EPBCS cubes that are being used for data input and a consolidated Essbase cube that is primarily used for reporting. EPBCS groups have different sets of entities; the Essbase cube has a consolidated set of entities from all EPBCS cubes. Products and accounts are the same across all cubes.

I have predefined lists of entities, products and accounts. Let's assume that these lists are user-maintained, and they cn be saved in Excel or CSV format if any changes are necessary. We may have more than one list with different sets of entities and products.

I need to automatically generate data extracts for all combinations of the parameters listed above, for each entity/product/accounts list. I want to avoid techniques like SmartView Query Designer as it will involve a human sitting and hitting "Apply Query" several times a day.