Hierarchy Status column of [current_dw].[Hierarchy] in Enterprise Insights always displays "1 - Not Started" as the status no matter what status the Hierarchy is actually set to.
This is reproducible on Data Center: Yes
- Create a Custom Hierarchy
- Assign custom states to that Custom Hierarchy
- Assign custom status to room as appropriate
- Wait until ETL in EI completes.
- Run the following query:
Column reflects Custom Status data per Jira Align EI enhancements and features version 10.114.X
Status is always "1 - Not Started". This is also true in [export_dw].[Hierarchy]
Currently there is no known workaround for this behavior. A workaround will be added here when available