Unable to change the Aggregated Calculated column in ORD. When we open this for edit (and wait for a few sec to complete the join tab to go green) and Open Date Options Editor; we want to change the Date Options from "Date Range (On Start Date)" to "Date Range (Validity)" but consistently get a browser error.
Tables Used : Employee Details, Job Information, Compensation Information
Reproducing the Issue
- Under ORD -> Detailed Reporting, Open Folder and any EC report.
- Go to Calculated Column> Aggregated Calculated Column > Select the required Aggregated Calculated column
- Open this for edit (and wait for a few sec to complete the join tab to go green) and Open Date Options Editor
- Change the Date Options from "Date Range (On Start Date)" to "Date Range (Validity)" or any selection.
The issue is that you have selected the aggregation join coming from Employee Details (which is correct) and they then set up the date options (which works). However, upon saving and then re-opening the column for edit, a different join gets selected (from Compensation Info). This is a bug (which is now fixed). During the state when this incorrect join is selected, when opening the date options, it will try and find columns from the actual join which the user selected earlier but this fails in a bad way.
A simple workaround is that you need to re-select the correct join every time you edit an aggregated column. After this selection has been done, you can open the date options. Beware that if you don't re-select the join and then press "OK", the wrong join has now been saved against this aggregated column.
The permanent fix for this issue is going in with the 1608 release.
Aggregated Calculated Column, Detailed Reporting, ORD, Advance Reporting , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , Problem