Contact Us
Index
Version 5.0
Version 5.1 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.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 Version 25.4 Version 26.1 Version 26.2 Version 26.3
Contact Us
Wands for SAP 5.0 – Home
Wands
Logging On
New Release Notification
Company Code Selection
User Profile
Excel Not Ready Error
Add-In Load Error
Multiple Instances
License Key
License Key Errors
Wands Tools
Snapshot
Shared Templates Drive
Drive Types
File Server
SAP Database
Dropbox
Navigator
Create a File
Delete a File
Edit a File
Open a File
Common Options
Insert Wands Function
Combine Text
Last Refreshed By
Last Refreshed Time
Split Text
Administrator
System Administrator Options
System Administrator Licence Key
System Administrator User Permissions
System Administrator User Options
System Administrator Server Information
System Administrator Delimiter Options
System Administrator Configuration Options
About
Exit
Errors and Troubleshooting
Help and Shortcuts
Excel Error
GL Wand
Discover
Expand and Explode Level
Discover FICO Object Values
Expand and Explode
Expand FICO Object Values
Explode FICO Object Values
Explode FICO Object Value Hierarchy
Expand FICO Object Value Hierarchy
List of Values
List of Values – Create
Company Code and FICO Object Selector
Insert GL Wand Function
Previous FICO Object
Next FICO Object
Get Balance
Get CCA Balance
Get New GL Balance
Get Classic GL Balance
Get PCA Balance
Company Code Name
Alternative GL Account
FICO Object Description
Calculating
Execute Drilldown
Drill Criteria Sheets
Drill Criteria – Classic GL Balance
Drill Criteria – New GL Balance
Drill Criteria – PCA Balance
Drill Criteria – CCA Balance
Drill Using a Saved Template
Drill to Document
Drill to Line Item
Customize Drilldown
Template Layout
Save Template Layout
Manage Templates
GL Wand Tools
Other Tools
Hide Zeros
Clean Template
Configuration Sheet
GL Wand User Options
Planning Wand
Load Option Selector
Loading Plans
Insert Planning Wand Function
Load CCA
Report Distribution Manager
Scheduler
Create Schedule
Running the Scheduler
RDM User Options
SMTP Email Settings
Create RDM Template
Source Report
Named Ranges
Parameters
Drilldowns
Email
Advanced Options
Edit RDM Template
Execute Report Distribution Manager
Load and Validation
Execution
chat icon - ignore
Live Chat
Chat Offline

System Administrator User Permissions

For a user to be able to access and Wands application you must perform the following steps:

  1. Assign the Wands role to the users’ SAP user name. The new role will be created during the installation process.
  2. As an Wands system administrator, launch the application and navigate to the following option in Excel: Wands | Admin Options | User Permissions.
  3. Follow the instructions below to assign products to your SAP users.

Assign the available licenses to SAP users. Use the filter box to find a specific user. You can sort the table by any column, for example, click the GL Wand heading and all the users that have the GL Wand product ticked will sort to the top.

Exporting User Information

You can save the user list to Excel using the Export button. If you filter the list, only the currently filtered items will be exported. If you wish to export only users that have a product assigned, simply choose the Hide Unlicensed predefined filter by clicking the filter button.

Importing User Information

Once you have exported a list of users you can use that template to modify your users as follows:

  • Add new user ids to the list.
  • Add permissions by entering an X in the correct product or permission column.
  • Remove permissions be clearing the X from the applicable product or permission column.

Once you have made the changes, ensure that the user permissions Excel worksheet is active and open the System Administrator Options dialog. On the User Permissions tab, click the Import button. Review your changes and click save to apply them to the SAP system.


Do not modify the structure of the user permissions Excel worksheet in any way