Error while loading FISCPER in SAC Model

[kashif_abbas1]

Hi there,

i am having issue loading data from SAP Source system into SAC Data model.
FISCPER format is being delivered from Source. Is there anything i am doing wrong on SAC side? OR is the functionality to accept PPPYYYY not there in SAC data model?
Any solution for successfully loading data with FISCPER?

[JefB]

Still not standard... 😞
You have to use the expression editor to create a formula to a date format SAC can understand (e.g. yyyyMM) like this:

[NewFiscPer]=concatenate(substr([FiscPer], 5, 4),substr([FiscPer], 2, 2),"")

I highlighted this many times to SAP, including recently to @Max_Gander 

[Susanne_Helbig]

Dear @kashif_abbas1,

on the Map to Facts tab map FISCALYEARPERIOD to your SAC Date dimension.
Then you can adjust the format like shown in the screenshot below:

This should solve your issue.

Best regards
Susanne