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
31
Views
9
Comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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