2 Replies Latest reply on May 17, 2018 4:20 AM by 928267

    Essbase ASO Sumrange

    928267

      Hi,

       

      I can't get the syntax right on this. Any help appreciated.

       

      CASE WHEN ([CostCenter].CurrentMember IS [Finance Division])

      THEN SUM(Crossjoin({[FY07]:[&LastYear]},{[DEC_YTD]},{[CPP_profit(loss)]})))

      END

       

      Regards,

      RR.

        • 1. Re: Essbase ASO Sumrange
          GlennS_3

          a cross join can only have two sets, you have three. you either need two crossjoins or make one os the sets into a tuple set

          you might try

           

          SUM(Crossjoin({[FY07]:[&LastYear]},{[DEC_YTD],[CPP_profit(loss)]})

           

          I don;t know why, but I prefer the syntax Case When IS([Cost Center].currentmember,[Finance Division]) Then

          • 2. Re: Essbase ASO Sumrange
            928267

            Thanks Glenn. Tried two crossjoin and it worked fine.

             

            CASE WHEN ([CostCenter].CurrentMember IS [Finance Division])

             

             

            THEN SUM(Crossjoin(Crossjoin({[FY07]:[&LastYear]},{[DEC_YTD]}),{[CPP_profit(loss)]}))

             

             

            END

             

            Regards,

            RR