1 Reply Latest reply: Nov 16, 2012 7:26 AM by TimG RSS

    Member selection in essbase excel add-in

    SurendarBheemreddy
      Hi All,


      We are using Essbase excel add-in for reporting, i want to retrive the data for Q4 in 2009 and Q1 in 2010, I want to calculate 6 months data Q4 data should not appear in the 2010 year, as well Q1 not apper in 2009 year. how can i specify perticular years month combination?

      Expectation:

      MONTHS YEARS

      Oct 2009
      Nov
      Dec
      Q4

      jan 2010
      feb
      mar
      Q1
        • 1. Re: Member selection in essbase excel add-in
          TimG
          I assume Month and Year are in different dimension?

          If so, I would just set up a retrieve that has Year then Period on the rows, and type the members directly into the sheet, with two columns. I.e.:
          2009   Oct
          2009   Nov
          2009   Dec
          2009   Q4
          2010   Jan
          2010   Feb
          2010   Mar
          2010   Q1
          Technically, you don't have to repeat the years - they could just be in the Nov and Jan lines. You can get to the same place by drilling and then selectively removing lines.