Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
SLA KPI Instance entity RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    HI All,

    I am trying to build a report against the SLA KPI instance in CRM 2016. However I cannot find the Filtered view for this entity?Any advice on where (if) it might be available?

    Thanks

    Mandeep

    Thursday, August 18, 2016 4:42 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi,
     
    Please explain more what exactly you needed.
     

    In CRM 2016 we can filter the “SLA KPI Instances” entity in advanced find view please see below screenshot.

    Thanks,

    Sam

    Inogic | Blog | news@inogic.com

    If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"

    Friday, August 19, 2016 9:51 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thank for your reply Sam however I can get to the advanced finds etc through the CRM interface.

    However what I need to do is to write some SSRS reports and to do that in a supported way I need to use the Filtered views for each of the entities and I am unable to find the one for the SLA KPI instance.

    Friday, August 19, 2016 10:45 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi,
     
    Yes, there is no filtered view available for this entity i.e. “SLA KPI Instance” entity. Are you creating report using SQL query?
     
    In SQL base report we always should use Filtered view of entities. Since filtered view is not available for this entity then we cannot use it in SQL base report.
     
    Can you try it by creating fetch base report? Since this entity is available through advanced find we can use fetch query in fetch base report to generate report.
     

    Please let us know if you able to achieved this.

    Thanks,

    Sam

    Inogic | Blog | news@inogic.com

    If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"

    Saturday, August 20, 2016 9:59 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I would recommend to go for fetchXML based reports to access SLA KPI Instance. You may need MSCRM report authoring extension to use fetchxml datasource.

    Refer here for report authoring extension.

    Ramanathan Rajendran MCTS - Dynamics CRM

    Sunday, August 21, 2016 8:30 AM