Contact Us
Index
Version 20.4
Version 20.3 Version 21.1 Version 25.2
Contact Us
Wands for Oracle Cloud 20.4 – Home
insightsoftware
Installation
Multi Factor Authentication
Insert insightsoftware Function
Combine Text
Last Refreshed By
Last Refreshed Time
Split Text
Tools (insightsoftware)
Common Options
Snapshot
Shared Templates Drive
Edit a File
Open a File
Drive Types
Dropbox
File Server
Oracle Cloud Connector Database
Navigator
Create a File
Delete a File
Administrator
System Administrator Options
System Administrator User Options
System Administrator Delimiter Options
System Administrator Configuration Options
System Administrator Server Information
About
Exit
Help and Shortcuts
Excel Error
GL Wand
Ledger and Segment Selector
Discover
Discover Period Names
Discover Segment Properties
Expand and Explode
Expand Segment Values
Expand Segment Value Hierarchy
Explode Segment Values
Explode Segment Value Hierarchy
Discover Segment Values
Discover Level
List of Values
List of Values – Create
Insert GL Wand Function
Financial Category
Period Name by Date
Period Start Date
Period End Date
Segment Tree
Get Balance
Multiple Ledgers
Get Balance Options
Get Average Balance Summary
Functional Currency
Segment Start Date
Enabled Flag
Ledger Name
Account Type
Segment End Date
Segment Description
Previous Segment Value
Period Offset
Period Name
Parent Flag
Next Segment Value
Ledger Set
Calculating
Execute Drilldown
Analyze Balances
Drill to Journal or Subledger
Drill Using a Saved Template
Drill Criteria Sheets
Drill Criteria – Journal Extract
Drill Criteria – Balance
Customize Drilldown
Edit Template Layout
Save Template Layout
Manage Templates
GL Wand Tools
Other Tools
Create a Template
Template Storage Requirement
Edit a Template
Delete a Template
Hide Zeros
GL Wand User Options
Report Distribution Manager
Create RDM Template
Advanced Options
Email
Drilldowns
Parameters
Source Report
Named Ranges
Edit RDM Template
Execute Report Distribution Manager
Execution
Load and Validation
Scheduler
Running the Scheduler
Create Schedule
RDM User Options
SMTP Email Settings
chat icon - ignore
Live Chat
Chat Offline

Execution

Play Video

After the Report Distribution Manager (RDM) template has completed the Load and Validation stages, each source report is calculated using the specified parameters. The combinations of all parameters are called permutations and an output report is generated for each permutation. Execution progress is shown as the count of the current report / all reports to be processed and current permutation / all permutations.

During the execution, RDM will search the source workbook for any Reports Wand templates, if found those templates will be Executed. Once Reports Wand templates are executed and any selected Drilldowns performed, RDM will perform a Workbook Refresh to calculate the entire workbook.

If an Email Client is configured in the RDM User Options screen and the email section of the RDM Job was configured, distribution of the output reports via email will be performed. If no distribution is required the output reports are saved in the output directory (if specified) or in the same directory as the source report. When the execution and distribution of all the selected jobs are completed, the job status is indicated by highlighting the specific spreadsheet cell and adding a comment to the cell:

  • Green indicates successful completion and the completion time is added to the cell comments.
  • Red indicates an execution or distribution exception, please review the cell note for more details on the exception.