# Enable Multi-Source Signal Data Consolidation

With the 26R1 release, users can now create _Statistical Data_ records to store _Product-Event Combination_ (PEC) data from multiple data sources. After you have configured this feature, see <a href="/en/lr/935430/">Signal Detection Overview</a> for more information.

## Configure Custom Fields on Statistical Data Object

On the _Statistical Data_ object, <a href="/en/lr/935435/#data">data fields</a> (such as _Case_ counts and EBGM scores) already exist for the Safety database. You must create similar fields on the _Statistical Data_ object to accommodate data from different sources. To do this: 
1. Navigate to **Admin > Configuration > Objects > Statistical Data > Fields**. 
2. Select **Create**.
3. From the **Field Type** drop-down, select **Number**.
4. Use the table below to complete the field information for FAERS, and then repeat this configuration for VAERS and eRMR respectively. For the minimum and maximum values, use the corresponding Safety data field for reference, for example, _New All FAERS_ corresponds with _New All_. Depending on the field, this range may vary.
5. Refer to the _EVDAS eRMR Data_ object for additional data fields if you want to add them to the _Statistical Data_ object.   

| Label                          | Name                              | 
|--------------------------------|-----------------------------------| 
| `New All FAERS`                | `new_all_faers__c`                | 
| `New Spontaneous FAERS`        | `new_spontaneous_faers__c`        |                                
| `New Fatal FAERS`              | `new_fatal_faers__c`              |                                
| `New Serious FAERS`            | `new_serious_faers__c`            |                                
| `Cumulative All FAERS`         | `cumulative_all_faers__c`         |                                
| `Cumulative Spontaneous FAERS` | `cumulative_spontaneous_faers__c` |                                
| `Cumulative Fatal FAERS`       | `cumulative_fatal_faers__c`       |                                
| `Cumulative Serious FAERS`     | `cumulative_serious_faers__c`     |                                
| `EBGM FAERS`                   | `ebgm_faers__c`                   |                                
| `EB05 FAERS`                   | `eb05_faers__c`                   |                                
| `EB95 FAERS`                   | `eb95_faers__c`                   |                             

## Update Object Layouts

To update <a href="/en/lr/26387/#how-to-access-page-layouts">object layouts</a>:  
* For the _Signal Calculations Setting_ object layout, <a href="/en/lr/26387/#how-to-add-object-fields">add</a> the _Results Output_ field to the _Details_ section.
* For the _Statistical Data_ object layout, <a href="/en/lr/26387/#how-to-add-object-fields">add</a> the _Calculation Data Sources_ field to the _Source_ section and <a href="/en/lr/26387/#how-to-remove-object-fields">remove</a> the _Source_ and _Health Authority Database_ fields.
* For all _Workbench View_ object layouts, <a href="/en/lr/26387/#how-to-add-object-fields">add</a> the _Data Source_ field to the _Details_ section.

## Update Data Source VQL on Workbench View Object

To update the criteria VQL for the _Data Source_ field on the _Workbench View_ object, follow the steps in <a href="/en/lr/1006100/#source-vql">Enable Calculations and Statistical Data Creation for VAERS</a>.

## Configure the Open FAERS and VAERS Case Series in Dashboard Actions

To allow users to analyze and visualize FAERS and VAERS _Signal Case Series_ data in _Workbench Dashboards_, <a href="/en/lr/43127/#assign-actions">assign</a> the _Open FAERS Case Series in Dashboard_ and the _Open VAERS Case Series in Dashboard_ actions to the _Statistical Data_ object. Then, add the actions as <a href="/en/lr/59885/#define-actions">user actions</a> to the applicable states of the _Statistical Data Lifecycle_ object lifecycle.

## Grant Permissions

Update the relevant <a href="/en/lr/22824/#objectpermissions">permission sets</a> to grant _Execute_ permission for the following _Statistical Data_ object actions: 
* _Open FAERS Case Series in Workbench Dashboards_
* _Open VAERS Case Series in Workbench Dashboards_

## Configure EVDAS Views

To return EVDAS data in calculations and store them in _Statistical Data_ records, you must create a _Signal View_ (to be referenced in _Signal Calculations_) and an associated _Principal View_:
1. Navigate to **Business Admin > Objects > Workbench Views**. 
2. Use the table below to create EVDAS safety views. 
3. On each custom EVDAS view, ensure the _Data Source_ field is set to **EMA - EVDAS eRMR** and update <a href="/en/lr/753138/#dependent-views">dependent views</a> and <a href="/en/lr/753138/#sql-editor">SQL</a> according to your business needs.
4. On the EVDAS _Principal View_, create a <a href="/en/lr/753138/#view-columns">view column</a> for the reporting period with the following information: 
    * **Name**: Enter `Reporting Period ID`.
    * **API Name**: Enter `reporting_period_id`.
    * **Column Type**: Select **Object**.
    * **Safety Object Reference**: Enter `evdas_ermr_data__v`.
5. Create view columns for additional fields according to your business needs.

| Safety View Type     | Name                                   | API Name                                     |
| -------------------- | -------------------------------------- | -------------------------------------------- |
| _Principal View_     | `EVDAS eRMR - All Product-Event Combinations Principal` | `evdas_ermr_all_product_event_combinations_principal__c` |
| _Signal View_        | `EVDAS eRMR - Product-Event Combinations`               | `evdas_ermr_product_event_combinations__c`               |

The _Principal View_ returns all relevant fields from the _EVDAS eRMR Data_ object for a _Signal Reporting Period ID_. The _Signal View_ returns the final results, including _Product Family ID_ or _Aggregate Reporting Group ID_ and MedDRA code.

## Next Steps: Configure and Assign Default Workbench Dashboard

To analyze your EVDAS data in _Workbench Reports_ and _Workbench Dashboards_:
1. <a href="/en/lr/774233/#create-workbench-dashboards">Create a _Workbench Dashboard_</a> for EVDAS.
2. Navigate to **Business Admin > Objects > Signal Data Source > EMA - EVDAS eRMR**. 
3. Set the **Default Workbench Dashboard** to the created EVDAS dashboard.
4. Navigate to **Business Admin > Objects > Workbench Views** and select the EVDAS safety view being used in the EVDAS dashboard. 
5. To ensure reporting period, product, and event data will be captured in the EVDAS dashboard, create <a href="/en/lr/753141/#how-to-add-filters">required filters</a> for the following fields: 
    * _Reporting Period ID_ (the API name must be `reporting_period_id`)
    * _Product Family_ or _Aggregate Reporting Group_
    * _MedDRA Code_

Configure and assign a default _Workbench Dashboard_ for <a href="/en/lr/935439/#next-steps">FAERS</a> and <a href="/en/lr/1006100/#next-steps">VAERS</a>, if one has not been configured already.

<div class="note-border alert-info">
  <div class="alert alert-info" role="alert">
    <div><i class="far fa-info-circle"></i></div>
    <div class="alert-text">
      <p><strong>Note</strong>: To use <em>Workbench Reports</em> and <em>Workbench Dashboards</em>, you must obtain a <a href="/en/lr/752926/">Veeva Safety Workbench</a> license.</p>
    </div>
  </div>
</div>


