SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

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

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

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

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


Accepted Solutions
Solution
‎05-19-2017 09:25 AM
New Contributor
Posts: 2

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

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.

View solution in original post


All Replies
SAS Moderator
Posts: 2

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

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

 

 

Community Manager
Posts: 486

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

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

Solution
‎05-19-2017 09:25 AM
New Contributor
Posts: 2

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

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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 157 views
  • 0 likes
  • 3 in conversation