Creating automated data extracts
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.