Results 1 to 2 of 2

Thread: A way to convert week name to mdx

  1. #1
    Join Date
    Sep 2010
    Posts
    2

    A way to convert week name to mdx

    Hi,

    I'm using report builder and mdx in a stored procedure to create reports. The drill through report needs the week name (week 1, 2010). Is there a way I can call that name with MDX instead of [DENIAL TIME].[Week].&[2000-05-21T00:00:00]??
    Is there a property of that member that will have the week 1, 2010 name? Thank you.

  2. #2
    Join Date
    Sep 2010
    Posts
    2
    I'm trying to do something like this:
    select {[DENIAL TIME].[Week].PROPERTIES("Weel 1, 2010")} on 0
    from [DMDS]

    this is not working.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •