4 Replies Latest reply: Oct 30, 2014 7:46 AM by Aleksandar Ristic RSS

    prevent calc. dimensions in kpi data island

      Hi all,

       

      Since calculated dimensions are bad for performance i would like to not use them anymore.

       

      I have a complex datamodel, and we have one dashboard containing 8 pivot tables with 6 expressions. (e.g. HR, Finance, risks), by making selections in a cost center (or client or employee) box they can investigate the performance. The 48 kpi are read in via an excel file (data island)

       

      requirement: all 6 expressions must be visible (so suppres zeroes won't work, but I also don't understand the suppress null, which does not change any behaviour)

       

      Question, how can I remove my calc. dimension and only show the 6 relevant kpi's in each box without using a cal. dimension?

       

      Dimension: =if(Block =1,[KPI name])

      expression: if([Tech Name] = 13, count( something))

       

      thanks a lot!

       

      full expression for background info:

      if([Tech Name] = 13, count({< eng_costcenter_key = {$(vCostCenter)},EA.type={'EA'}, EA.ass_start_month = {'$(=date($(vReportingDate)))'}>}  EA.assessmentId),

      if([Tech Name] = 14, count({< eng_costcenter_key = {$(vCostCenter)},EA.type={'EC'}, EA.ass_start_month = {'$(=date($(vReportingDate)))'}>}  EA.assessmentId),

      if([Tech Name] = 16, count({< eng_costcenter_key = {$(vCostCenter)},Z_interne_code_flag = {'1'}, cons_ingediend_month = {'$(=date($(vReportingDate)))'}>} consultId)

      etc....