locked
KPI goal dynamically RRS feed

  • Question

  • I have to build some KPI's and I want to be able to change the goal and status outside of BIDS. I read that it can be done with writeback on a specific fact that will hold the specific values.

    With a logic of using a Dim attribute like;

    Case  When [Territory].[Sales Territory Group]    Is [Territory].[Sales Territory Group].[Europe]
          Then .34

    Do you know any tutorial for that or can you explain the logic in order to implement it?


    • Edited by AngelosPs Thursday, June 2, 2016 8:28 AM
    Thursday, June 2, 2016 8:19 AM

Answers

  • Hi Proffesore,

    In this scenario, you just need to create a small fact table which contains Sales Territory Group and  KPI goal columns. Then build the relationship between this KPI Fact measure group with DimTerritory. This KPI goal value will become a measure. You can use Case Statement based on this [Measures].[KPI Goal]. For more details, please refer to blog below:

    SSAS Dynamic KPI from a table

    To change these KPI values outside of BIDS, you can enable write back on partition. Please refer to links below:

    Set Partition Writeback

    Writeback to Analysis Services cubes from Excel 2010

    Regards,


    Simon Hou
    TechNet Community Support


    Friday, June 3, 2016 6:43 AM