KPI’s showing up in wrong perspectives

• woutgoet

  SSC Enthusiast

  Points: 194

  More actions

  June 7, 2017 at 5:23 am

  #146461

  Hello,
  
  We have an issue with the displaying of KPI’s. A little background information, we have an SSAS tabular model (Compatibility level: SQL Server 2014 / SQL Server 2012 SP1 (1103)), which consists of 8 perspectives. The person who created all this is no longer working for us and now we are trying to make sense of a few things (the remaining team doesn’t have much experience with SSAS tabular).
  
  An issue we have is with the displaying of KPI’s. More exactly, we notice that KPI’s created in one perspective, also show up in other perspectives, and so far we haven’t found how/where/what to do change to avoid this behaviour.
  
  For example, we have a perspective “Hospitalizations”, where we have a KPI “PercentageOfNumberOfHospitalizationsEvolution_Hospitalizations” made up by the following:
  

  For this KPI we have the following defined for the perspectives:
  

  As you can see we only checked the box for this KPI to show up in 2 of the 8 perspectives ("Hospitalizations" and "Visits"), but if we check the other perspectives in Excel however, the KPI's also show up for them, for example the "DossierPrestaties" perspective: 

  

  Does anyone have an idea what might be the cause of this? Any help to point us into the right direction would be greatly appreciated!