1 / 17

FMMI BI Reporting Tips & Tricks

FMMI BI Reporting Tips & Tricks. USDA-APHIS Created May 2013 *Users should review the slide notes for instructions and guidance*. FMMI BI Reporting Tips & Tricks. Selection Screen - How to search using Filters like 25* for Commitment Items

marika
Download Presentation

FMMI BI Reporting Tips & Tricks

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. FMMI BI Reporting Tips & Tricks USDA-APHIS Created May 2013 *Users should review the slide notes for instructions and guidance*

  2. FMMI BI Reporting Tips & Tricks • Selection Screen - How to search using Filters like 25* for Commitment Items • How to use Ranges like 2500 – 2599 for Commitment Items • How to save selection variants, so they can be used again and save your work • How to remove USDA using Properties > Characteristics > Key (not compounded) • How to subtotal using Properties > Characteristics > Results > Always • How to Filter to reduce the results • How to go back one navigation step • How to change selection Variables from the Results screen • How to save a layout • How to open a saved report from BI Favorites

  3. Logging into FMMIhttp://info.fmmi.usda.gov/ This is the FMMI Portal, this is the first screen that users see once they log into FMMI. Using the toolbar or ribbon above users navigate through the system to gain access to reports or transactions based on the FMMI Module.

  4. Reporting – Variable Entry Screen

  5. Reporting – Selection Screen For this example we will learn how search for Commitment Items (BOC’s) using Wildcards, Like 25* to search for commitment Items from 2500 to 2599. First the user will click on the small boxes on the right of the current selection box. This will bring up a sub-menu where the user can make further selections.

  6. Sub-Menu – Using the Wildcard

  7. Sub-Menu – Using the Value Range

  8. Searching for Funds Center

  9. Saving a Variant

  10. Modifying the Report Details

  11. Sub-Menu Properties

  12. Filtering

  13. Going back a Step

  14. Changing your report variables

  15. Saving a Layout

  16. Accessing BI Favorites

  17. Retrieving a BI Favorite Report

More Related