1 Reply Latest reply on Sep 20, 2013 2:35 PM by 1012730

    Union All in Analysis -obiee 11g


         Hi All,


                 I need to create report by having one metric which is grouped by a Country, Region and  Company dimensions. So in each i  dimension i have to apply  Sub total. For example : I need to have a Country wise distribution of Amount, Region wise and Company wise Distribution  in turn i have to calculate Region & Country Subtotal.. So i have applied union All  to get each subtotal and over all total . Is there any way to get the result with out using union all function




        • 1. Re: Union All in Analysis -obiee 11g

          1) pull the columns country,region,company,measure on the report

          2) go to results tab-pivot view

          3) keep the dimension columns under "rows" and the measure column under "measures"

          4) click on the sigma sign for all the dimension columns (which u placed under "rows"),click after

          5) done..you will see the dimensionwise subtotalling


          Mark if it helps