My goal is to create a report or display that shows all the employees down the left side, and all the courses across the top row. Then a flag in each cell showing null or 1-4 for the qualification level for each employee for each course. Something like this:
I think I can make this in a report. I know it will be tricky. How would I create this kind of a view in a dashboard, so I can just click and edit like it was a spreadsheet?
Thanks for your time! Have a nice weekend!
Nate
I want to have columns for every course in the UD07 table. There are only 3 in there now, but I could have a hundred or more courses. I don’t want to hard code my columns in.
I started messing around with DataDiscovery, but didn’t get very far. I might have to think of a different approach.
Create the columns you need in the Ud table and use a “pivot” BAQ to display the information like you have above. I am using this now to create a nice display of indirect labor hours by type for each employee. The drawback is you will need to maintain the BAQ each time a new type is added.
