Fiscal Year Period for the new model

[phulwin_]

Hi community,

I recently checked out the new data modelling in SAC and saw that there were quite a lot of changes,
one of which is me being unable to map fiscal year period data.

Previously, if I enable my fiscal year settings, and change the granularity to be able to map my Fiscal year period data format of YYYYPPP, it is no issue.

Now, even when I have done those, YYYYPPP does not seem to be a recognized format in SAC.
Does anyone face the same issue? Hope to get some advise on resolving this.

Thanks in advance.

[JohnL]

Hi Phu,
Until this feature is added can you try this: Converting Date Values into Calendar Date

If your model uses fiscal period for the date dimension, and the imported source data is in fiscal format already, you can use the Custom Expression to convert the date values to calendar date before mapping to the date dimension. If incoming data is in calendar date format, the column can be mapped to the date dimension of the model as is regardless of whether fiscal period is enabled for the date dimension or not. It is because the date dimension of a model stores date values in calendar date format internally even if the fiscal year option is turned on.

Example

You want to achieve the date conversion by shifting the month number. In this example, the original data in the column fiscalDate is shifted by ten months which matches the fiscal period setting of the date dimension to generate a new column called convertedDate:

HTH

John

[JohnL]

See this screenshot 2021-05-11-10-23-01.png
+ Link:
See DateAdd Date Function here:

https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/8b8f9ce9952a450ebd12b81cf...

[DebjitSingha]

Hello phulwin,

Fiscal format import of data recognition is not yet supported by SAC. This includes May's QRC update as well.

There is an enhancement request available for voting - Allow Internal Calendar to match company's Fiscal Calendar

Thanks,
Debjit

[daniel_lauer]

Hi Phu

nice to meet you.

In case you're using the New Model, fiscal data import is not supported yet.
We're working on it as we're talking and it will be introduced soon.

best regards
Daniel

[dwilson13027]

Hi Daniel

Is there any progress or updates on when the fiscal data import will be available? I want to take advantage of the 'signage' functionality but I am getting an 'incompatible datatype' on the 'fiscalyearperiod' source field during the import mapping.

Thanks

Dennis

[former_member620565]

Thanks for the information but this is so non-SAP things , not to have fiscal period data type. Off late SAP product are dissapointing. It is painful to watch as a SAP consultant and customer. SAP need to do something in Analystics to compete with other product.

Regards

Ajay