You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Creating automated data extracts

Received Response


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.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!