2 Replies Latest reply: Feb 1, 2013 8:03 AM by Alexia RSS

    How to aggregate data with BI Publisher using an OBIEE analysis

    Alexia
      Hello,
      I'm new with BI Publisher, and I have a concern about the ability for BIP to aggregate data.
      I am creating a data source from an OBIEE analysis containing the columns "Year", "Month", and "Revenue".
      I want to use this source for 1 report containing several pages. One of the page has a simple table displaying only the Year and the Revenue.
      But I get as many rows as number of months is the year.
      And I cannot find any way to have the data aggregate inside my PIB table.

      Can someone help me finding the solution?
      Many thanks in advance