0 Replies Latest reply on May 7, 2012 5:47 PM by . Danihp

    overwrite context dimension on calculated member (SSAS)

    . Danihp

      Let's supose a simple scenario: a fact table F with two dimensions D1 and D2.

       

      In this escenario I define a new calculated member C1 using this expression:

       

      sum(

         intersect( descendants( [D1].[Ds].currentMember, blah blah conditions ) ),

         [myMeasure]

      )

       

      this new measure works pretty well, but I need to independice the result of my new C1 calculated member of D2 context. I means that C1 should return same results even when a D2 filter is set (or it is included in sheet absys). I think new expression may be somethink like:

       

      sum(

          {   [D2].[Ds].AllMembers,

             intersect( descendants( [D1].[Ds].currentMember, blah blah conditions ) )

         },

         [myMeasure]

      )


      But this expression don't returns expected results.

       

      Thanks about your help.

      daniel.