AFAOC Shares Air Force Status of Funds Using Power BI

The AFAOC, in coordination with the DEAMS FMO, has created a BETA version of cloud reporting capability based on an Integrated Status of Funds (e.g. DEAMS and Legacy data).

  • This reporting tool will serve as a stopgap while the DEAMS System Integrator continues to work towards resolving issues with the Status of Funds reports in DEAMS Reports.
  • Please follow hyperlink to access this report and be sure to enter your “us.af.mil” email address if prompted

Instructions:

Once at the site:

  • Click on Data Download
  • Filter Required Data (OAC, OE, Main_Limit, etc)
    • Saves the filter criteria for future reports – YEAH!!!!)
  • Click the big downward arrow in the gray box
    • Click on More Options
    • Click Export Data (if you want to use Excel)

Note: Chad Kukorola and James Johnson are amongst some of the smartest data-wonks I know. I bounce and share ideas with Chad on a semi-regular basis. I am going to highlight some of the great tools he’s built as a Air National Guardsman. If you know other “dataheads”, please share in the comments. I’m trying to compile a list and create an email listserve to share ideas and coordinate our efforts.

There will be a lot of additional Power BI info coming in the near future.

CRIS Migrating to the Cloud Soon

CRIS will be moving to the cloud on or about 10 Feb 2020. While we prepare to make our final move to the cloud, please be aware that any changes made to queries not saved to the local PC after 4 Feb 2020 will not be saved to you CRIS profile.  We need approximately 4 days to migrate the data to the cloud so any changes or new queries created after 4 Feb 2020 will not be available in your cloud profile. Any new or modified queries you need after 4 Feb 2020 should be saved to your local computer for later upload to the cloud.

If all goes well, you will automatically be redirected to the cloud instance of CRIS on 10 February.  You may notice some minor differences in the cloud.  The biggest one will be authentication through the CCE.  After ~15 minutes of inactivity, your ‘token’ will expire and you will need to log back in to CRIS (refresh your IE).  Yes, you will still need to use internet explorer for several more months.

Direct questions to:

AFAOC FM Systems Help Desk

Phone: 937.257.3117 or DSN:  787.3117

Email: saf.fmpaffso.customerservice@us.af.mil

Hours: M-F 0700-1700

Source: CRIS FMO

As of Date: 4 February 2020