none
Output of Attribute Calendar Date from Date Dimension needs to Format in mm/dd/yyyy

    Question

  • Hi All,

    I have a energy cube which has data of USA and Australia. We have excel sheet to access cube data for USA and another one for Australia.

    We want to format all the dates in mm/dd/yyyy in USA Excel sheet and dd/mm/yyyy in Australia Sheet.

    I tried formating Calendar date and can do it. It is not changing. Its current format is yyyy-mm-dd


    Thanks Shiven:) If Answer is Helpful, Please Vote

    Friday, May 18, 2018 4:06 AM

All replies

  • Hi S Kumar Dubey,

    Thanks for your question.

    In this scenario, take USA key as an example,you might try to  format the Dimension Attribute field in your view first. Example:
    FORMAT(DateAlternateKey,'MM/dd/yyyy','en-US') AS DateUSAKey

    Then you should go to DateUSAKey attribute properties of your Date Dimension and set NameColumn=DateUSAKey. This attribute should be set to Type=Date.

    For Australia, you can try the same. For information about format function, please refer to below article.
    https://docs.microsoft.com/en-us/sql/t-sql/functions/format-transact-sql?view=sql-server-2017


    Best Regards
    Willson Yuan
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    23 hours 8 minutes ago
    Moderator