Symptom
When you define Global_DateTime data type field in your business object and try to select that field as 'Date Key Figure’ in custom datasource from SDK.
Environment
SAP Cloud Application Studio
SAP Cloud For Customer
SAP Business ByDesign
Reproducing the Issue
Pre-requisite : You have defined extension field in your BO/XBO with data type as Global_DateTime.
- Login to SDK
- Open PDI solution
- Open Custom DataSource
- Navigate to Transformation Rule
- Here when you select the element (extension field with data type as Global_DateTime) you will see check box ‘Date Key Figure’ will not be enable on selection.
Cause
Element with data type as Global_DateTime cannot be selected as Key Figure in analytics.
Resolution
Element with data type as Global_DateTime cannot be selected as Key Figure in analytics. You can use Date data type field as key figure in analytic.
This is Extected System behaviour.
Please refer Use Date data type field as key figure in Analytics | SAP Blogs for the same.
Keywords
KBA , AP-RC-BDS-ANA , ByDesign Studio Analytics , Problem