clear cube in Cube mapping

Hi all,

I am creating a dataloader to allow a user to upload budget or forecast data file to EPM and then process into a cube. The one problem i have is with clearing the existing data cube so that only the selections i am loading are cleared (eg budget version / period / entity etc).

The clear cube will blitz the whole cube which is not what i want to do. Is there a way of defining the areas of the cube (maybe using parameters?) - that i can pass to the mapping via app engine.

Find more posts tagged with

Infor EPM Discussions

Comments

martin-reischl

Hi Peter,

there is a post here with some AppEngine routines that you can use to delete or export data from a cube, with parameters which define the data area:

https://community.infor.com/infor-epm-user-group/m/faqs-how-to-s-and-best-practices/2010

Best Regards

Martin

Peter Chapman

Thanks Martin,

i have used the import process to read the data from the dwh tables. however i am still facing the same issue in that the data area is not cleared - i need the data area to be equivalent of the data set to clear.

ie
data table is
entity / accounts / department / marketsegment / mealperiod / Period / scenario / currency / rate

some can be hard coded like 'all accounts' alldepartments all marketsegment all mealperiod
others need to come from the dataset such as entity / period / scenario / currency.

0911060553270289.pdf

vikas-sharma

I had encountered the same issue and found a workaround using an app engine process. In the solution, the customer uploads data into a data table, then goes to a report where they select parameters (target area) and click a button. When the button is clicked, the app engine process is executed. This process clears the data using a data area and performs the table load process. Although this method may not be very smooth, it was effective in resolving the issue.

unknown

My idea would be to use a mapping that points to an empty SQL table and clears the data in the data area before loading.

0712131256598360.doc

Copyright © 2025 Infor. All rights reserved.