Contact Us
Index
Version 21.3
Version 5.1 Version 5.0 Version 5.2 Version 5.3 Version 5.4 Version 5.5 Version 5.6 Version 20.1 Version 20.2 Version 20.3 Version 20.4 Version 21.2 Version 21.4 Version 22.1 Version 22.2 Version 22.3 Version 22.4 Version 23.1 Version 23.2 Version 23.3 Version 23.4 Version 24.1 Version 24.2 Version 24.4 Version 25.2
Contact Us
Wands for SAP 21.3 – Home
Wands
Logging On
User Profile
Company Code Selection
Excel Not Ready Error
Add-In Load Error
Toggling from V21.x to V4.x
Toggling from V4.x to V21.x
License Key
License Key Errors
Insert Wands Function
Combine Text
Last Refreshed By
Last Refreshed Time
Split Text
Tools (Wands)
Snapshot
Shared Templates Drive
Drive Types
Navigator
File Server
Create a File
SAP Database
Delete a File
Edit a File
Open a File
Common Options
Administrator
System Administrator Options
System Administrator License Key
System Administrator User Permissions
System Administrator User Options
System Administrator Delimiter Options
System Administrator Configuration Options
System Administrator Server Information
Errors and Troubleshooting
Help and Shortcuts
Excel Error
Upgrade Workbook
About
Exit
GL Wand
Quick Start
Report Wizard
Add Columns
Design Layout
Add Rows
Report Wizard Output
Company Code and Object Selector
Discover
Discover FICO Object Values
Expand/Explode Level
Expand and Explode
Expand FICO Object Values
Expand FICO Object Value Hierarchy
Explode FICO Object Values
Explode FICO Object Value Hierarchy
List of Values
List of Values – Create
Insert GL Wand Function
Get Balance
Get Classic GL Balance
Get New GL Balance
Get Daily GL Balance
Get CCA Balance
Get PCA Balance
Get COPA (CB) Balance
Get Internal Order Balance
Get Activity Type Balance
Get Project Balance
Get SKF CCA Balance
Get SKF IO Balance
Get Universal Journal Balance
Get Overall Plan Balance
Get SKF PCA Balance
Company Code Name
Object Description
FICO Object Description
COPA (CB) Object Description
Next Object
Next FICO Object
Next COPA (CB) Object
Get Exchange Rate
Fiscal Period to Month
Previous Object
Previous FICO Object
Previous COPA (CB) Object
Alternative GL Account
Get Offsetting Account
Calculating
Execute Drilldown
Drill Criteria Sheets
Drill Using a Saved Template
Drill to Line Item
Drill to Document
Drill to Document Attachment
Customize Drilldown
Edit Template Layout
Save Template Layout
Manage Templates
GL Wand Tools
GL Wand User Options
Other Tools
Hide Zeros
Clean Template
Manage Criteria Templates
Configuration Sheet
Reports Wand
Report
Create Report
Execute Report
Insert Function
Insert Run Report Function
Run Report Filter
Modify a Run Report Function
Drill On Function
Drill to Saved Template
Refresh
Refresh Reports Wand Functions
Refresh Mode
Show
Parameter List
Report Editor
Template Manager
Tools
Reports Wand User Options
Administration
Report Definition
Create
Edit
Import Export
Planning Wand
Insert Planning Wand Function
Load CCA
Load PCA
Load New GL
Load Activity Input
Load Activity Output
Load SKF
Load S4 Financial
Load Option Selector
Loading Plans
Planning Wand User Options
Report Distribution Manager
Create RDM Template
Source Report
Named Ranges
Parameters
Drilldowns
Email
Advanced Options
Execute Report Distribution Manager
Load and Validation
Execution
Edit RDM Template
Scheduler
Create Schedule
Running the Scheduler
RDM User Options
SMTP Email Settings
chat icon - ignore
Live Chat
Chat Offline

Create Schedule

To schedule a RDM template, navigate to RDM | Scheduler | Create. You will be presented with a form to help create the template.

RDM Template

Select the RDM Template you would like to schedule by clicking on the file navigation  or Shared Templates Drive  icon.

Your RDM template must have valid RDM data on each sheet in the workbook otherwise an error will occur when the scheduler runs.

Schedule Pattern

You can choose to schedule the RDM Template one time, or on an Hourly, daily, weekly, or monthly schedule:

  • If you select the One time radio button, you choose a date and time to run the RDM Template.
  • If you select the Hourly radio button, you choose the recurrence interval for the job and the date and time to start the RDM Template. An interval of 1 produces an hourly schedule and an interval of 2 produces an every other hour schedule. The task will start at the specified time according to the increments of recurring hours.
  • If you select the Daily radio button, you choose the recurrence interval for the job and the date and time to start the RDM Template. An interval of 1 produces a daily schedule and an interval of 2 produces an every other day schedule. The task will start at the specified time each day.
  • If you select the Weekly radio button, you choose the recurrence interval for the task, the date and time to start the task, and the days of the week in which to start the RDM Template. An interval of 1 produces a weekly schedule and an interval of 2 produces an every other week schedule. The task will start at the specified time on each of the specified days.
  • If you select the Monthly radio button, you choose the months in which you want to start the task and the days of the months and the days of the week for each month in which you want to start the RDM Template. You can also specify that you want to start the RDM Template on the last day of each month.
  • If you select the Fiscal Calendar radio button (only available on certain configurations), you choose the Calendar and then the corresponding Periods in which you want to start the task. For each fiscal period choose either the Days of the period or On specific days of the week for each period in which you want to start the RDM Template. Additionally you can specify that you want to start the RDM Template from the last day to the fifth last of each period.
    The calendar and associated periods must already be defined in your system and be available under the Period functions in GL Wand.

Recurrence

Set the start date and time for the task, you can optionally set an end date for your schedule that will cause the schedule to expire, when a job is expired, the RDM Template will not run.

Task Status Notification

You can choose to receive an email notification on the completion of a scheduled task, enter multiple email addresses separated by a “;” or a “,”. If you wish to only be notified when a task completes with an error, set the “Notify on error only” check box.

The Task Status Notification requires that the user has completed the RDM User Options email settings. Please confirm your settings by selecting the Options menu from the RDM Tools ribbon.

You can now click Create and a new workbook containing the RDM Scheduler template will be created.

RDM Scheduler Template

This is a normal Excel workbook. However the structure must not be changed. The only changes that you may make to this workbook are to insert more lines. Any other changes will most likely corrupt the definition and Report Distribution Manager will give an error when you try to run the scheduler.

The RDM Scheduler template has three visible columns, RDM Template, Schedule and Enabled:

  • The RDM Template column displays the absolute path and name or the link (if RDM Template is selected from Shared Template Drive) of the RDM Template associated with the schedule job.
  • The Schedule column holds only a text description of the schedule and will change in accordance with modifications to the schedule.
  • The Enabled column allows you to enable or disable the schedule job. A job that is enabled can run, a job that is disabled will not be scheduled and cannot run until it is enabled.

Edit Schedule

You can modify a schedule by double clicking the row or by selecting the row you wish to edit, then navigate to RDM | Scheduler and select the Edit icon.

Run The Scheduler

Once you have created your schedule your are ready to run the scheduler.