topic Re: Delete the fm fact records having Source as 'BaseForm' from SAS FM Version 5.3 in SAS Data Management

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

Preethy — Mon, 15 May 2017 09:34:40 GMT

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'.

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

zina_stewart — Tue, 16 May 2017 18:04:06 GMT

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

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

AnnaBrown — Wed, 17 May 2017 14:03:48 GMT

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

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

Preethy — Fri, 19 May 2017 10:09:23 GMT

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.