Contents
- Title and Copyright Information
- Preface
- 1 Introduction
- 2 Subject Areas
- Overview
- OTBI Performance Real Time
- OTBI Usage Real Time
- Public Sector Cloud - Case Inspections Real Time
- Public Sector Cloud - Code Enforcement Case Real Time
- Public Sector Cloud - Permit Inspection Activity Real Time
- Public Sector Cloud - Permits Real Time
- Public Sector Cloud - Plan Review Real Time
- Public Sector Cloud - Planning Application Real Time
- Public Sector Cloud - Projects Real Time
- Public Sector Cloud - Property History Real Time
- Public Sector Cloud - Property Real Time
- Public Sector Cloud - Receipts Real Time
- Public Sector Cloud - Workflow Activities Real Time
- Security - Audit Real Time
- Security - Roles and Privileges Real Time
- 3 Business Questions
- Overview
- What is the most common inspection outcome for incidents and cases?
- What is the average number of inspections that were scheduled and completed during a given period?
- How many inspections were carried out by the code officers?
- What are the primary reasons for major code case violations?
- How many code cases were reported in a given period, by issue type?
- What is the monthly trend of reported incidents?
- How many citations are there compared to the same period last year?
- What are the primary reasons for major inspection violations?
- What is the workload distribution across all inspectors in a given period?
- What is the total inspection activity for an inspection type?
- What is the total demand for inspections in a given period?
- What is the total permit activity for a permit type in a given period?
- What is the total valuation and assessed fee of permit activity?
- What is the busiest time for permit applications?
- When does the agency issue the most permits?
- What is the distribution of permits across different permit statuses?
- How long are plan review cycles on average?
- How many plan review cycles are needed for a permit application on average?
- What is the distribution of plan review cycles across plan reviewers in a given period?
- How many plan reviews had override decisions?
- What is the total application activity for a planning entitlement type?
- What is the total valuation and assessed fee for a planning application?
- What is the average planning application processing time?
- What is the distribution of planning applications across different planning application statuses?
- What are the property land value changes in a given period?
- What are the net asset value changes in a given period?
- What are the property classifications by zone?
- What are the property valuations by district?
- What is the total activity for fees?
- What is the total payment by fee type?
- How much in fees was received in a quarter?
- Which projects were started in a specified timeframe?
- What transactions are associated with a project?
- What are the inspections carried out for a project?
- How much time elapsed between statuses in the workflow process?
- How much time elapsed between permit issuance and final inspection?
- What is the average number of workflow tasks by permit type?
- How many withdrawals were there in a given period?
- How many times did the agency staff alter the workflow during a given period?
- How many users run OTBI analyses?
- Who are the top N OTBI users?
- What is the weekly OTBI analysis usage trend?
- What are the top N most frequently-run OTBI analyses?
- How many predefined OTBI analyses have been run in the past month?
- How many custom OTBI analyses have been run in the past month?
- How many ad-hoc OTBI analyses have been run in the past month?
- What is the execution history of dashboard X in the past month?
- Which analyses have low usage in the past month?
- How many OTBI SOAP web services have been run in the past month?
- What are the long-running analyses in the past month?
- What is the OTBI execution time histogram in the past month?
- Which analyses have the longest response time?
- Which analyses have high data row count?
- Which analyses reached OTBI max row limit?
- What are the common execution errors in the past month?
- How many analyses and dashboards failed in the past month?
- What are the most commonly used OTBI subject areas?
- What are the least-used OTBI subject areas?
- Which subject areas have slow performance?
- Which subject areas have large data volume?
- Which analyses have low usage because of poor performance?
- What is the database SQL execution time and row count?
- Why am I not able to view certain subject areas with my login credentials?
- Which data security policy would provide access to the data I need to see?
- Can I view and edit a particular page? If yes, which functional security policy do I need to provide to a user who needs similar access?
- I have not added a specific role to a user, but the user seem to have this job role. Can I trace how has this been inherited by the user?
- What are all the data security privileges that a specific user added?
- Which roles were added with a specific functional security policy, and who added them?
- 4 Job Roles
- Overview
- Application Implementation Consultant
- IT Security Manager
- PSC Associate Planner
- PSC Building Inspector
- PSC Business Analyst
- PSC Chief Building Officer
- PSC Code Enforcement Application Administrator
- PSC Code Enforcement Officer
- PSC Code Enforcement Supervisor
- PSC Code Enforcement Technician
- PSC Economic Development Officer
- PSC Finance Administrator
- PSC Inspections Supervisor
- PSC Permit Technician
- PSC Permits Application Administrator
- PSC Permits Supervisor
- PSC Plan Reviewer
- PSC Planning Assistant
- PSC Planning Coordinator
- PSC Planning and Zoning Application Administrator
- PSC Principal Planner
- PSC System Administrator
- PSC Zoning Administrator
- 5 Duty Roles
- Overview
- OTBI Report Performance Transactional Analysis Duty
- OTBI Report Usage Transactional Analysis Duty
- PSC Agency Code Case Inquiry Duty
- PSC Agency Code Case Inspections Inquiry Duty
- Public Sector Agency Inspections Transaction Analysis Duty
- Public Sector Agency Planning Application Transaction Analysis Duty
- Public Sector Agency Projects Transaction Analysis Duty
- Public Sector Agency Receipts Transaction Analysis Duty
- Public Sector Agency Workflow Transaction Analysis Duty
- Public Sector Permits Transaction Analysis Duty
- Public Sector Plan Review Transaction Analysis Duty
- Public Sector Property Transaction Analysis Duty
- Security Transaction Analysis Duty