How to Slice Incidents by Days, Months, Quarters

re: How to Slice Incidents by Days, Months, Quarters

Ahsan Misbah — Thu, 09 May 2013 10:42:23 GMT

Management Pack successfully been imported but as it been run the data warehouse MP Syncthe job. After that it is

not being shown in MP Views. Kindly please guide me what to do further to fix it on?

Used:

SQL Server 2008 R2

System Centre Service Manager 2012

Thanks in advance.

M Ahsan

re: How to Slice Incidents by Days, Months, Quarters

Chris Jones [MSFT] — Tue, 12 Mar 2013 16:21:27 GMT

If you use this MP, you'll want to run the PS script below to correct an issue w/ the DateDim and the month ordering when using PerformancePoint time intelligence.

After this MP has been added, If you launch SSMS and connect to the Analysis Server, in the dimensions, you'll see the DateDim dimension. If you right click on that and hit Browse, you can expand the any of the fields and notice that the months are ordered alphabetically. The problems comes in when using PerformancePoint and Time Intelligence to build out metrics and KPIs. Since the months are not ordered properly our time ranges get messed up. For instance, if i wanted to show the previous 72 hours, I'd have to use the following formula: (Month-2).day:day-3. This would have to be updated monthly to keep the data accurate. The blog below explains the correction script (published by the MS DW team).

Script/Blog:

blogs.technet.com/.../month-ordering-by-calendar-sequence-when-slicing-measures-by-calendarmonth.aspx

re: How to Slice Incidents by Days, Months, Quarters

Ashraf — Mon, 04 Mar 2013 09:46:44 GMT

Hi,

We have really been quite happy with this MP in our environment, it helps a lot with reporting. However, I have one concern, especially now that I am designing dashboards. For some reason the months for 2013 are coming in alphabetical order! That is, you get Feb, Jan and then Mar!! So, when I use a Time Intelligence Filter on Dashboard Designer, and when I filter for "Previous Month" for instance, and assume we are in Mar 2013, then the previous month is considered to be Jan in this case!

Is it possible to fix this, PLEASE?!

Thanks

Ashraf

re: How to Slice Incidents by Days, Months, Quarters

Ten — Wed, 20 Feb 2013 21:19:33 GMT

Hi,

If I change the id to <ID>ServiceManager.ChangeManagement.Library.Datawarehouse</ID> in the xml, would it work or would i have to take out the token. I would like to slice change requests as well.

re: How to Slice Incidents by Days, Months, Quarters

Atchut Barli — Sat, 12 Jan 2013 02:41:42 GMT

Hi Daniel,

Its not fixed with SP1, it will work with the service pack or updates other then the PS script need to be rerun as noted in the post.javascript:WebForm_DoPostBackWithOptions(new WebForm_PostBackOptions("ctl00$content$ctl00$w_72134$_bf6215$ctl00$ctl00$ctl00$ctl05$bpCommentForm$ctl05$btnSubmit", "", true, "BlogPostCommentForm-ctl00_content_ctl00_w_72134__bf6215_ctl00_ctl00", "", false, true))

re: How to Slice Incidents by Days, Months, Quarters

Daniel — Wed, 09 Jan 2013 05:14:01 GMT

do you know if this will be fixed by Microsoft in future update? I'm a bit reluctant to add custom changes.

will it work with new updates / service packs released?

or can this change be rollback in case it doesn't work?

re: How to Slice Incidents by Days, Months, Quarters

Will — Mon, 17 Dec 2012 05:28:02 GMT

Thanks for this, I've been able to make a really nice report for Incidents now. Is there going to be one for Service Requests as well?