SSAS OLAP Cube Output Date Format yyyy-MM-dd to yyyy-MM-dd hh:mm:ss

selçuk kahya 0 Reputation points
2023-05-16T08:22:05.3833333+00:00

Hello

Can you help me convert the date field to date, hour, minute, second? for example; 2023-01-31 00:00:00

thanks.mdx-query

SELECT

NON EMPTY {[Date].[Day].ALLMEMBERS} ON ROWS,

NON EMPTY {[Measures].[SalesQuantity]} ON COLUMNS

FROM [V3]

WHERE ([Product].[ProductTypeDescription].[Ürün],[Product].[ProductAtt05Desc].&[01])

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,260 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 43,161 Reputation points
    2023-05-16T09:34:58.9533333+00:00

    Output Date Format yyyy-MM-dd to yyyy-MM-dd hh:mm:ss

    You are on a wrong track.

    SSAS knows the date value, formating is task of the client, respecting the regional settings of the current user.

    You can use the MDX format functions, but many client tools ignore it; see e.g.

    https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/mdx/mdx-cell-properties-format-string-contents?view=asallproducts-allversions

    0 comments No comments

  2. PercyTang-MSFT 12,426 Reputation points Microsoft Vendor
    2023-05-17T02:18:50.3333333+00:00
    0 comments No comments