Reporting First Response Date and Time RRS feed

  • Question

  • I am attempting to create an SSRS report that will report incident created date and time and first response date and time.

    I'm using the SSAS SystemCenterWorkItemCube as my data source, and within the Incident Dimension I can select Created Date and First Response Date, but these are just the date and not time.

    Is there any way to get the time as well as date?  

    Tuesday, January 21, 2014 3:56 PM


  • Hi,

    OLAP's time dimensions don't store the time but the date only. Use SSRS to get the exact time values.

    Site: www.scutils.com  Twitter:   LinkedIn:   Facebook:   

    • Marked as answer by MDH36 Monday, January 27, 2014 3:45 PM
    Thursday, January 23, 2014 3:52 AM