Hi! Which Data Set to use if I want all courses created under the Business Unit?
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! MattLearning Administration Manager
Connect with our Known and Fixed Issue information to learn about improvements made to Brightspace.
Connect with leaders in pedagogy, accessibility, learning experience design and more
The Accessibility category serves as a single point of access to three avenues in Brightspace Community leading to the Accessibility Academy, Accessibility Library and Accessibility Discussions. These avenues offer courses and articles about accessibility to enhance accessibility knowledge and a group of accessibility enthusiasts to stay connected with.
Have questions about how to use Community? Stay tuned with updates, feedback opportunities and more for the Community here!
Connect with and ask questions on how to best use the Brightspace Product to transform the way your users learn!
Connect with product experts to learn more about tools frequently used by Brightspace Developers such as APIs and integrations!
Want to learn more about Brightspace Partners and Integrations? This is the place to be!
Stay up to date with product updates and announcements in this category.
Connect with our release information to learn about monthly improvements and updates to Brightspace.
Learn more about all the upskilling opportunities with courses and resources offered via the Brightspace Learning Center, Brightspace Guided Training and other training opportunities!
