Skip to Content
0
May 29, 2020 at 08:25 AM

How can you create a time series chart using yyyy.mm field which is not recognised as time dimension

124 Views

How can you create a time series chart using yyyy.mm field which is not recognised by SAC as time dimension in live model based story.

Problem:

I am using S4HANA CDS query 'Accounts Payable. Days Payables Outstanding (2CCFIAP_DPO)' as source in SAC live model. Field 'fiscal year-month' is having data in format YYYY.MM however when its consumed in story based on live model it does not appear as time dimension so doent not allow to create time series charts.

In case of import models you can simply map this field to time dimension and use in time series charts but there is no such option in case of live model to change type to time dimension etc..

This is an SAP standard CDS query so there is no option to change in source also.