-
dspCompose Overview
-
Configuration
- Add a Global Role
- Add Email Addresses for External Users
- Add Stored Credentials as a User on a Page in Integrate or dspCompose™
- Add Users to dspCompose™
- Assign a Catalog to a Custom WebApp for Use with dspCompose™
- Configure Columns to Exclude from Mass Change
- Configure dspCompose™ Parameters
- Configure Global Roles
- Configure Request Statuses
- Configure Settings for External Data Processing and External Request Scenarios
- Configure Workflow Messages
- Display Posting Options on Requests
- Enable Role Validations
- Requests vs. Templates
- Set Up an External Data Email Account
- Set Up Security for dspCompose™
- Set Up Workflow Messages
- Update the EMAIL FROM Column
- Update Validation Messages
- User Credentials in dspCompose™
-
Pages
-
Q-T
- Reject
- Request (External Role Contacts)
- Request (Org Unit Assignments)
- Request (Org Units Assigned)
- Request (Partial Approve)
- Request (Post)
- Request (Role View Filter)
- Request (Roles) H
- Request (Roles-Validations)
- Request Connections
- Request Details Monitor
- Request H
- Request Mass Change (Where Clause)
- Request Mass Change H
- Request Post Connections
- Request Role (Finish Download)
- Request Role Finish Monitor
- Request Status
- Roles (Execute)
- Roles H
- Team
- Template (Archive Settings)
- Template (Columns)
- Template (Event Rule)
- Template (Events)
- Template (External Request Scenario Column)
- Template (External Request Scenario Email Address)
- Template (External Request Scenario External Role)
- Template (External Request Scenario) H
- Template (External Request Scenarios Connections)
- Template (Objects)
- Template (Org Units) H
- Template (Post Message Tables)
- Template (Request Retention)
- Template (Role Column)
- Template (Role Dependency Select)
- Template (Role Event Rule)
- Template (Role Event)
- Template (Role Excel Column Control) H
- Template (Role Validation Threshold Contact)
- Template (Role Validations) H
- Template (Role) H
- Template (Users) H
- Template Role (Finish Columns) H
- Template Role (Finish)
- Template Role Excel (Required Columns)
- Template Role Users Monitor
- Template User (Org Units Assigned)
- Templates H
-
Q-T
-
Procedures
- Activate the Template
- Active Requests Chart
- Active Requests for User Chart
- Active Requests Time Taken (Days) Chart
- Add a Data Source that Stores Views for Import
- Add a Mass Change Custom Link to a Custom Page
- Add a Rule to a Template Role Event
- Add an External Data Role Type to a Template
- Add and Configure Template Roles
- Add Custom Roles for the Looped Template
- Add Email Addresses for a Scenario
- Add External Data Role to Global Roles
- Add List Boxes to an Excel File
- Add Quick Links for dspCompose™
- Add Role Dependencies
- Add the Org Unit Security View to Template Role Validation Rules
- Add Users to Templates
- Add Validations to Roles
- All Requests Chart
- Archive Requests
- Archived Requests Chart
- Archived Requests for User Chart
- Assign a Custom Page to a Template Role
- Assign Default Data Source and Views
- Automatically Set Settings when Creating an External Request Scenario that Creates an Excel-initiated Request
- BDC and GUI Script Recording
- Change Request Status
- Complete the Spreadsheet as an External Data Role
- Configure an External Request Scenario
- Configure an External Request Scenario for an Excel-initiated Request
- Configure Column Display
- Configure Columns for File Generation and Data Entry
- Configure Retention Parameters
- Configure Settings for External Data Roles
- Configure Settings for External Request Scenarios that Create Excel-initiated Requests
- Configure Templates
- Configure the Comparison Approval Setting
- Correct and Post Failed Records
- Correct Rejected Records
- Create a BDC Script
- Create a Custom Template
- Create a Custom Template for Use with the Custom WebApp
- Create a GUI Script Template
- Create a Request for Comparison Approval
- Create a Template For Advanced Users
- Create a Template from an Integrate Template
- Create a Template that Uses the Custom Pages in dspCompose™
- Create all tt Tables and tx Views for the Integrate Process
- Create all tt Tables and Views for the BAPI Process
- Create all tt Tables and Views to Support the Pages in the Custom WebApp
- Create an External Request Scenario
- Create an External Request Scenario for an Excel-initiated Request
- Create Custom Pages and Views
- Create Custom Pages and Views for the BAPI Process
- Create Custom Rules for Excel-initiated Requests
- Create Custom Template
- Create Pages and Views in Custom WebApp
- Create Requests
- Create rt Tables from the tt Tables
- Create rt Tables From the tt Tables and Create Views for the BAPI Process
- Create rt Tables From the tt Tables and Create Views for the Custom WebApp
- Create Teams
- Create Template (Integrate Template)
- Create Template (Recording)
- Create Template Roles
- Create Templates
- CTS Notes Specific to dspCompose™
- Data Objects
- Download Data as a Finish Process
- Edit an Active Template with an External Request Scenario that uses an Excel-initiated Request
- Enter Data for a Request
- External Request Scenarios
- External Request Scenarios that Create Excel-Initiated Requests
- Finish the External Data Role
- Format Required Fields in an Excel File
- Import a Column Added to the Role’s Assigned Page
- Import a File at the Request Role Level
- Import a View at the Request-Role Level
- Inactive Requests Chart
- Inactive Requests for User Chart
- Include DSP® Pages Listed on *Template (Objects)* Page
- Incorporate the Security View into Request Processing
- Link a Template to a Page
- Modify an Active Template in Developer Mode
- Monitor Requests
- Org Unit Objects Generated by dspCompose™
- Org Unit Security in Action
- Post Request Data to a Target ERP System
- Process Requests
- Register Rules to Template-level Events
- Register Tables for Download as a Finish Process using Collect
- Register Tables for Download through Data Services
- Register the CompareIns Stored Procedure
- Register Validations to List Boxes
- Reject an External Data Role
- Request Org Unit Assignments
- Reset a Role
- Review Posting Messages
- Review Request Data
- Sample Stored Procedure For Comparison Approval
- Set a Column’s Control Status
- Set External Role Contacts
- Set Force Reject Severity
- Set Tables to Store Posting Feedback
- Set Target Role for Request Rejections
- Set the Current User as the External Role Contact
- Set up and Post a BAPI using Integrate and dspCompose™
- Set up Email Validations
- Set up Org Units
- Set Validation Threshold
- Setting the Post Start Time
- Setup and Configuration for dspCompose™
- Shippable Items in Detail
- Submit an Email for an External Request Scenario
- Submit an Email for an External Request Scenario that Creates an Excel-initiated Request
- Supporting Objects for Templates
- Team Average Records/Request Chart
- Team Request Counts Chart
- Team Templates Chart
- Template Role Duration Chart
- Top 15 Request Record Counts
- Top 15 Template Request Counts
- Troubleshoot Data Download Using a Data Services Job
- Troubleshoot Issues with External Roles
- Troubleshooting
- Update External Role Contacts
- Updates to Finishing a Data Role for Templates with the Security View
- Use a Custom WebApp with dspCompose™
- Use Comparison Appovals
- Use dspCompose™ with Integrate Looped Templates
- Use External Data Roles in Request Processing
- Use External Request Scenarios
- Use Org Units
- Use the Comparison Approval Page
- Use the Custom Pages in dspCompose™ for the BAPI Process
- Validate a Role
- View Dashboards in dspCompose™
- View Data from the Finish Download Process
- View Import Data Sources
- View Your Active Requests Details
-
Configuration
- Solutions
- Data Quality
- dspCompose
- Create Custom Rules for Excel-initiated Requests
Create Custom Rules for Excel-initiated Requests
dspCompose™ allows a Template Administrator to register custom rules that will run when a template-level event occurs. A rule is set to run when a request is cancelled, created, deleted, or posted based on how that request’s template is configured.
A rule can also be registered to the Request Excel Create event for Excel-initiated requests. Once an external contact sends an Excel file to dspCompose™ and the Excel file passes the initial validations, the request data is loaded into a staging table. Rules can then be run on the data before it is moved to the table used for the Data Entry role for the request.
These custom rules must exist in a data source that is registered to the platform (often in the cMass_Data database), and be registered to the template-level event on the Template (Event Rule) page.
Refer to Register Rules to Template-level Events for details on how to create custom rules for Excel-initiated requests.
Was this article helpful?
Sorry about that.
Why wasn't this helpful? (check all that apply)
Thanks for your feedback.
Want to tell us more?
Send an email to our authors to leave your feedback.
Great!
Thanks for your feedback.