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,102 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 29,021 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
  2. PercyTang-MSFT 5,621 Reputation points Microsoft Vendor
    2023-05-17T02:18:50.3333333+00:00
    0 comments