I am trying to export SAC planning data to ACDOCP.
Connection from SAC to S/4HANA Cloud is fine.
SAC planning data has a date type dimension.
But, to export data to ACDOCP, fiscal year and fiscal period(01,02,03,...) are required.
Simply adding fiscal year and fiscal period dimensions did not work because they were not related to the date type dimension.
It is also not possible to enter planned values for future periods for which no data exist.
Therefore, I assume that I need to generate fiscal year and fiscal period from the date type dimension.
What is the possible approach in this case?
The following blog may be relevant, but I could not find the specific operation.