Date Format Inconsistency Between Cube API and UI

[Zawar92]

Problem

Issue: Date Format Inconsistency Between Cube API and UI
When I query Cube using month granularity for dates, I’m seeing different formats between the API response and the Cube UI:
• In Cube UI: Dates are displayed in a user-friendly format like “2025 Jun”
• In API Response: The same dates appear as ISO timestamps like

{"date": “2025-06-01T00:00:00.000",
       "date.month": "2025-06-01T00:00:00.000"}

I’m looking for a simple parameter I can include in my API requests that would return the date in the same format as shown in the Cube UI (“2025 Jun”), without having to:

1. Create custom dimensions in my data model
2. Write post-processing code in my application
   Is there any built-in query parameter or configuration option that would make the API return dates in the same human-readable format that the Cube UI uses?

Is this solution even possible, or is there a workaround for it? Any suggestions would be helpful.

[igorlukanin]

I’m looking for a simple parameter I can include in my API requests that would return the date in the same format as shown in the Cube UI (“2025 Jun”)

Such a parameter does not exist.

The recommended solution is indeed to format dates as you see fit. With some libraries, it might take just a couple of lines of code on the front-end.

Why is that the best solution: only you know how the dates should be formatted in your app. Baking this into Cube will probably make it too hard to customize when needed.

I hope this helps.

[Zawar92]

@igorlukanin,
Thanks for the information.