Interactive custom widget for EWM Version: 7.0.3
We are using IBM Engineering Lifecycle Management (ELM) version 7.0.3 (iFix020) with Engineering Workflow Management (EWM) and Rhapsody Model Manager.
We have built a custom monthly SQDIP Daily Board using the HTML Widget on a shared team dashboard. The board contains:
-Day-by-day status toggles for 5 categories (Safety, Quality, Delivery, Inventory, Productivity) where each date box should hold one of three states - Done (Green), Not Done (Red), or Default (Grey)
-Editable data cells for Target, Actual, and Comments per day per category
-Pareto analysis tables with editable issue descriptions and counts
Problem: The HTML Widget does not persist any data. Every time the dashboard is refreshed, all entered data (text in cells, color states of date boxes) resets back to the default blank template. JavaScript and iFrames are both blocked in the HTML Widget by the current CSP (Content Security Policy) configuration.
Requirements:
-Data must be shared and visible across the entire team on the same dashboard
-Color states (Green/Red/Grey) per date must persist across sessions and refreshes
-Text data entered in comment/target/actual cells must persist across sessions and refreshes
-Solution must work within IBM ELM 7.0.3 environment
What we have explored so far:
-HTML Widget : JavaScript blocked, iFrame blocked, no persistence
-SharePoint Excel embed via iFrame : iFrame blocked in ELM HTML Widget
What is the recommended approach in ELM 7.0.3 for building shared interactive team dashboards with persistent custom data?
Thanks in advance.
One answer
You haven't said what applications you are using, or how your team comes up with this information. Is this data based on raw information you have in ELM somewhere and a human then synthesises it into content?
- if the data comes from raw content already stored in ELM, then you could create the data in the widget in various ways - it might be something as simple as a report builder report
- if the data is not contained in the system, then the simplest way to do this would be to create something to contain the data and build reports or content based on the data in the system. If you mainly use DNG then create an artefact to hold it, if you use EWM then create a work item type. Users then fill in an artefact or work item each day and you simply report on the content
Comments
Team currently tracks daily work and performance using a SQDIP board maintained in MS Excel on SharePoint. The daily process works like this:
-Each team member logs their planned tasks for the day in Excel
-The next day, a nominated person reviews task completion
-Each day is marked Green (Win) or Red (Not Win) against all 5 SQDIP categories
-This produces a monthly visual scorecard showing day-by-day team performance
We want to move the entire SQDIP board into EWM(ccm) so that:
-Team members log daily planned tasks directly inside EWM, no Excel needed
-SQDIP metrics (Green/Red per day per category) are visible on the EWM project dashboard
-All teams and stakeholders with EWM access can view the board without needing SharePoint
-A monthly calendar-style view shows color-coded day boxes across all 5 categories
-All data is maintained within EWM, single source of truth
Hope this helps
OK then this could be quite easy:
- either use the existing, or create a new Task work item type, with the minimum fields required to contain the data you currently measure. I assume you have some sort of category to allocate the task into SQDIP
- use a workflow to measure completion of the Task
- create a Report Builder report that calculates SQDIP for each day, and colour codes the cells green or red
To make it simpler to enter tasks, you could use a Plan and set up the column display to show the minimum columns. Organise the Plan by resource and then they enter tasks under their own area