SAC date variable input as MM/DD/YYYY?

[#1]

Hi Experts,

Business users want to enter values for a date variable in MM/DD/YYYY format in SAC story (built on Datasphere models) and I’m looking for guidance regarding date-variable input formatting.

Context:

• Data is loaded from S/4HANA into the Datasphere Raw layer. Date fields initially arrive as strings in YYYYMMDD format (e.g., 20251231). We manually change the data type of date fields to the "Date".
• In the Harmonization layer, we consume the Raw layer table without transformations.
• In the Business layer, we apply cleansing, business logic, master data alignment, and assign semantics to date fields as Calendar Date.
• In the Consumption layer, we build an Analytic Model and create variables on these date fields.
• The SAC story is based on this Analytical Model, and the date variables appear as designed
• The SAC user profile is configured to display dates in MM/DD/YYYY format.

Issue:

When running the story:

• The variable's value help (possible values) shows the description in MM/DD/YYYY format and the ID displays in YYYY-MM-DD format. User can search in MM/DD/YYYY then select it and the variable show MM/DD/YYYY format (in form of description but accepts the entry as YYYY-MM-DD)
• If the user manually enters a date as MM/DD/YYYY (without selecting from the value help), SAC throws an error: “Member ID does not exist”.

I understand that variables accept the key value rather than the description, but I want to know:

Is there any standard SAP-supported way for SAC variables to accept date input in MM/DD/YYYY format, without creating custom fields, casts, or transformations? Since we have many date fields, implementing custom logic repeatedly would be costly, so we’re hoping for a standard approach if one exists.

Thanks in advance for your insights!

Blogs referred:
Assistance Required – Date Format Handling in Data... - SAP Community

Solved: Date shown wrong in SAP Analytics Cloud based on S... - SAP Community

Regards,

Preet

[Ivan_Camac]

Edit - please disregard... I can see you had already addressed this, not sure how I missed that in the question to start with.

---

If you have modelled the data correctly as a date dimension, then the formatting of the dates should be governed by a users personal locale settings at the SAC platform level. Perhaps check their settings as follows:

Cheers, Ivan. 

[A_Loke]

Hi @Preet_Singh ,

As far as I am concerned, there's no standard, SAP-supported setting that makes a date variable's manual free-text entry accept MM/DD/YYYY. This is a known, long-standing platform gap, not something your Datasphere layer design can fix.