Contact Us
Index
Version 5.2
Version 5.1 Version 5.0 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.3 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 5.2 – Home
Wands
Logging On
New Release Notification
User Profile
Company Code Selection
Excel Not Ready Error
Add-In Load Error
Toggling from V5.x to V4.x
Toggling from V4.x to V5.x
Insert Wands Function
Combine Text
Last Refreshed By
Last Refreshed Time
Split Text
License Key
License Key Errors
Tools (Wands)
Snapshot
Shared Templates Drive
Drive Types
Dropbox
File Server
SAP Database
Navigator
Create a File
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
About
Exit
Errors and Troubleshooting
Help and Shortcuts
Excel Error
Upgrade Workbook
GL Wand
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 SKF CCA Balance
Get Project Balance
Get SKF IO 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
Previous Object
Previous FICO Object
Previous COPA (CB) Object
Alternative GL Account
Get Offsetting Account
Execute Drilldown
Drill Criteria Sheets
Drill Criteria – Classic GL Balance
Drill Criteria – CCA Balance
Drill Criteria – New GL Balance
Drill Criteria – PCA Balance
Drill Using a Saved Template
Drill to Line Item
Drill to Document
Drill to Document Attachment
Calculating
Customize Drilldown
Edit Template Layout
Save Template Layout
Manage Templates
GL Wand Tools
Other Tools
Hide Zeros
Clean Template
Configuration Sheet
GL Wand User Options
Reports Wand
Report
Open 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
Planning Wand
Insert Planning Wand Function
Load CCA
Load PCA
Load New GL
Load Activity Output
Load SKF
Load Option Selector
Loading Plans
Planning Wand User Options
Report Distribution Manager
Create RDM Template
Source Report
Named Ranges
Parameters
Drilldowns
Email
Advanced Options
Edit RDM Template
Execute Report Distribution Manager
Load and Validation
Execution
Scheduler
Create Schedule
Running the Scheduler
RDM User Options
SMTP Email Settings
chat icon - ignore
Live Chat
Chat Offline

Edit RDM Template

Edit Distribution Lines

After the RDM template is generated you can change or set new criteria for an existing distribution line. Changes can be made directly in the template or by selecting a distribution line and clicking on the template edit icon . Alternatively double-click an existing distribution line to edit the line using the Template Wizard. The RDM Template contains dropdown selections and LOVs that can be used to modify or add certain criteria directly in Excel. If a parameter uses a single-cell named range that includes an Wands LOV, the LOV will be available in the RDM Template.

Add New Distribution Lines

Additional distributions can be added to an existing RDM template by clicking on the template create icon . The additional report will be added to the next available row in the current active RDM template. Alternatively, you can double-click on a blank Excel cell under the Source Report heading within an RDM template to initiate the RDM Template Wizard. Excel formulas and cell references can be added to the RDM Template for customization of parameter values, email subject lines or messages, or Merge File Names.

Additional RDM Template worksheets can be added to the RDM Template workbook to organize your reporting distribution.

If cell references are used as parameter values within a RDM Template, they will be valued out if you edit a RDM Template using the RDM Template Wizard. This only applies to the row you have selected to edit using the RDM Template Wizard.

The RDM template is a normal Excel workbook, however, the structure must not be changed to ensure the integrity of the template. You can set and change criteria and add additional lines. Any other changes will corrupt the template.

Legacy RDM Templates

Templates created with versions of RDM prior to release 5.0 cannot be edited using the RDM Template Wizard. To take advantage of new features, recreate your legacy template using the RDM Template Wizard.