4 Replies Latest reply: Jun 20, 2011 12:31 PM by AmarendraDivi RSS

    Group by

    user13642056
      Hi,

      In my report I need to group by a specific column called PERIOD...can anyone tell me how to do this?
        • 1. Re: Group by
          Nathan John Morgan
          You are building a request in Answers? If so use the Advanced tab.

          You can edit the logical SQL or use the GROUP By box.

          See
          Oracle® Business Intelligence Server Administration Guide
          http://download.oracle.com/docs/cd/E10415_01/doc/bi.1013/b31770.pdf
          17 Oracle BI Server SQL Reference
          GROUP BY Clause Syntax

          "With auto aggregation on the Oracle BI Server, there is no need to submit a GROUP BY clause. When
          no GROUP BY clause is specified, the GROUP BY specification defaults to all of the nonaggregation
          columns in the SELECT list. If you explicitly use aggregation functions in the select list, you can
          specify a GROUP BY clause with different columns and the Oracle BI Server will compute the results
          based on the level specified in the GROUP BY clause."
          • 2. Re: Group by
            Deep
            Hello,

            The report usually automatically groups by the all detail level. If you want to group it to another level you can specify in your column formula for example.

            sum("Sales Facts"."Amount Sold" BY "Period".Period)

            hope this helps

            thanks,
            deep
            • 3. Re: Group by
              Diney
              hI USer

              Deep was correct.Give the formula in ur column formula in reports.The syntax for this is

              Aggregation(measure by columnname)
              • 4. Re: Group by
                AmarendraDivi
                Hi,

                first write the query,no need to group by in query itself becuase it may reduce the performance.group the data in RTF(TEMPLATE) open micro soft word and save the file in rich text format then
                write the command like
                --<?for-each-group:GROUP NAME IN BI PUBLISHER>
                is there any problem with this if your not aware of the commands of xml ,word mapping add ins->inset the table wizard
                in this process group by functions wil there group the column which do u want.
                <?for-each-group:BASE_GROUP;PROD?>

                Edited by: Amarendra Divi on Jun 20, 2011 11:00 PM