You don't have to modify the Export action. Just use the not equals (<>) operator in the data protection settings.

Hi

We achieve this using 'Replace by Security' load method and only giving the FDM user security access to write to specific HFM members (in our case a single member on Custom4). This way we can load our TB data whilst protecting any manually entered data.

Hope this helps
Stuart

With that setup in HFM it is not going to be very easy. The issue is that Data Protection only allows you to specify a single string as the protection value. FDM then searches for that string in the entire HFM intersection string i.e. concatanted combination of all HFM Dimension members and if it finds it will execute data protection based on the data protection operator. Therefore you need to have a substring in somewhere in the HFM intersection string that uniquely identifies the data you want to protect. Based on your example of the members in your dimension you do not meet this criteria. If you gave all members that were for manual input only a unique suffix i.e. _MAN then you would be able to achieve what you are looking for - but make sure the suffix you use is not part of any member name in any of the other dimensions                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       

Hi

It doesn't yet, although I understand that an enhancement request has been logged so hopefully it will in later releases. Take a look at this thread as I think it is getting more and more common for clients using batch procesing to implement a 'workaround'.

Batch Loading using Replace by Security

Although Oracle will not officially support changes to the adapter the change we made was very straightforward and could easily be backed out should the need to re-instate the original adapter script be required.

Assuming you are using batch, are you loading a single TB file or multiple? Even if you are loading multiple C4 members, if you are using a single source file and a single batch admin user then the replace by security could work for you, providing no other users have write access to the C4 members loaded by the batch script.

Regards
Stuart

Edited by: StuartGame on May 18, 2011 10:57 AM

Edited by: StuartGame on May 18, 2011 2:18 PM

Yuo should review my last post in this thread. This will likely address your needs.

Hi

When I say 'batch admin' I was just referring to a generic system user account created specifically to run the FDM batch and load data into HFM. It does not need to be an admin user on the HFM side so you can create your security classes and use these to restrict the intersections that can be written to / cleared if using 'replace by security'. I'm not sure that it even needs to be an admin user on the FDM side although this kind of batch user usually is so that they can access all FDM locations.

Regards
Stuart

After all security, i modified my load with

If API.State.GblnBatchLoadActive Then
               objLoadParam.varOptMethodValue ="3"

               End If
Still data gets cleared.
How and what API i can use to check filename ends with3?
Will above code not work?
pls help ASAP

Your post is not very clear. Please take the time to provide an overview of the problem and your process that is "not working"