Attachment C-Commonwealth Response to Vendor Question Form RFI 758 2700000006 Enterprise Financial Reporting Discovery.xlsx
XLSX spreadsheet 13 KB Posted
- Attached to
- RFI SAS Enterprise Financial Reporting Discovery
- Solicitation number
- RFI 758 2700000006 3
- Issued by
- Elliott County, Kentucky
About this file
This is a Commonwealth of Kentucky response document to vendor questions submitted during the Request for Information (RFI) process for SAS Enterprise Financial Reporting Discovery. The document addresses inquiries raised by potential vendors regarding the scope, requirements, and specifications for implementing enterprise financial reporting capabilities. The RFI seeks to gather information about vendors' capabilities, approaches, and solutions for financial reporting discovery and system implementation. The document provides clarifications on technical requirements, implementation methodology, data integration needs, and vendor qualifications necessary to support Kentucky's financial reporting objectives. Responses to vendor questions are intended to ensure all interested parties have equal access to relevant information and can prepare informed submissions.
The response document clarifies various aspects of the Commonwealth's financial reporting requirements, including system functionality expectations, data source integration, reporting capabilities, and implementation timelines. The document addresses vendor inquiries regarding the current financial reporting environment, existing systems and data structures, technical specifications, resource requirements, and expected deliverables. Responses focus on providing transparency regarding the scope of work, allowing vendors to accurately assess their capability to meet Kentucky's enterprise financial reporting needs. This RFI response serves as an essential communication tool to facilitate vendor understanding and encourage qualified submissions from organizations capable of delivering comprehensive financial reporting solutions aligned with the Commonwealth's operational and compliance requirements.
View the file
Other files
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Answers
| Commonwealth Response to Vendors' Question Form | ||||
| Attachment C - RFI 758 2700000006 Enterprise Financial Reporting Discovery | ||||
| RFP Section / Requirement Number | Document | Document Page Number | Vendor Questions | Commonwealth Response |
| IV. Background / Solution Overview | RFI | 3-6 | Should the scope contemplated by this RFI be limited to the reporting and visualization layer, or could it also extend to the data warehouse, data model, ETL processes, and related integrations? If data warehouse and ETL modernization are potentially in scope, can the Commonwealth provide the name and details of the existing ETL tool(s) used to populate and refresh the data warehouse? | The Commonwealth is not looking to replace the data warehouse or the ETL Data model at this time. |
| Section IV - Background | RFI | 3 | Can the Commonwealth provide current data volumes and design (transaction counts, database size, data model) for the Oracle repository and data warehouse to help vendors size a proposed solution? | Current size of the database is 1.4 TB |
| Section IV - Background | RFI | 4 | The RFI notes certain reporting supports near-real-time access while most relies on overnight ETL. Which specific data domains or report types currently receive near-real-time access, and is that expected to expand in a future solution? | Specific data domains or report types are not available currently for the purpose of this RFI. All data whether real-time or overnight is available in 1 of 2 oracle databases. |
| Section IV - Background | RFI | 4 | Of the approximately 5,000 WebI documents, is there an estimate of how many fall into 'required and standardized' versus 'ad hoc and analytical' categories, and has any usage/retirement analysis (e.g., reports rarely or never run) already been performed? | Approximately 20% are required, while 80% would be considered ad hoc. The Commonwealth is currently reviewing usage of existing reports. |
| Section IV - Background | RFI | 4 | Are there other source systems besides the core ERP/Oracle environment (e.g., HR, procurement, grants) that reporting needs to integrate with today or in the future? | No. There are no other source systems that reporting needs to integrate. |
| Section IV - Objectives | RFI | 4 | Is the Commonwealth open to replacing the data warehouse layer itself, or is this RFI scoped specifically to the reporting/visualization layer sitting on top of the existing warehouse? | This RFI is focused on the visualization layer, and not replacing the data warehouse or the ETLs process. |
| Section IV.4 - Technical Architecture (GCC) | RFI | 6 | Given the Microsoft GCC requirement, is there a preference or requirement for standard GCC versus GCC High, and are there existing GCC tenants or contracts vendors should be aware of? | The Commonweatlh utilizes standard GCC. |
| Section IV - Background | RFI | 4 | Is Power BI's existing use, mentioned alongside WebI and dashboards, expected to be expanded, replaced, or retained as one option among several in the future state? | The Commonwealth intends to retain our existing Power BI reporting dashboard but would consider expanding its use. |
| Section IV - Background / IV.4 Technical Architecture | RFI | 4-5 | What specific dimensions define the current row-level and folder-level security model (e.g., fund, agency, cost center), and is a similar or more granular model expected in a new solution? | Row level security is currently dependent upon a department/organizational group. The Commonwealth doesn't anticipate making changes to current framework for security. |
| Section IV.4 - Technical Architecture | RFI | 5 | Are there existing enterprise identity/SSO standards (e.g., Azure AD/Entra ID) that a reporting solution must integrate with for the approximately 2,500 (or 4,000+, per Section IV.2) user accounts? | The Commonwealth supports most modern authentication mechanisms, the preferred method is Oauth. |
| Section IV - Background / IV.2 Solution Overview | RFI | 4-5 | Is there an expectation or requirement that legacy WebI content be migrated/converted to a new platform, or would users be expected to rebuild reports in the new environment? | There is no expectation for full redevelopment nor full conversion, but would seek best practices suggestions. |
| Section IV - Background | RFI | 4-5 | What volume and complexity of ad hoc, self-service, and high-volume data extraction/manipulation use cases should vendors plan for, beyond the named user population? | Ad Hoc and self-service reports are mostly low complexity, and account for approx. 80% of our report volume. |
| Section IV.3 - Reporting Capabilities | RFI | 5 | Are there specific statutory or regulatory reporting requirements (e.g., CAFR/ACFR, federal single audit, budget reporting) that impose hard formatting or submission constraints on the reporting solution? | No, not at this time. However, the Commonwealth continues to monitor evolving federal reporting requirements, including requirements related to machine-readable taxonomies, which may impact future reporting and data-formatting needs. |
| Section III - RFI Process | RFI | 2 | Will vendor questions and Commonwealth responses to Attachment B be published to all vendors via addendum, and is there a mechanism for vendors to submit follow-up questions after the September 16 addendum is issued? | See Addendum 1 and Attachment C-Commonwealth Response to Vendor Questions. There will be no further Q&A. |
| Section V - Response Format | RFI | 6-7 | Does the Commonwealth have a preferred format or page limit for RFI responses, given the extensive list of requested content (Firm Information, Qualifications, Solution Overview, etc.)? | No preferred format or page limit at this time. |
| Section II - Purpose / IV - Objectives | RFI | 1-2, 4 | Is the commonwealth looking for an individual technology vendor, or an implementation partner that can identify the best solution options based upon desired requirements? | The Commonwealth is open to exploring options. |
File details come from the government source that posted it. Updated .