CEDARS Data Warehouse User Information Getting Started with the CDW Registration and Security Administration CDW User Documentation Access Request Workflow All PSUs must have a Security Officer to grant access to users at the local level. If there is no Security Officer at the local level the accounts will not be approved. State level and PSU Security Officer access requests are granted by the state level Security Officer. Staff who request the role of Security Officer must also select a secondary role to access the OBIEE reporting system. All other users need only select the user role with the highest level of permissions. If your registration request remains unaddressed, review the PSU Security Officer list. If no contact is listed, identify the appropriate staff member to complete the registration process for the Security Officer role. If the contact listed no longer peforms this duty, email Terra Dominguez to disable the account. Security Officer Data Table updated as of October 20, 2020 Registration Process Important: The staff member requiring access to the system must complete the registration process themselves. Ensure you have an NCID. (K-12 Public and Charter School employees are registered by the Charter/LEA NCID Administrator). Apply for an account using the CEDARS Data Warehouse Registration System. Use the Registering for the CEDARS Data Warehouse document to determine the appropriate User Role. After the account has been approved, log into the CDW. CDW Registration Link and Support Documents Item Description CEDARS Data Warehouse Registration System Link to CDW Registration System Registering for the CEDARS Data Warehouse Quick reference document that identifies user roles and the functional process of registering for the access to the warehouse Security Administration Guide for the CEDARS Data Warehouse Full reference document for State and PSU Security Officers To better understand user roles and how to gain acces to the CDW, click the Registration and Security Administration tab. CDW Link and Support Documents Item Description CDW reporting system (OBIEE). Link to the CEDARS Data Warehouse (CDW) reporting interface, OBIEE. Important: If your NCID contains an ampersand ('&') in the password, OBIEE will error. Update your NCID, excluding the ampersand. Creating Reports in the CEDARS Data Warehouse Full reference document that describes how to create basic and advanced reports in the CDW. CEDARS Data Dictionary The CEDARS data dictionary is a resource for using OBIEE to generate reports from the CEDARS data warehouse, the NC DPI longitudinal data system. As such, the structure of this document aligns with the structure inside the OBIEE presentation layer, which is the layer that is exposed to the OBIEE user community Viewing Pre-created Dashboards in the CEDARS Data Warehouse (QRD) Quick reference document that describes how to navigate pre-created dashboard reports in the CDW Introduction to the CEDARS Data Warehouse (ppt) PowerPoint that describes basic information about the CDW Understanding Subject Areas in the CEDARS Data Warehouse (ppt) PowerPoint for users that need to understand what data are available when creating their own reports in the CDW
CEDARS Data Warehouse User Information Getting Started with the CDW Registration and Security Administration CDW User Documentation Access Request Workflow All PSUs must have a Security Officer to grant access to users at the local level. If there is no Security Officer at the local level the accounts will not be approved. State level and PSU Security Officer access requests are granted by the state level Security Officer. Staff who request the role of Security Officer must also select a secondary role to access the OBIEE reporting system. All other users need only select the user role with the highest level of permissions. If your registration request remains unaddressed, review the PSU Security Officer list. If no contact is listed, identify the appropriate staff member to complete the registration process for the Security Officer role. If the contact listed no longer peforms this duty, email Terra Dominguez to disable the account. Security Officer Data Table updated as of October 20, 2020 Registration Process Important: The staff member requiring access to the system must complete the registration process themselves. Ensure you have an NCID. (K-12 Public and Charter School employees are registered by the Charter/LEA NCID Administrator). Apply for an account using the CEDARS Data Warehouse Registration System. Use the Registering for the CEDARS Data Warehouse document to determine the appropriate User Role. After the account has been approved, log into the CDW. CDW Registration Link and Support Documents Item Description CEDARS Data Warehouse Registration System Link to CDW Registration System Registering for the CEDARS Data Warehouse Quick reference document that identifies user roles and the functional process of registering for the access to the warehouse Security Administration Guide for the CEDARS Data Warehouse Full reference document for State and PSU Security Officers To better understand user roles and how to gain acces to the CDW, click the Registration and Security Administration tab. CDW Link and Support Documents Item Description CDW reporting system (OBIEE). Link to the CEDARS Data Warehouse (CDW) reporting interface, OBIEE. Important: If your NCID contains an ampersand ('&') in the password, OBIEE will error. Update your NCID, excluding the ampersand. Creating Reports in the CEDARS Data Warehouse Full reference document that describes how to create basic and advanced reports in the CDW. CEDARS Data Dictionary The CEDARS data dictionary is a resource for using OBIEE to generate reports from the CEDARS data warehouse, the NC DPI longitudinal data system. As such, the structure of this document aligns with the structure inside the OBIEE presentation layer, which is the layer that is exposed to the OBIEE user community Viewing Pre-created Dashboards in the CEDARS Data Warehouse (QRD) Quick reference document that describes how to navigate pre-created dashboard reports in the CDW Introduction to the CEDARS Data Warehouse (ppt) PowerPoint that describes basic information about the CDW Understanding Subject Areas in the CEDARS Data Warehouse (ppt) PowerPoint for users that need to understand what data are available when creating their own reports in the CDW
