Facility Management
Facility Management
Facility Management
Microsoft Dynamics AX
®
Facility Management
Prerequisites............................................................................................... 8
Microsoft Dynamics AX 2012 .................................................................................................. 8
Enterprise Portal ................................................................................................................... 8
Microsoft SQL Server Reporting Services.................................................................................. 8
Microsoft SQL Server Analysis Services .................................................................................... 8
Contoso Demo Data .............................................................................................................. 8
Role Center
The Facility Management application provides a Facility Manager role center profile and
corresponding role center page. Users who are assigned to the Facility Manager role center
profile will see this role center page as the default page in Microsoft Dynamics AX and in
Enterprise Portal.
List Pages
The Facility Management module contains two List Pages. One displays room information.
The other displays work order information.
Other forms, such as Facility Management parameters, are used to configure the
application.
Reports
The Facility Management module has reports such as a Room List and Work Order List.
Enterprise Portal
If you want to use the Facility Manager role center or web resources for the Facility
Management sample application, you must have Enterprise Portal installed and configured.
Location URL
CustomerSource https://mbs.microsoft.com/customersource/downloads/servicepacks/microsoftdynamicsax2012.htm
PartnerSource https://mbs.microsoft.com/partnersource/deployment/resources/productreleases/microsoftdynamicsax2012.htm
To use the .xpo file to install the Facility Management Sample, complete the following
procedure.
1. Start Microsoft Dynamics AX. Be sure that you are logged in as a user with
administrative privileges in Microsoft Dynamics AX.
6. In the Import window, click Browse. Locate the Facility_Management.xpo file for
the sample application and click Open.
7. Mark the Show details check box. This allows you to see the resources that are
being imported into Microsoft Dynamics AX.
9. During the import operation, messages will be displayed for each of these resources
because they already exist in another layer. Click Yes for each of these resources:
Microsoft Dynamics AX will also compile the code for the resources that were
imported. This can take a few minutes, with pauses between the compiling steps.
During that time, you will see several compiler errors. These will be resolved during
the compiling process. At the end of the process you will see approximately 8
compiler warnings. These issues will not affect the Facility Management Sample. You
will also see that the tables for the Facility Management Sample are synchronized,
making them ready to store data in the database.
10. Close and re-open the Microsoft Dynamics AX client. If you view the items in the
Navigation Pane, you should see the Facility management module listed.
You may want to use the Navigation pane options form to move the Facility
management module to a more convenient location in the Navigation Pane.
10
4. Click Next. The number sequences to be created will be listed, including those for
the Facility Management sample.
5. Click Next. The number sequences that will be created are listed.
11
2. In Microsoft Dynamics AX, choose System administration > Common > Data
export/import > Import.
3. Click the folder next to the File name field. Select the FCM_Sample_Data.dat file in
the FCM Sample Data folder for the Facility Management sample and click Open.
4. Click OK.
5. A message will be displayed that indicates importing data can cause errors. Click Yes
to continue. The data will be imported.
6. The Infolog should indicate that 44 records were imported. Click Close.
1. Be sure that you have selected the company that you imported Facility Management
setup data into. Typically, this will be the CEU company from the Contoso Demo
Data.
2. In Microsoft Dynamics AX, choose Facility Management > Setup > Facility
management parameters.
4. Click Work Orders and set the Work Order default values.
5. Click the Number Sequences tab and specify the number sequence code to use for
Work Order Number. Typically, this value will already be set.
6. Click Close.
12
5. Locate the node for the Rooms report. Right-click this node and then click Deploy
Element. After a few moments, the Infolog will indicate that the report was
deployed.
6. Locate the node for the WorkOrders report. Right-click this node and then click
Deploy Element. After a few moments, the Infolog will indicate that the report was
deployed.
Deploying Help
To deploy help topics for the Facility Management sample, complete the following steps.
1. Locate the FCM Sample Help folder that is included with the Facility Management
sample. Open this folder. In it, you will find the FacilityManagement folder. Right-
click the FacilityManagement folder and then click Copy.
2. On the help server, locate the Content folder. This folder is typically found in the
following location:
C:\inetpub\wwwroot\DynamicsAX6HelpServer\Content
You must have Write permission to this folder to be able to add content to it.
3. Right-click the Content folder and then click Paste. The FacilityManagement folder
and all of its content are added to the Content folder.
4. Allow the content to be found. It will take a few moments for the new help content to
be found by the Windows Search Service. After the content is indexed, you will be
able to see it in the Help viewer.
13
4. Deploy the Facility Management module. Right-click the Web > Web Modules >
Home > Facility node, and choose Deploy Element. After a few moments, an
Infolog message will indicate the module was successfully deployed.
5. Deploy the Web pages for the Enterprise Portal integration. In the AOT, expand the
Web > Web Files > Page Definitions node. In the list of pages, right-click each of
the following pages and then click Deploy Element.
FacilityAreaPage
FCMAvailableCubiclesEPListPage
FCMAvailableOfficesEPListPage
FCMClosedWorkOrders
FCMNotInServiceEPListPage
FCMOpenWorkOrders
FCMRoomsListPage
FCMWOrkOrdersListPage
RoleCenterFacilityManagement
RoomAddEdit
RoomDetails
RoomsList
RoomsReport
RoomWorkOrderList
WorkOrderAddEdit
WorkOrderDetails
WorkOrdersList
WorkOrdersReport
6. Deploy the Web controls for the Enterprise Portal integration. In the AOT, right-click
the Web > Web Files > Web Controls node and choose Deploy Element.
7. In the Development Workspace, choose Build > Generate Incremental CIL. After
a few moments, the Infolog will indicate that CIL generation is complete. This step is
necessary so that the cues will display properly for the Facility Management sample.
8. Reset IIS to ensure the additional resources are found by the Enterprise Portal
server. To do this, open a Command Prompt with administrative privileges. Type the
following command:
iisreset
9. Initialize the FacilityManagement role center profile. The initialization process adds
the Facility Management role center profile, and also deploys the cues and Quick
Links for the Facility Management application.
In Microsoft Dynamics AX, choose Organization administration > Setup > Role
center > Initialize role center profiles. Click Unselect all. Mark the
FacilityManagement Profile ID and click OK. In any dialog boxes that are displayed to
indicate resources will be overwritten, click Yes to All.
14
11. Select the FacilityManagement profile, and then click the Users tab. Click Add user.
In the Add user window, select the user and companies. Click OK. Close the User
profiles form. When the user accesses Microsoft Dynamics AX or Enterprise Portal,
they should see the Facility Management role center page.
Configuring Security
To configure security for the Facility Management sample, you will assign users to specific
Facility Management roles. The following table lists the roles that are included in the Facility
Management sample:
Role Description
FacilityManager The manager of the facility. This user can perform all actions in Facility
Management.
The following table lists the actions that can be performed by users that are assigned to
each role:
Maintain Work
Create Rooms
Delete Rooms
Manager Role
View Facility
Create Work
Delete Work
View Rooms
View Work
Maintain
Role
Rooms
Orders
Orders
Orders
Orders
Center
FacilityManager X. X X X X X X X X
FacilityMaintainer X X X X
FacilityUser X X X
1. In Microsoft Dynamics Ax, choose System administration > Common > Users >
Users.
4. In the Assign roles to user form, locate one of the roles for Facility Management.
Select the role and click OK.
15
1. Be sure that you have selected the company that you want to use workflow with.
Typically, this will be the CEU company from the Contoso Demo Data.
3. Click New.
4. In the Create workflow window, select Work order approval workflow and click
Create workflow. The workflow configuration window is displayed.
6. In the Properties form, click Basic Settings. Set the following values:
Click Close.
7. In the Workflow elements group of the toolbox, drag the Work Order Approval
element to the canvas in between the Start and End nodes.
8. Double-click the new work order approval element. Then, right-click on Step 1 and
select Properties.
9. In the Properties form, click Basic Settings. Set the following values:
10. In the Properties form, click Assignment. In the Assignment type tab of the
Assignment pane, select Participant.
11. Display the Role based tab. Set the Type of participant to Security role
participants. In the Participant list choose Facility manager.
12. In the Properties form, click .Notifications. Mark the Enabled check box for the
Approve event.
16
14. Click the Recipient tab. In the Assign users to this notification list, choose
Participant.
15. Click the Role based tab. Set the Type of participant to Security role
participants. In the Participant list choose Facility maintainer.
17. In the bread crumb area, click Workflow to navigate back to the main workflow
definition.
18. In the Workflow elements group of the toolbox, drag the Work Order Verified
element to the canvas in between the Start and End nodes.
19. Right-click the new work order verified element and then click Properties.
20. In the Properties form, click Basic Settings. Set the following values:
21. In the Properties form, click Assignment. In the Assignment type tab of the
Assignment pane, select Participant.
22. Display the Role based tab. Set the Type of participant to Security role
participants. In the Participant list choose Facility manager.
24. In the editor, drag a line from Start to Work Order Approval.
25. Drag a line from Work Order Approval to Work Order Verified.
17
27. Click Save and close to exit the workflow designer form.
28. Enter a description for the Version notes field and then click OK.
29. In the Active workflow dialog box, select Activate new version and click OK.
Setting up Search
The rooms and work orders that are part of the Facility Management sample can be
made accessible through Enterprise Search for Microsoft Dynamics AX. If you have
Enterprise Search configured for Microsoft Dynamics AX, complete the following
procedure to include rooms and work orders in the search content.
1. In Microsoft Dynamics AX, choose System administration > Setup > Search >
Search configuration. The Enterprise search configuration window will open.
Click Next.
2. Choose the Business Data Connectivity Service Application and the Search
Service Application that you want to use. Click Next.
3. Select the queries that you want to use for the search content. You will see the
Rooms and Work Orders queries in the list. Select these queries.
4. Select the option to start a full crawl, and then click Next.
6. After several moments, a dialog box with the search configuration status will be
displayed. After the search crawl is completed, you will be able to search for room
and work order information.
18
3. In the Development Workspace, click Tools > Business Intelligence (BI) tools >
SQL Server Analysis Services project wizard.
4. The SQL Server Analysis Services project wizard appears. Click Next.
7. Select Deploy the project. Select Create new database and use the name FCM.
8. Select Process the project after it is successfully deployed. Click Next. The
database will be created and the cube will be processed.
Role Center
If your Microsoft Dynamics AX system has Enterprise Portal installed, and you completed
the Enterprise Portal setup for the Facility Management sample, you can view the role
center for Facility Management. To do this, assign a user to the FacilityManagement role.
1. In Microsoft Dynamics AX, choose System administration > Common > Users >
Users. The Users list is displayed.
4. Click the Users tab. The users currently assigned to the FacilityManagement user
profile are listed.
19
7. Click OK.
When the user you specified views the Home page in Microsoft Dynamics AX, the role center
page for Facility Management will be displayed.
Area Page
To display the Area Page for the Facility Management sample, click the Facility
Management button in the Navigation Pane. Then click the Area page link to display the
area page.
Use the links on the page to access the forms and reports for the sample.
You can save the filter by choosing Save As Filter from the menu for the list. The filter will
appear as a choice in the menu.
20
Workflow
If you completed the workflow setup for the Facility Management sample, you can send a
work order through the Work Order Approval workflow. To do this, complete the following
procedure.
1. Verify that you have logged into Microsoft Dynamics AX as a user who is part of the
System administrator role.
2. Display the Workflow processor form. In Microsoft Dynamics AX, choose Facility
Management > Setup > Workflow processor.
4. From another system, log in to Microsoft Dynamics AX as a user who is part of the
Facility User role. The members of this role can submit work orders to workflow.
5. Choose Facility Management > Common > Work Orders > All work orders to
open the Work Orders list.
6. Select a work order that is in the “Not submitted” state. The workflow bar should be
displayed, along with the Submit button.
7. Click Submit. Supply a comment for the submission, and then click Submit.
As the work order is processed by workflow, you should see a message in the
Workflow processor on the system where you have this form open.
21
9. Assume that this is a valid work order, and choose Approve from the Actions
menu. Add a comment, and then click Approve. Allow a few moments for the work
order to move to the next stage of the workflow. When you refresh the view, you will
see that the work order has moved to the work verification stage.
10. In this stage, the work will have been performed, and the details added to the work
order record. At this point, a user in the Facility Manager role examines the details of
the work performed and verifies that the work has been completed. The manager
may also indicate that no verification is needed. For this example, assume that the
work was verified. Choose Completed from the Actions menu. Add a comment, and
then click Completed. Allow a few moments for the work order approval to be
processed. When you refresh the view, you will see that the work order has reached
the completed state.
The workflow state for the work order has been changed to “Completed”.
The Verified field has also been set to “Yes” by the workflow processing code.
Enterprise Portal
If your Microsoft Dynamics AX system has Enterprise Portal installed, and you completed
the Enterprise Portal setup for the Facility Management sample, you can use it to perform
tasks for the Facility Management application. Begin by clicking the Facility tab to display
the Facility home site page.
22
List pages
In the list of rooms or work orders, you can perform actions for the item selected in the list.
Simply choose an item from the action pane for the list.
For instance, to assign a room to an employee you would perform the following procedure.
1. Display the Rooms list page and select a room in the list.
3. In the Worker field, use the lookup to display the list of workers. Select a worker,
and then click OK. The worker name will be displayed in the field.
5. Click Save and close to save the changes you made to the room. The Rooms list
page will be displayed. The changes you made should be shown in the list.
23
4. The Work order details page will display a workflow bar that allows you to perform
workflow actions for the selected work order. For example, you can display the
workflow history for the work order.
Analysis Services
If you have configured analysis services for the Facility Management sample, you can
implement the WorkOrderCost report, which retrieves data from the Facility Management
cube.
4. Expand the Visual Studio Projects > Dynamics AX Model Projects node.
5. Locate the WorkOrderCost node. Right-click this node and then click Edit.
6. Visual Studio® will open. In Solution Explorer, expand the WorkOrderCost project.
24
9. Right-click the AutoDesign1 node and then click Preview. After a few moments,
the report will be displayed. It should look similar to the following illustration:
10. If the WorkOrderCost report displayed correctly, you can deploy it to the report
server. In Solution Explorer, right-click the WorkOrderCost project, and then click
Deploy. The deployment process can take a few moments. The WorkOrderCost
report can be used like any other reporting services reports for Microsoft Dynamics
AX.
4. In the Middle Column section of the page, click Add a Web Part.
8. In the drop-down menu for the new report web part, click Edit Web Part. The
properties for the report web part will be displayed.
25
26
FCMWorkOrders
PK WorkOrderNum CHAR(10)
RequestDate DATETIME
Details CHAR(60)
FK1 RoomRecId LONG HcmWorkder
FK2 RequesterRecId LONG Requester_FK2
FK3 PerformedByRecId LONG PK RecId LONG
CompletedDate DATETIME
PerformedBy_FK3 PersonnelNumber CHAR(25)
CompletionNotes CHAR(60)
Verified INTEGER
Cost NUMERIC(32,16)
WorkflowState INTEGER
RecId LONG
Room_FK1
FCMRooms
PK RecId LONG AssignedTo_FK1
RoomName CHAR(30)
Description CHAR(60)
InService INTEGER
InitialServiceDate DATETIME
Size CHAR(10)
RoomType INTEGER
FCMPublicRooms FCMPrivateRooms
27
FCMWorkOrderWorkflowDocument Code that defines the query used for the sample
workflow.
Forms FCMAvailableCubiclesListPage Defines the Rooms list page that displays the
available cubicles in the facility.
28
Data Sets FCMRoomAddEdit Accesses room data for the RoomAddEdit page in
Enterprise Portal.
29
SSRS Reports Rooms The Room list report for Facility Management.
Reports WorkOrders The Work Orders report for Facility Management.
SSRS Reports WorkOrderCostOLAPData The data source for the WorkOrderCost report.
Report Datasources
Visual Studio Projects FCMRooms.BusinessLogic Defines the business logic and drill-throughs for
C Sharp Projects the Rooms report.
Visual Studio Projects FacilityManagement_EP Defines the User Controls for the Enterprise
Web Application Portal pages in the Facility Management sample.
Projects
Visual Studio Projects FCM Defines the analysis cube for the Facility
Analysis Services Management sample.
Projects
30
31
32
Menu Items FCMRoomsReport Opens the Rooms report. Used on the Facility
Output Management area page.
Menu Items FCMWorkOrderApprovalApprove “Approve” action for the approval portion of the
Action Work Order Approval workflow.
33
WorkOrderAdd Specifies the URL for the Add Work Order page.
WorkOrderEdit Specifies the URL for the Edit Work Order page.
34
FCMOpenWorkOrders The list page that displays the open work orders
in Enterprise Portal.
35
Web Modules Home Modification of the Home web module to add the
Facility web module.
36
37
The information contained in this document represents the current view of Microsoft Corporation on the issues discussed as of the
date of publication. Because Microsoft must respond to changing market conditions, this document should not be interpreted to be a
commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of
publication.
This document is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED, OR STATUTORY, AS
TO THE INFORMATION IN THIS DOCUMENT.
Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of
this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means
(electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of
Microsoft Corporation.
Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject
matter in this document. Except as expressly provided in any written license agreement from Microsoft, the furnishing of this
document does not give you any license to these patents, trademarks, copyrights, or other intellectual property.
38