Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Need help mdx Syntax

  1. #1

    Default Need help mdx Syntax

    Hi All,

    Thanks For ur consideration,

    "select to_char(day_date,'DD/MM/YYYY') from Date_time"

    How do write same(Sql query Mentioned above) query in mdx format.Can u please anybody
    help me.

    Thanx,
    jim

  2. #2
    Join Date
    Dec 2007
    Posts
    10

    Default Try this....

    StrToMember("[Time].[Time].[Date].&["+format(dateadd("d",-1,now()),"dd/mm/yyyy")+"]")

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.