4 Replies Latest reply on Feb 2, 2017 5:11 PM by MikeTO

Clearing Cells with FDMEE

MikeTO Feb 2, 2017 3:37 PM

Hi All,

Is there an easy way to clear cells in Planning through FDMEE rather than just loading zeroes. In Smartview, you can submit #Missing and the cells clear. How could I send a #missing through FDMEE?

Essentially, my goal is to clear (not zero out) cells in Planning via FDMEE.

Thx,

Mike

1. Re: Clearing Cells with FDMEE

JohnGoodwin Feb 2, 2017 3:54 PM (in response to MikeTO)

Why not define a calc script in the target options which will clear out data and then run that.- Using Calculation Scripts

Cheers

John
1 person found this helpful
Like Show 0 Likes(0)

Actions
2. Re: Clearing Cells with FDMEE

MikeTO Feb 2, 2017 3:57 PM (in response to JohnGoodwin)

Thx John.

We use calc scripts in FDMEE now but that won't solve when we just want to clear a cell or two. Seems complicated to send an account variable into the script just to clear one intersection.

We have users that load files through FDMEE into Planning. Was hoping to keep them locked down in FDMEE without opening up more access through Planning forms to clear.
Like Show 0 Likes(0)

Actions
3. Re: Clearing Cells with FDMEE

JohnGoodwin Feb 2, 2017 5:04 PM (in response to MikeTO)

So you want to load a file into FDMEE and for the members in the file clear the data? If so in the FDMEE DLR you could have an essbase load rule set in the target options, the essbase load rule could be set to replace zeros with #missing.
1 person found this helpful
Like Show 0 Likes(0)

Actions
4. Re: Clearing Cells with FDMEE

MikeTO Feb 2, 2017 5:11 PM (in response to JohnGoodwin)

Thx. I could also do that using FDMEE as well just assign a specific load rule or location for loading #missing and then just do a jython replace function in the befload event script. I was just wondering if there was a simple out-of-the-box route.

Thx,
Mike
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.