BI reporting | Learning Plan Report

Summary

BI Reporting | Mapped item under the learning Plan

Content

Hi 

As per my requirement, need to create a learning plan report with all the items mapped under it. It can be a course, assignment, ILT track, item type etc. In the current BI report, for learning plan we only have the Courses details  mapped under the Learning Plan..  How can I create the report with all the mapped item under the plan ... Though I have used the below query, but iam not getting all the details

Courses INNER JOIN LearnCenter Courses

LearnCenter Courses INNER JOIN LearnCenters

LearnCenter Courses INNER JOIN Learning Plan Mappings