-
1. Re: Clearing Cells with FDMEE
JohnGoodwin Feb 2, 2017 3:54 PM (in response to MikeTO)1 person found this helpfulWhy not define a calc script in the target options which will clear out data and then run that.- Using Calculation Scripts
Cheers
John
-
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.
-
3. Re: Clearing Cells with FDMEE
JohnGoodwin Feb 2, 2017 5:04 PM (in response to MikeTO)1 person found this helpfulSo 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.
-
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