Reporting Functionalities

Q:What is BW/Business Warehouse, and how will it affect my agency's work?

A:Business Warehouse (BW) is SCEIS's central storage system for business data. At least daily, SCEIS will "warehouse" the data generated in that day's work, ensuring its stability, security and accessibility to all business areas.

The transactional system is called Enterprise Core Components (ECC). To ensure that data entry is efficient in ECC, analytical reports and reports using data from multiple modules will be produced from BW. Displays and lists (whether online or printed) are examples of items which will be available directly from ECC.

The Enterprise Reporting Team has gathered the requirements of STARS, First Wave agencies, and certain other reports. The Team is determining the strategy for producing and distributing the needed reports. More information will be posted when the Reporting Strategy is completed.

Q:How do I use Business Warehouse?

A:In many instances, you will not need to invoke Business Warehouse (BW) directly. Instead, it will run "in the background," as a resource for SCEIS transactions and reports. For custom data-access, you will learn to launch inquiries within Business Warehouse, generating data in Excel spreadsheets which you can manipulate in many ways.  

Q:What reports will I be able to generate within SCEIS?

A:Like other aspects of SCEIS, reporting is centrally driven, using data in ECC and in the Business Warehouse (BW). A library of report templates will assure that each agency can export the information it needs, whether for internal analysis or external reporting. Specific training will assure that users are knowledgeable about using those templates.

Q:How can I meet specialized reporting needs -- Federal reports, for instance?

A:Your daily work will enter data into the enterprise-wide ECC system and its Business Warehouse. For the most part, standard reports will provide the information required. The actual format may look a bit different from what you currently use; but the data you need will be in the report.

For custom reports, you will be able to query the system yourself to access the data you need.

The SCEIS Project Team continues to catalog the range of reports needed, to assure that you will be able to output the reports you need.

Q:Where does data reside?

A:Data for the SCEIS system is warehoused centrally, in servers at the State Chief Information Office. All users will access the data through network connections.

The SCEIS system is enterprise-wide -- statewide -- and highly integrated. That's a powerful advantage which reduces redundant data entry, duplicative record-keeping and operator error. For instance, when a vendor registers once in the SCEIS system, that company is available as a vendor to any state agency.

Information updates propagate daily throughout the system, allowing all users to work with the most current information.

Q:Who will have access to my agency's data?

A:Access to transactions, data, reports and all other elements of SAP are controlled through role-based authorizations. In short, if someone's job roles permit them to view your agency's data, or to carry out a transaction on behalf of your agency, their SAP security roles will allow them to do so. If they do not have those security authorizations, they will not see the data, and will not have access to the transaction codes.

This is true between agencies and within an agency. A purchasing clerk, for instance, will be able to view his or her own request for a purchase order, and will be able to see the when the request has been approved. But he or she will not be able to approve the request, and will not be able to view the payment history, unless that is allowed by other roles within his or her job description.