Title: ARTABI Tools
1ART/ABI Tools
- Presented byHoward Campbell, Jr.
2ARTAccount 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
3ARTAccount 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
4ARTAccount 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
5ART Post Production Statistics
As of April 30, 2007
6ART Post Production Statistics
As of April 30, 2007
7ARTAccount 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
8ARTAccount 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
9ARTAccount 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
10ARTAccount 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
11ABIAbnormal 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
12ABIAbnormal 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
13ABIAbnormal 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
14ABIAbnormal 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