EC Express: Filtering Reports
Posted by Matthew Heinz on 06 June 2012 11:04 AM
EnergyCAP reports offer dozens of available filters. Getting just the data you need is easy once you learn how to set the various filters.
1. Current Filters. These are the filters currently set for this report. To set a filter, click on it, set the Operator and Value, then Save. To remove the filter, click on it, then click Clear.
2. Additional Filters. Click on any item to add that filter to the report. The meaning of some filters may not be obvious. Every EnergyCAP report (including some that may not be available to you) and every filter are described here: http://www.energycap.com/support/sample-report-viewer
3. Recommended filters. Green filters are recommended. In this example, it is recommended that you filter the report to (1) one or more Billing Period months (to not do so would cause all bills to be included), (2) one or more commodities (this particular report is best run for a single commodity at a time), and (3) to one Topmost Place node on the Buildings & Meters tree. See below for an explanation of Topmost Place. In this case, you can use either the Topmost Place Code or Topmost Place Name, but never use both.
4. Operator. When you click on a filter, you can then set the Operator (Equals, Greater Than, Between, etc) and a Value.
5. Save. You must Save the filter before moving on to the next one.
6. Clear. Click Clear to remove a filter from the Current Filters list. Note: Green filters cannot be removed from the list, but clicking on Clear will remove the filter settings (in essence it sets that filter to "Allow All").
A user can be allowed to access all data, or can be limited to a "topmost" node in the Buildings & Meters tree. "Topmost" means that the user can view everything that falls directly under that node, but cannot access anything else. The Topmost Place node can be a single building, or it can be an organizational node such as a department, agency, business unit, campus, etc.
Consider the illustration below:
1. User 1 has no Topmost Place restriction. He can access all departments, all buildings, all meters.
2. User 2 has Topmost Place set to General Services Dept. She can see the eight buildings that fall directly under General Services, and all of their meters, but nothing else.
3. User 3 has Topmost Place set to the Central Administration building. He can access its two water meters, electric meter, gas meter and oil meter, but nothing else.