Some days ago, I installed SAP Lumira that creates beautiful and interactive «stories» using different kind of data (as written in one-pager 🙂 ). All data «stories» could be shared using Lumira Cloud service. Therefore, I decided to examine if SAP Lumira can help to create interactive dashboards and charts for Workforce Performance Builder (WPB), maybe most popular solution in Education portfolio. Much number of customers asked to do something with WPB reports, cause for this moment they find them complex and difficult to understand.
That’s how this data story began 😉
WPB stores information in a Microsoft SQL database (rarely on Oracle DB). SAP Lumira connects to large number of data sources, including MS SQL database. Therefore, I installed proper MS SQL driver and connection to WPB Manager was successfully established. While examining tables in WPB database, I have found additional columns, which describe WPB user, like «Job position», «job description», «Age» and geodata, that you can’t see in WPB Manager, but they exist in DB. I decided to add some data. To do this I used Microsoft SQL Server Management Studio. After that connected with WPB Database and added some geographical information, age and job description.
After 2 hours of efforts, here is what I got and want to share with you.
I’m not experienced in all that things about databases, programming languages and etc. I just wanted to show the possible way, how to make SAP solutions better and more attractive. If it looks and sounds interesting, hope, guys from SAP can develop this idea into final product.