Which Data Set to use if I want all courses created under Business Unit?
Hi! Which Data Set to use if I want all courses created under the Business Unit?
Answers
-
Hi Jordan
There isn't a single data set that serves this information up. This kind of reporting requires merging multiple data sets together.
To see the child OUs under a given parent OU, I download the Organizational Units BDS and the Organizational Unit Ancestors BDS. Merging these two tables will give you a table with each row representing a parent-child relationship.
Because the OUA BDS only provides two OUs per row you'll need to merge the Organizational Units data in for additional details. As you can see in the screenshot below I've loaded these two BDS into Excel and done XLOOKUP to find the OUType for each, and then filtered so that I'm only looking at Course Offerings and their parent Departments. Doing further XLOOKUPs you can add course name/code and other details.
Of course, merging the data properly with a Business Intelligence platform will create more flexible/scalable reports but this would give you the answer you're looking for. You can see the formula I used for the lookup in the screenshot and the filtering of OUTypes is also a native functionality in Excel.
I hope this is helpful!
Matt
Learning Administration Manager
