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

    Union All in Analysis -obiee 11g

    CommunityMember
    CommunityMember Sep 20, 2013 2:00 PM

         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

       


      Regards,

      Guru

      • 788 Views
      • Tags:
        • 1. Re: Union All in Analysis -obiee 11g
          1012730
          1012730 Sep 20, 2013 2:35 PM (in response to CommunityMember)

          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