CEDARS Data Warehouse User Information

Registering for the CDW is a three-step process

  1. Ensure you have an NCID. (K-12 Public and Charter School employees are registered by the Charter/LEA NCID Administrator).
  2. Apply for an account using the CEDARS Data Warehouse Registration System. Use the tabs below to determine your User Role.
    1. Important:  The staff member requiring access to the system must complete the registration process themselves.
  3. After the account has been approved, log into the reporting interface (OBIEE).

Each LEA and charter must have at least one staff member who has been designated the Security Officer in the CEDARS Data Warehouse.  This staff member will be notified via email each time a user requests access and may then functionally approve or deny the registration request in the Registration system.  If there is no Security Officer at the local level the account will not be approved.

Please contact Terra Dominguez with questions.

Getting Started with the CDW

CDW User Roles

CDW User Roles

Each LEA and charter must have at least one staff member who has been designated the Security Officer in the CEDARS Data Warehouse. If there is no Security Officer at the local level the accounts will not be approved.

Users should select the single User Role with the highest level of permissions required.  Do not select more than one User Role.

Request Access to the CEDARS Data Warehouse

User Role

Aggregate Dashboards

(pre-created reports with no detail or PII data)

School Detail Dashboards

(pre-created reports that contain detail or PII Data for the given school )

LEA Detail Dashboards

(pre-created reports that contain detail or PII data for the given LEA)

Oracle Analysis

(access to all data elements with ability to create queries and reports)

School Level User Role
School Users Detail X X    
LEA/Charter Level User Roles
LEA/Charter Users Detail X X X  
LEA/Charter Detail Answers X X X X
LEA/Charter Security Officer X X X X
State Level User Roles
Report Writer X X X X
DPI Users Detail X X X X
DPI Super User X X X X

Request Access to the CEDARS Data Warehouse

Security Officer List

Security Officer List

Each LEA and charter must have at least one staff member who has been designated the Security Officer in the CEDARS Data Warehouse.  If no CEDARS Security Officer is assigned, staff will not be approved for access to the warehouse.

If no Security Officer is listed in the Security Officer Data Table, identify the appropriate staff member to complete the registration process for the Security Officer role.

Please contact Terra Dominguez with questions.

Security Officer Data Table created as of June 29, 2019

Who to Contact for Access to the CDW

Who to Contact for Access to the CDW

  1. LEA /  Charter users should contact their LEA/Charter CDW Security Officer with questions about access

  2. LEA / Charter Security Officers

    1. approve LEA and School level users
    2. contact the State level Security Officer with Security Officer changes
  3. State level Security Officer approves LEA / Charter Security Officer access requests

CDW User Documentation

CDW User Documentation

Document Description
Registering for the CEDARS Data Warehouse (QRD) 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 LEA / Charter Security Officers
User Role Code Mapping (QRD) Quick reference document for Security Officers that maps user role codes within a registration record to the User Role title in the registration system
Logging into the CEDARS Data Warehouse (QRD) Quick reference document with steps to log into the CDW
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
Beginning an Analysis in the CEDARS Data Warehouse (QRD) Quick reference document that describes how to being selecting data elements to create your own report in the CDW
Viewing the Results of an Analysis in the CEDARS Data Warehouse (QRD) Quick reference document that describes how to view the results of an Analysis in CDW
Saving Content in the CEDARS Data Warehouse (QRD) Quick reference document with steps for saving content in the CDW
Creating Filters and Prompts in the CEDARS Data Warehouse (QRD) Quick reference document that describes how to use filters to limit data returned from an Analysis and how to create dynamic filters using prompts in the CDW
Creating My Dashboards in the CEDARS Data Warehouse (QRD) Quick reference document with steps to create personalized dashboards 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 in order to create their own reports in the CDW
 
CEDARS Data Dictionary This 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.