6 Replies Latest reply: Jan 22, 2013 7:22 AM by SurendarBheemreddy RSS

    How can i create multiple formulas for same members in multiple reports

    SurendarBheemreddy
      Hi All,

      I'm using BSO Application,In Account dimension contain 6 Hierarchies 3 are original (1000 members) & 3 are shared( 200 members), My requirement is i want to generate 20 reports and each report contain 20 members.
      In 20 reports having 20 same members but each report calculation is different, How can i create same members in all reports [Possible in free form Mode]? I am using Excel Add-in.
      How can i make formulas for same members in different reports?
      My Required report looks like

      report 1:
      a
      b
      c
      d

      Report 2:
      a
      b
      c
      d
      .
      .
      .
      .report 20:
      a
      b
      c
      d
      Every report same members but calculations are different please help me out.

      Thanks.