-
Bug
-
Resolution: Fixed
-
Low
-
11.5.1.1126
-
1
-
Severity 3 - Minor
-
No
Issue Summary
The estimates value of team level in the additional program is not returned in the Feature Forecast table in EI/AA.
This is reproducible on Data Center: (yes)
Steps to Reproduce
- Step 1. Create 2 features with additional programs
- Step 2. Add an estimate for the additional program itself to the first feature
- Step 3. Add an estimate only for one of the teams of the additional program to the second feature
- Step 4. Then run the following query in EI /AA:
-- checking Forecast estimate for additional program SELECT [Feature Forecast].[Estimate Float Value] AS [Estimate Float Value], [Feature Forecast].[Feature Forecast ID] AS [Feature Forecast ID], [Feature Forecast].[FK Feature ID] AS [FK Feature ID], [Feature Forecast].[Estimation Object] AS [Estimation Object], [Feature Forecast].[FK Team ID] AS [FK Team ID], [Feature Forecast].[FK Program ID] AS [FK Program ID] FROM [current_dw].[Feature Forecast] AS [Feature Forecast] WHERE -- adding the filter for given programs (the primary program = 627 and the additional one = 450) [Feature Forecast].[FK Program ID] in ( 450) --adding the filter for given feature ids 18565 and 18567 have estimates in additional program 18565-> program and 18567 team) and [Feature Forecast].[FK Feature ID] in (18565,18567) GROUP BY [Feature Forecast].[Estimate Float Value], [Feature Forecast].[Feature Forecast ID], [Feature Forecast].[FK Feature ID], [Feature Forecast].[FK Team ID], [Feature Forecast].[Estimation Object], [Feature Forecast].[FK Program ID] ORDER BY [Estimate Float Value] ASC, [Feature Forecast ID] ASC, [FK Feature ID] DESC
- Step 5. The query only returns the result for the Feature where the estimate was added at the additional program level
The query does not return the one at the team level
- Step 6. Creating a feature where the estimate is only added to a team belonging to the primary program will have the expected result in EI
Expected Results
The estimates value of team level in the additional program is returned in the Feature Forecast table in EI/AA.
Actual Results
The estimates value of team level in the additional program is not returned in the Feature Forecast table in EI/AA.
Workaround
Currently there is no known workaround for this behavior. A workaround will be added here when available
- relates to
-
ALIGNSP-26902 Loading...