2 Replies Latest reply on Dec 9, 2016 10:25 AM by Jian Wang

    CREATING CALCULATED MEMBER ISSUE

    MATHEW AUGUSTINE

      Hi All,

       

      I am using an SSAS cube data source. I have a dimension called WP Quantity and a measure called Unit Cost. I want to create a calculated member called T-Hours which is the product of these two values.

       

       

      b2.PNGb1.PNG

       

      So I created a calculated member like this:

       

      b4.PNG

      I created the member like this. But when I drag and drop the new member on two columns like this, the values is shown as null.I tried all combinations of accessing the dimension.But the result is the same.If any one got an idea,please help me.

      b5.PNG

       

      Thanks in advance,

      Mathew