3 Replies Latest reply: Apr 16, 2015 6:37 AM by Sunny Talwar RSS

    Create calculated dimension in script

    Pedro Lopes

      Hi guys,


      I have some problem with my calculated dimension.


      I need put this calculated dimension in script because my pivot table exceeded the memory.


      So my calculated dimension is:


      =if(aggr((totalCategoriasKpi),id_master)=1 ,Dual('1',1),

           if(aggr((totalCategoriasKpi),id_master)=2 ,Dual('2',2),

           if(aggr((totalCategoriasKpi),id_master)=3 ,Dual('3',3),

           if(aggr((totalCategoriasKpi),id_master)=4 ,Dual('4',4), dual ('5+',5)))))


      What kind of transformation i have to do put this calculated dimension in to the script?


      Thanks in advance,


      Pedro Lopes