This discussion is archived
1 Reply Latest reply: Nov 16, 2012 5:26 AM by TimG RSS

Member selection in essbase excel add-in

SurendarBheemreddy Explorer
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points