OBIEE Update for October 2018

October 9, 2018

This update relates to the non-student Accounts Receivables, CAPS, Cash Management, Chart of Accounts, CSMA, Financials, Grants Management, Procure to Pay, Travel & Expense, and User Security folders.

OBI “By the Numbers” for September 2018

  • 98.9%: Percentage of queries that completed in 1 minute or under
  • 1,272: Number of distinct users in OBI for ALL subject areas
  • 135,178: Number of distinct requests made in ALL subject areas
    • The “Transaction Listing All” dashboard alone continues to make up almost half of all the requests at the university (65,551 requests)

Monthly OBI Release

Data Management Services (DMS) is pleased to announce that the next monthly OBI release will begin on Thursday, October 25th at 6pm.  All changes will be implemented and the release complete by 9am on Friday, October 26th.  Check out the newly updated OBI 3 Month Release Plan and Backlog wiki page for details of the dashboard changes in this release.

OBI Drop-In Session

The upcoming Drop In session is Friday, October, 12th from 11am – 12pm.  This 1-hour sessions is designed for you to get 1-on-1 help with OBI: answering questions, saving displays as customizations, etc. You can attend in person at 8 Story Street, Room B2, Cambridge or virtually via WebEx.  To insure that we have adequate resources available at these sessions, we are asking for you to register for the session if you plan to attend. You can register HERE.

Update on Service Unavailable Error Messages

OBI users continue to receive the Service Unavailable messages. While we know the errors are still occurring, the complexity of the underlying architecture has made it very difficult for Oracle to pinpoint the exact cause of the issue. DMS is in the process of sourcing additional consulting support to perform a detailed assessment of the OBI environment and identify the solution to solve this problem.

There is a workaround for this issue which you can find in a Knowledge Base article entitled “OBI FAQ: I have received a “Service Unavailable” Message when I try to use OBI.  What should I do?”

We’re continuing to work diligently with Oracle in searching for a resolution to this issue. We realize this is frustrating for many of our users, and appreciate your patience.

Quick Tip: Focus on Budget Dashboards

As budget season is upon us, here some tips about three dashboards in OBI that may be helpful to you as you prepare for the upcoming fiscal year:

Budget and Actual Comparison: This dashboard is available in two versions: the regular Budget and Actual Comparison dashboard and the Limited Comp version.  Here are some key points to keep in mind when using this dashboard:

  • Only Expense and Revenue object codes (T400, T600, and T901) are displayed on the dashboard.
  • Only Operating and Forecast Budgets are available on the dashboard.
  • The Forecast Budget displays Q2 Forecast from HUBS and will only display data if your school/unit uses HUBS for forecasting.
  • The right-click menus are different on each dashboard page, and contains helpful additions based on context—e.g., you can add both Subactivity and Subactivity Description on the Activity and Object Tab.

GL Account Monitoring: This dashboard’s second page contains GL Actual and Budget Balances, which can be useful to help you see how your department(s) are currently spending versus what was budgeted for the current year or compared to the previous year.  Here some additional key points about this dashboard:

  • The Budget Annual Amount column displays the annualized budget amount. The column will display the full budget for the fiscal year, regardless of the period selected in the prompts.
  • The Starting Balance for the Fiscal Year can be selected via the right-click.
  • The dashboard will only return results if the “Period From” prompt selection is prior than the “To Period” prompt selection.
  • The “Period From” and “Period To” prompts should be within the same fiscal year—if you wish to retrieve results for multiple years, you will need to run separate reports for each fiscal year.
  • Accounts that have a $0 or null amount for all data columns included in the dashboard page are excluded.

Budget by Major Fund Groups: This dashboard facilitates the analysis of high-level funding sources, ensures the application of the portfolio is planning for appropriately, and monitors actuals again the plan to help identify and manage variances.  Some additional points about this dashboard include:

  • The dashboard organizes the display of funds in a customized hierarchy that is used for reporting purposes only, meaning that the hierarchy is not found in the Chart of Accounts.  Click on the Need Help link on the dashboard to view the dashboard's wiki page and access the Fund Hierarchy document for more information on how those funds are organized.  The hierarchy on the display is also fully explained in the dashboard's video.
  • The dashboard defines all funds as all operating funds plus all non-operating funds.
  • The dashboard defines all operating funds as all unrestricted plus all sponsored plus restricted gifts plus restricted endowments.

Committed Funds: This dashboard is used to track open purchasing/payables activity that has been committed but not yet posted to the General Ledger.  This can be an important dashboard to consult during budget season in order to see the full spending picture.  Some additional points about this dashboard include:

  • The Committed Funds dashboard only displays PO lines with an Open status.  Once a PO line has been closed, it falls off of this dashboard.
  • When you look at a GL report and see you have a remaining budget of $2000 you may not have the complete picture.  The committed funds dashboard will display outstanding commitments to a vendor.  If you have $500 in committed funds then what you really have left to spend is $1500 ($2000 remaining budget on GL report less $500 in open commitments).
  • Because the Committed Funds dashboard only pulls “open” PO lines, there are occasions where the PO is closed, but the invoice is on hold.  These transactions do not appear on the Committed Funds dashboard AND are not posted to the GL. Thus, it is important to review transactions on hold to have the complete picture.

Additional Resources for OBI

See also: Live, OBIEE, October 2018