Symptom
When creating an analytical query on a CDS view(an analytical dimension) which has the fields "ValidityStartDate" and "ValidityEndDate", these fields are not available in the analytical query.
Environment
S/4HANA Cloud
Reproducing the Issue
1. Create a Standard CDS View with a primary data source which has the fields "ValidityStartDate" and "ValidityEndDate".
2. Create an Analytical Dimension with the CDS View.
3. Make sure that the Semantic Value of "BusinessDate.From" and "BusinessDate.To" are ON.
4. With this Analytical Dimension, create an Analytical Query, these two date fields are not available in the list of Field Selection tab.
Resolution
Set the Semantic Value of "BusinessDate.From" and "BusinessDate.To" to OFF in the Analytical Dimension.
Keywords
Date fields, ValidityStartDate, ValidityEndDate. , KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , Problem