Skip to main content
In Microsoft Access a summary of information from a query can be appended to another table in the summary form.   This is important in a dynamic database (such as Salesforce).   Is there any way in Salesforce to run a Matrix report, then append the results to fields in another object, without going through Data Loader?

 

Thank you,

 

Rick
1 risposta
  1. 28 mar 2013, 11:21
    Not directly.  In Salesforce, the report results are not stored in a data table -- they are generated for display.  Therefore there is no "data transformation" available.

     

    However, you can use Analytic Snapshots which run a saved report on a scheduled frequency, and store the report results in a custom object.  This custom object can have triggers, and can be related to other objects, and can be reported from.

     

    You can check out Analytic Snapshots under Admin Setup->Data Management->Analytic Snapshots