Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2007

    Unanswered: MDX To retrive value of dimension for calculated member?


    I have this problem.

    Fact Table:
    -Payment (measure)

    Dimension : Date

    Dimension : Type_of_Money

    Dimension : Factor_Money

    How can I to retrive the "Factor" of Dimension Factor_Money for some Process_date and to use on calculated member ?, because I need to do:

    calculated member = Payment (measure) * <<Factor of Process_date>>

    I like that the user to check of date of process from dimension "Date" and the OLAP to retrive the "Factor" for that date and I can to use on calculate member. And the user to check the "Code of Money Target" from "Type_of_Money" dimension.

    This is the Schema : To see atachment.

    If they are some help to my........ Thanks a lot.
    Attached Thumbnails Attached Thumbnails schema.bmp  

Posting Permissions

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