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

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

    Hi,

    I have this problem.

    Fact Table:
    -Process_date
    -Payment (measure)
    -Cod_money_origen

    Dimension : Date
    -Process_date

    Dimension : Type_of_Money
    -Cod_money_origen
    -Cod_money_target

    Dimension : Factor_Money
    -Process_date
    -Cod_money_origen
    -Cod_money_target
    -Factor

    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
  •