ARTABI Tools - PowerPoint PPT Presentation

1 / 14
About This Presentation
Title:

ARTABI Tools

Description:

When sound financial management is practiced, certain account ... Technical/Functional Questions. Selena.Lee_at_USDA.GOV. 202-619-7631. Mike.Smith_at_USDA.GOV ... – PowerPoint PPT presentation

Number of Views:33
Avg rating:3.0/5.0
Slides: 15
Provided by: ljones7
Category:
Tags: artabi | selena | tools

less

Transcript and Presenter's Notes

Title: ARTABI Tools


1
ART/ABI Tools
  • Presented byHoward Campbell, Jr.

2
ARTAccount Relationship Tool Defined
  • A standard, Department-wide analytical tool for
  • Monitoring general ledger account relationships
  • Identifying relationship imbalances as they occur
  • Encouraging timely corrective action
  • When sound financial management is practiced,
    certain account relationships should exist
  • Budgetary Relationships
  • Proprietary Relationships
  • Budgetary vs. Proprietary Relationships
  • Attribute-based Relationships

3
ARTAccount Relationship Tool History
  • FY 2004
  • Consolidated Financial Statement Audit Material
    Weaknesses identified in the area of account
    relationship management
  • FY 2005
  • System enhancements made to incorporate
    additional detail required for ART tool
  • ART tool prototype demonstrated at Financial
    Management Training
  • FY 2006
  • ART tool placed in production
  • ART tool training in Washington DC, Riverdale MD,
    Kansas City MO, St. Louis MO and Albuquerque NM
  • FY 2007
  • Four relationships become part of A-123 process
    for Financial Reporting Branch (FRB), in New
    Orleans

4
ARTAccount Relationship Tool Data Sources
  • Financial Statements Data Warehouse (FSDW)
  • Primary data source
  • Consolidated, summarized repository of all
    Agencies financial data
  • Leveraged crosswalk functionality used for
    financial statements
  • Pre-defined drill path
  • Enhanced to include additional detail
  • Agencies Financial Data Warehouses (FDWs)
  • Drill to details not available in the FSDW
  • Uses limits set by pre-defined FSDW drill path

5
ART Post Production Statistics
As of April 30, 2007
6
ART Post Production Statistics
As of April 30, 2007
7
ARTAccount Relationship Tool Access
  • Access levels
  • Department Analyst Access multiple Agencies
  • Agency View or Relationship View, FDW drill-down
    and Analyze feature
  • Department User - Access multiple Agencies
  • Agency View or Relationship View, and FDW
    drill-down
  • Agency analyst Access single Agency
  • Agency View, FDW drill-down and Analyze feature
  • Agency User Access single Agency
  • Agency View and FDW drill-down
  • Basic User Access single Agency
  • Agency View

8
ARTAccount Relationship Tool Access
  • Requesting security access
  • Submit form AD-1143 to
  • Malik.Conway_at_USDA.GOV
  • 202-205-5359
  • 202-720-5741 (Fax)
  • Place Agency(s) serviced and access level in
    Special Instructions block (32)
  • Access ART tool via the FDW website
  • http//fdw.ocfo.usda.gov

9
ARTAccount Relationship Tool Open Discussion
  • Known Challenge(s)
  • Inconsistent Brio versions Department-wide
  • ART tool developed using version 6.6
  • Older versions can not run ART
  • Newer versions do not maintain full functionality
  • Known Enhancement(s)
  • Department-wide Brio upgrade
  • Hyperion Business Intelligence Suite 8, or
    greater
  • Web-based, thin-client environment
  • Will mitigate software version issues
  • User Comments/Feedback/Suggestions

10
ARTAccount Relationship Tool Contact Information
  • Relationship/Crosswalk Questions
  • Sheryl.Davenport_at_USDA.GOV
  • 504-426-5123
  • Howard.Campbell_at_USDA.GOV
  • 202-720-7975
  • Security Access Questions
  • Malik.Conway_at_USDA.GOV
  • 202-205-5359
  • Technical/Functional Questions
  • Selena.Lee_at_USDA.GOV
  • 202-619-7631
  • Mike.Smith_at_USDA.GOV
  • 202-619-7633

11
ABIAbnormal Balance Indicator Defined
  • A standard, Department-wide analytical tool for
  • Monitoring general ledger account balances
  • Identifying abnormal balances as they occur
  • Encouraging timely corrective action

12
ABIAbnormal Balance Indicator Concept
  • Leverage methodologies used in the ART tool
  • Use the FSDW as primary data source
  • Use similar standard, pre-defined drill path
  • Enable similar drill-down capability, for
    acquiring necessary details from the FDW

13
ABIAbnormal Balance Indicator Open Discussion
  • Known Challenge(s)
  • Account summary level
  • USSGL vs. FFIS-GLAC
  • Capturing agency explanations
  • Known Enhancement(s)
  • Department-wide Brio upgrade
  • Hyperion Business Intelligence Suite 8, or
    greater
  • Web-based, thin-client environment
  • Will mitigate software version issues
  • User Comments/Feedback/Suggestions

14
ABIAbnormal Balance Indicator Contact Information
  • Lucy.Luo_at_USDA.GOV
  • 202-720-4958
  • Ronald.Degiuli_at_USDA.GOV
  • 202-720-1888
  • Malik.Conway_at_USDA.GOV
  • 202-205-5359
  • Howard.Campbell_at_USDA.GOV
  • 202-720-7975
Write a Comment
User Comments (0)
About PowerShow.com