Delete the fm fact records having Source as 'BaseForm' from SAS FM Version 5.3

[Preethy]

I am trying to use a transformation to delete the fm fact records having Source as 'BaseForm'.My transformation is calling the ETLDLFCT Macro to perform the operation. But it is not able to do so. This is working fine for fm records with Source as 'Base'.

[zina_stewart]

Hi Preethy -

I am the former writer for the SAS Financial Management solution.  I have looked through the FM library and located a section (pg. 169) in the SAS Financial Management 3.3: Formula Guide that addresses deleting facts - but the example uses a wizard, not the transformation that you are using.

http://support.sas.com/documentation/onlinedoc/fm/53/fmsfg.pdf

I am forwarding your inquiry to a technical expert so that you can get an answer to deleting using the ETLDLFCT transformation.

Many thanks!

Zina

[AnnaBrown]

Thank you zina_stewart!

Preethy, it looks like you've opened a track with Technical Support on this issue and they will point you in the right direction. If you could circle back to this community thread with the solution when you reach it, that would be great. Your fellow community members will find it useful to know what worked.

Best,

Anna

[Preethy · Accepted solution]

Hi All,

I was able to figure out the solution on some further thoughts.We have an option in the delete_fm_fact_data transformation,In the properties-->Table option,we have an option to select it from a dropdown-->"delete facts entered through forms".

Thank you for all the members who tried to help me with the suggestions.