4 Replies Latest reply: Aug 5, 2013 9:24 AM by Raghav Kondaveti RSS

    Top N,Other and Grand Totals

    Raghav Kondaveti

      Hello,

       

      We have  requirements to show Sales amonut by Site. 

       

       

      SiteSales Cost 1Cost 2Time PCProfitability
      London7500
      manchster 5434
      New York4560
      Hongkong2300
      Beriln1500
      Top 5 sales Total 21294
      Others3400
      Total24694

       

      All measure have complex set analysis formulas.

       

      We are able to develop this using calculated dimension:

       

      =If(Dummy=1 and aggr(rank($(vSales)),Site)<=vTopCustomer,Site,if(Dummy=1 and aggr(rank($(vSales)),Site)> vTopCustomer,Dual('Others Clients',-1),

            if(Dummy=2 and aggr(rank($(vSales)),Site)<= vTopCustomer,Dual('Top ' & vTopCustomer & ' by Sales Total',1),Null())))

       

      we have 4 tabales like this on same sheet by showing same data diffrent dimensions ( like top 10 clients, top 10 projects,...)

       

      All are working fine, but have occupying 50Gb memory  when slect year 2012, 2012 due data for those years and taking 2  mins time load when slection are made.

       

      Is there any best way to impletement to reduce amount memory  it is occupying.

       

      we are on QV 10 , Would it possible to do this using QV 11 dimension limit ?

       

      Cheers,

       

      Raghav