Student data Warehouse dictionary
The U-M Data Warehouse is a collection of data that supports reporting activity for University business. The data is organized in data sets based on subject areas (e.g., Payroll, Student Records, Financials).
To run reports in the Data Warehouse data sets, you need access to:
Tables in the Data Warehouse
The Data Warehouse data sets are stored in tables in relational databases. The tables consist of columns (data elements) and rows. In the example to the right, the first column contains a list of EmplIDs. Each row contains data items for each program for a particular student. One student can have multiple rows if he or she has multiple programs.
Each table has one or more key fields, such as EmplID (Employee ID number), that uniquely identify each row in the data base. Tables are linked to each other by joins between fields.
Folders in BusinessObjects
In BusinessObjects, the Acad Prog table displays as a folder. Each data element (column) displays beneath the folder—in most cases, as a blue rectangle.
Note: Count of Emplid and Count of Unique Emplid are measure objects (orange ruler icon)—dynamic calculations that exist only within BusinessObjects.
Using Data Dictionaries
With BusinessObjects WebI, you can access data in the Data Warehouse, create your own reports, and modify existing ones.
However, if you don't understand how the data is structured, the links between tables, and which BusinessObjects folders to use, your report results may be incorrect. This is where the data dictionaries come in handy.
For each data set, the data dictionaries provide:
- Table diagrams which show how the tables are connected and the primary keys on which table joins are based
- A list of tables with their names and descriptions
- A data element dictionary that provides a description, data type (character, number, date), table location, security code (public, private/confidential, sensitive), and examples of valid values for each data element.
This information is useful when you want to add new information to your report but don’t know where to find it.
You might also like
Anker® 40W 5-Port Family-Sized Desktop USB Charger with PowerIQ™ Technology for iPhone 5s 5c 5; iPad Air mini; Galaxy S5 S4; Note 3 2; the new HTC One (M8); Nexus and More (White)
Wireless (Fantasia Trading LLC)
The Guinness World Record for the Largest Data Warehouse: A Q&A with Tom .. — B-EYE-Network
Business unIntelligence—Insight and Innovation Beyond Analytics and Big Data Summary Is there still a need for the data warehouse? In this excerpt from his new book, Barry Devlin looks at why the data warehouse can no longer retain its old role of ..
Anker® 2nd Gen Astro Mini 3200mAh Ultra-Compact Portable Charger Lipstick-Sized External Battery Power Bank with PowerIQ™ Technology for iPhone 6 5s 5c 5 4S, Galaxy S5 S4 S3 Note 3, 4, Nexus 4, HTC One M8, Nokia Lumia 520, 1020 and Other Smartphones (Black)
Optoma EH500 1080p 4700 Lumen Full 3D DLP Network Projector with HDMI
CE (OPTOMA TECHNOLOGY)
ROBERTSON 2P20067 PSP242TRMVW/S Quik-Pak of 10 eBallast, Program Start, 1 or 2 Lamp, 4 Pin CFL (CFTR42W/GX24q), HPF, 120-277Vac.
Home Improvement (Robertson Worldwide)
Anker® 2nd Gen Astro 6000mAh External Battery Pack with PowerIQ™ Technology 2A Output Portable USB Charger Power Bank for Smart Devices (Green)