How to do it...

Follow these steps to create the KPI:

  1. Create a new item; select Analytics from the left-hand list and Key Performance Indicator from the right.
  2. Set the Name field to ConWHSVehicleServiceThisMonth and press Add.
  3. Drag the ConWHSVehicleServiceMeasure aggregate measure from the project onto the KPI. This sets the Measurement property for us.
  4. Complete the remaining properties, as follows:

Property

Value

Label

Service orders

Bad Threshold

20

Good Threshold

1

Scoring Pattern

LessIsBetter

Menu Item Name

Must leave this blank

  1. On the Value node, set the properties as follows:

Property

Value

Measure Group

ServiceInformation

Measure

ServiceRecords

We are basing our KPI on the number of service orders in a month.
  1. Expand the Value node, and add a new range to the Ranges node and configure the properties, as shown here:

Property

Value

Dimension

ServiceDate

Attribute

Month

Name

MonthRange

The default Period is Current, and the KPI will know that we mean the current period based on the Attribute property.
  1. We can now add trends. Under the Trend node, create a new trend and set the properties as shown here:

Property

Value

Dimension

ServiceDate

Attribute

Week

Name

WeeklyTrend

Item Count

10, this means 10 weeks in this case

Label

Weekly trend

  1. Now, we should create the top trend, which shows the top n contributory factors to the value. Complete the new trend as follows:

Property

Value

Trend Type

TopTrend

Dimension

ConWHSVehicles

Attribute

VehicleGroupDescription

Name

TopTrend

Label

Vehicle groups

Item Count

5, this means the top 5 vehicle groups

  1. Finally, let's add a bottom trend, which is done as follows:

Property

Value

Trend Type

BottomTrend

Dimension

ConWHSVehicles

Attribute

VehicleGroupDescription

Name

BottomTrend

Label

Vehicle groups

Item Count

5, this means the bottom 5 vehicle groups

We will choose a different measure for this, but we can use the same measure for both.
  1. You can create multiple trends of each type, and they will appear as options to the user. Try and create a top trend for vehicle types.
  2. Save and close the designer.

To test our KPI we should create a tile for the KPI so we can add it to a workspace. This is done by the following steps:

  1. Create a new tile called ConWHSVehicleServiceThisMonthTile.
  2. Drag the ConWHSVehicleServiceThisMonth KPI onto the tile in the designer. This sets the Type property to KPI and the KPI property to ConWHSVehicleServiceThisMonth.
  3. Set Label to Vehicle service orders and the Size property to Wide.
  4. Save and close the designer.

Add the tile to the vehicle management workspace form:

  1. We will need to add this to a workspace. Locate the ConWHSVehicleWorkspace form in Application Explorer.
  2. Right-click on the form and choose Create extension.
  3. Change the suffix so that it is named ConWHSVehicleWorkspace.ConAnalytics.
  4. Open the form in the designer.
  5. Right-click on the PanoramaSectionTiles tab page and choose New | Tile Button.
  6. Set the Name and Tile properties to ConWHSVehicleServiceThisMonthTile.

Build the project and synchronize the database:

  1. Right-click on the project and choose Properties.
  2. Change Synchronize Database on Build to True.
  3. Press OK.
  4. Build the project.

To test the KPI, follow these steps:

  1. Open the Operations client; in our case, we can just open the following URL:

https://usnconeboxax1aos.cloud.onebox.dynamics.com/?cmp=usmf&mi=ConWHSVehicleWorkspace

  1. If you receive an error that the KPI does not exist, rebuild the project with the Synchronize Database on Build project property set to True.
  2. The KPI will display with no data; to set this up, navigate to System administration | Setup | Data cache | Data cache parameters.
  3. Select the Cache refresh tab page.
  4. If you have a batch group set up for system jobs, enter this in the Batch group field; otherwise, leave it blank.
  5. Click on Initialize batch job.
  6. Open System administration | Inquiries | Batch jobs.
  7. The batch job, Data cache refresh batch, will be in the list and will remain executing. This may seem unusual for batch jobs, as they normally have a recurrence; however, this job runs continuously.
  8. If the batch job is not executing, ensure that the Microsoft Dynamics 365 for Operations Batch Management Service windows service is running.
  9. Wait around a minute for the data to process and test the workspace again.

Testing the workspace:

  1. First, you should create some test data so we can test if our KPI works correctly. We will probably need around 30 orders for multiple vehicle types and groups.
  2. The KPI tile contains a concise summary of the KPI and will resemble the following screenshot:
  1. If you click on the tile, you are taken to the KPI view.
  2. In this view, the user can change the defaults we supplied in the KPI, change the trend views, and apply different filters to those supplied. The view should look like the following screenshot:
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.217.190.58