Which Team Supports Each Cube

Description of Issue

Need to identify which software support team would assist with each cube

Context
  • Cubes

  • Excel

  • OLAP

  • SQL

Cause

Need to troubleshoot specific cubes and require the assistance of software support

Resolution

Below is a list of all cubes and which Software Support team troubleshoots them

  1. Accounts Receivable Cubes
    a.  AccountsReceivableCube - General Billing & Misc Cash Support

  2. Business License Cubes
    a.    Business License Cube - Tax/Revenue Support

  3. Fixed Assets Cubes
    a.    Fixed Assets Cube - Asset & Civic Support

  4. General Ledger Cubes
    a.    Budget Projections Cube - General Ledger Support
    b.    GLAssetsAndLiabilitiesCube - General Ledger Support
    c.    GLRevenueAndExpenseCube - General Ledger Support
    d.    StateReporting Cube - State Reporting Support

  5. Inventory Cubes
    a.    Inventory Cube - Asset & Civic Support

  6. Payroll HR Cubes
    a.    Employee Cube - Payroll Support
    b.    Position Cube - Payroll Support

  7. Permit and Code Enforcement Cubes
    a.    Code Enforcement Cube - Tax/Revenue Support
    b.    Inspection Cube - Tax/Revenue Support
    c.    Permit Cube - Tax/Revenue Support

  8. Project Accounting Cubes
    a.    Grant Cube - General Ledger Support
    b.    Project Accounting Cube - General Ledger Support

  9. Property Tax Cube
    a.    Property Tax Cube - Tax/Revenue Support

  10. Purchasing AP Cubes
    a.  Accounts Payable Cube - Purchasing Support
    b.  Contract Cube - Purchasing Support
    c.  Purchase Order Cube - Purchasing Support

  11. Utility Billing Cubes
    a.    UB Billing and Receivables Cube - Utility Billing Support
    b.    UB Consumption Cube - Utility Billing Support

  12. Work Orders Cube
    a.    Work Orders Cube - Asset & Civic Support

Additional Information

TSM can assist with generic Cubes configuration and when all Cubes jobs are failing