Details
-
Story
-
Resolution: Completed
-
Medium
-
None
-
None
-
GxP
-
CM Sprint 125
-
Yes
Description
Problem Statement
In current PCM tracker, many standard attributes are utilized and displayed as per their text value coming from the hiearchy tables.
Each of those entries usually comes as a combination of KEY : DESCRIPTION, where the key always remains the same, but the description can be amended over time.
Purpose of this change is to make sure we bring both Key and Description for those attributes and that the description are alwyas reflective of the last description in the hiearchy
For the brand we will need to bring:
- Global Reporting Product (desc present, missing key)
- Sub Brand / Label Name (desc present, missing key)
UDH table to refer to is PGSUDH_DL_PROD.PGSUDH_CDM.MDG_MATERIAL_ATTRIBUTE or
PGSUDH_DL_PROD.PGSUDH_CDM.GLOBAL_BRAND_HIERARCHY
Acceptance Criteria
- Key and description are treated as separate fields
- Key fields are loaded in main tracker but hidden by default
- Desc fields are loaded in the main tracker and shown by default
- All those fields are reported appropriately in both Excel reports and Tableau databases
- the check for lastest description is performed as part of daily MD run to always reflect the latest description. it applies to all records in the repository, even the past due ones
- A data check is performed on all PCM records to make sure that for a single key, there is only one single value displayed
Other naming to correct
- PCM "Brand" field is to be renamed to "GLobal Reporting Product"
- PCM "Brand Group" field is to be renamed "Sub Business Unit"
qTest: Test Execution
Attachments
Issue Links
- has to be done after
-
OS-15020 Requirement Gathering :OS-14773 - Global brand/product IDs and names | PCM Addition in Event Tracker
- Closed
-
OS-15021 Analysis :OS-14773 - Global brand/product IDs and names | PCM Addition in Event Tracker
- Closed
- relates to
-
OS-15022 Development & Unit testing :OS-14773 - Global brand/product IDs and names | PCM Addition in Event Tracker
- Done
-
OS-15023 Test Case Preperation :OS-14773 - Global brand/product IDs and names | PCM Addition in Event Tracker
- Done
-
OS-15024 Peer Code review :OS-14773 - Global brand/product IDs and names | PCM Addition in Event Tracker
- Done
-
OS-15025 Testing :OS-14773 - Global brand/product IDs and names | PCM Addition in Event Tracker
- Done
-
OS-15026 Test Script review :OS-14773 - Global brand/product IDs and names | PCM Addition in Event Tracker
- Done
-
OS-16304 CM-Dev-Product Key and Sub Brand/Label Name keys are not available in main grid columns list to select in event tracker
- Done
-
OS-16305 CM-Dev-Fields and field names are not exported appropriately in Excel reports
- Done
- links to
-
TC-2871 001_Navigation_PCM Event Tracker
-
TC-2872 002_PCM Event Tracker_Main Grid
-
TC-2873 003_PCM Event Tracker_Main Grid_Columns
-
TC-2874 004_PCM Event Tracker_Excel Reports