7 Replies Latest reply: Sep 26, 2012 4:59 AM by User472204-OC RSS

    how to expand the hierarchy column automatically when delivery reports by a

    User472204-OC
      Hi Experts,
      In OBIEE 11.1.1.6.0,how to expand the hierarchy column automatically when delivery reports by agent?
      For example:
      In SampleLite RPD, when we drag "Time Hierarchy" and Sales column into the report , and sent it by agent ,it will only display "Total" sales, not show all level value,such as Year,Month,Day.So how to expand the hierarchy column automatically when delivery reports by agent?

      If we expand all levels and save them, it will be ok, however, when we add new data, it will be collpased automatically and not show the lowest level data, requiring Users or Developer to modify this report for expanding the hierarchy. We think it is very trouble, is there any good suggestion or method for achieving our requirement?