Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

in Planning 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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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