Power BI Contract Lists & Codes Relationships
Jump to a specific section by clicking a link
Overview | Samples | Variables | Alert Functionality | Power BI Reporting | Related Alerts | Webinar
Click to Subscribe and Download Template
Overview
Overview
This Power BI report allows you to view, compare and validate the codes on your 'active' contracts. Compare which GL accounts are associated to contract bill/overage codes by type, model, equipment, customer, etc). Compare base & overage rates for similar models across contracts. Compare escalation rates on contracts and meter groups. Identify machines with meters on an active contract. Compare coverage codes (includes, excludes, etc)
ID737 is one of a series of power bi reports (ID700, ID737, ID810, ID816) designed to review how your eAutomate database is setup, whether a single DB or looking across multiple DBs.
Type of Output: On Demand Report Power BI Report
Schedule: Data Refreshes from our tables ONLY on Monday's
* * *
Sample
Sample
* * *
Variables
Variables
N/A
* * *
Alert Functionality
Alert Functionality
-See here for getting Power BI in place.
-Click here to download the file
For ECi Hosted clients: We are working with ECi to open up our access so we can set an ODBC connection for you. If you are interested, then please provide us the public static IP address for your company network so that ECi can whitelist it to allow us access.
The data from our table will only update once per week on Monday's from CEO Juice. There is just too much data being processed that we risk bogging down your server running frequently. This means that even if your Power BI Report and Dashboard update daily, the data will only reflect changes once per week.
The series of Power Bi reports (ID700, ID737, ID810, ID816) are designed to review how your eAuto database is setup, whether a single DB or looking across multiple DBs.
- ID737 allows you to view, compare, validate the characteristics on your 'active' contracts.
- Compare which GL accounts are associated to contract bill/overage codes by type, model, equipment, customer, etc)
- Compare base & overage rates for similar models across contracts
- Compare escalation rates on contracts and meter groups
- Identify machines with meters on an active contract (with metergroups) but the machine's meters are not in any metergroup
- Filter/work/compare over 300 user selectable datapoints
* * *
Power BI Reporting
Power BI Reporting
* * *
Related Alerts
Related Alerts
ID700 - Power BI for Customers & Vendors relationship setup *This is required and must be subscribed to if turning on ID737*
ID810 - Power BI for General ledger, List & Codes relationship setup
ID816 - Power BI for Items, List & Codes relationship setup
See full list of all Power BI reports that we currently have available
https://support.ceojuice.com/hc/en-us/sections/360011259132-Power-BI-Reports
* * *
Webinar
Webinar
0 Comments