CEOJuice has many on demand (manually run by you) reports that are run from a URL browser known as SSRS reports (SQL Reporting Services). These are different from the eautomate style crystal reports that are generated from inside e-automate. Therefore security for the SSRS reports needs to be tied back to an eAutomate user and requires a one-time setup.
If security has not been setup, you will receive an error similar to the below
If you get another error not related to security or page does not load, click here.
***
You need to assign a Custom Property on the e-auto Employee file
ZCJ_DomainUserID to any EA user who will need access to run any SSRS report.
Format: Domain\username (FYI no .com needed in domain name)
Company Domain: If you don't know your domain name, from the start menu choose my computer, right click and choose properties, you should see your domain name near the bottom.
Username = Windows LogIn Name
EA Login User ID must be linked in your employee record
NOTE: if you are installed in ECIs hosted environment, see THIS LINK for those specific setup instructions.
NO employee record should be linked to the user "Admin", the reports will return a security error. An employee must be linked to their EA user (and that user can be assigned admin rights if needed).
To verify what the windows assigned domain\username is have the user experiencing the security issue log into the SSRS reports and open ID908 which is a test SSRS report. In the lower-right corner of ID908 it will show the user's domain\username which is pulling from the windows credentials that your IT department set up for that user. Below is an example of where to find this.
Important Notes:
Important Notes:
1. SSRS Reports are accessed using your web browser.
2. All clients using SSRS Reports have ID708/SSRS User Rights listed under SSRS Reports. Please use this tool to confirm users are set up (per instructions below) and the corresponding e-auto permissions are granted to access varying SSRS Reports. Here is a typical error indicating a user needs set up:
3. We manage security by linking your Windows domain and username (domain\username) to your e-automate user ID. Users will need e-auto permissions to access the module's reports (i.e. Service Reports, Financial Reports). The name in brackets before the SSRS Report Name indicates which module.
4. Note: This simply links your e-automate rights to the SSRS report. If you don't have appropriate rights in e-automate, our report will not run. It will give you a message explaining rights needed. For example, the Contract MIF Report requires e-auto permissions to Service Reports:
Below is listing of e-auto permissions ("View" rights) needed for each of our SSRS Reports:
ID46/Warehouse Activity - Service Reports
ID150/Contract Profitability - GL Reports or Service Reports
ID204/Tech Productivity - Service Reports
ID205/Tech Time Log - Service Reports or GL Reports
ID206/CallBack Detail - Service Reports
ID207/Copy Details - Service Contract Reports
ID258 (ID36)/Customer Business Review - Service Contract Reports
ID412/Invoice Cost Center Breakdown - Service Contract Reports
ID500/Obsolete Inventory - Inventory Reports
ID557/Monthly Survey Results - Sales Analysis or Service Reports
ID587/Contracts Lost and Won - GL or Service Reports
ID674/Customer Service History - Service Contract Reports
ID683/MIF Sales Opportunity Value - Sales Order Reports
ID827/ Equipment Cover Sheet - Inventory reports, Service Contract Reports
ID877/Survey Responses - Service Contract Reports
ID900/Financial Performance Benchmarking - GL Reports
ID932/ITT Ship Out Agreement - Sales Analysis Reports
ID944/Service Call Metrics - Service Reports
ID945/Ship In Ship Out Dealers - Service Reports
ID950/Parts to Harvest from Model - Inventory Reports
Are you missing the Custom Property in e-automate?
Step 1: Go to Lists & Codes to create a new Attribute named ZCJDomainUserID (ensure Data type is Text Box):
Step 2:
Add this attribute as a Configuration to your Employee configuration:
0 Comments