42Q Home >Administration > MESWeb Central

MESWeb MESWeb Central Version MES15 Portal 1.0 Work Instruction

This Work Instruction is 42Q's corporate standard. This document is under revision control. The latest revision is located on Intranet. Once printed it is an uncontrolled copy. All alterations to this work instruction require approval. Contact the IT Global Education and Training Department to submit suggested alterations and or updates.

This edition applies to MES15 Portal 1.0 Application and all subsequent releases and modifications until otherwise indicated in new revisions.

Introduction

MESWeb is a powerful business intelligence application designed from the ground up to simplify reporting from manufacturing execution systems, and empower end users with a streamlined and full-featured web interface. The application includes an ad hoc report design tool that allows users to easily build their own reports and modify existing ones with little to no training. Also, create rich, customized reports from heterogeneous data sources.

Decentralized custom reports, redundant data, lack of pop up security controls, and convoluted development requirements are problems faced by all 42Q s, and MESWeb has been designed to resolve these issues while maximizing usability and performance.

The purpose of this application is to manage the permissions for every report in our MES Web application. It provides 42Qâ€™s with an easy mechanism for managing users, roles, applications, services and the relations among them.

Administration

There are 2 types of roles in MESWeb, the first type grants certain permissions to the user in the Central module and those are:*

Administrator: user with this role has full permissions to all locations in the Central module.
Security Manager: can grant access all kind of permissions except â€œAdministratorâ€ to other users and himself, including roles and reports.
Report Manager: this role has all permission in the Report Module but just for the specific Location assigned. (Create, edit, copy, publish reports)
Data Source Manager: this role has all permission in the Data source module but just for the specific Location assigned. (Create, edit, delete data sources)

The following roles will only take effect on the report execution:*

All MESR Customers: this role allows the user to see all customers of a specific location.
All data sources: this role allow users to see all data sources of a specific location.
All Reports: this role allows the user to see and execute all reports available in a specific location.

This section will cover how to navigate and execute all location, data source, and custom reports activities. With this portlet, the user can add, edit or delete locations, servers, data sources, and data source types. The user can also access report group maintenance to perform searches, create, edit or delete report groups and add s to report groups. Report maintenance also allows the user to create, edit, or delete reports. The user can also publish/unpublished reports.

To access MESWeb,

navigate to Administration > MESWeb Central
Select the Administration icon located on the MESWeb Central Main page.

Figure 1: MESWeb Central Administration

Upon selecting the Administration icon, four additional icons become available: Locations, Data Sources, Reports, and Report Groups.

Figure 2: Administration Functions

Once an icon is selected, it is placed in a tab at the top of the Administration Page. The user can navigate between icons by placing them in tabs that can be easily accessed.

Figure 3: Functions in Tabs

Locations

Definition: Location is a specific site or plant.

This function allows Administrators to add, edit, or delete locations. Also located in this module is the ability to add, edit, or delete location.

Filter Locations

The filtering option located in the Locations tab allows the Administrator to search for specific locations based on their name and/or domain. The list displays empty and the user need to search to load the data in the page.

To filter the list, enter the location name and/or select the domain from the drop-down box provided.
Select Search to filter the name list.
Select Clear to clear entries.

Figure 4: Filter Locations

Image4.jpg

Add Location

This function allows the Administrator to add a location based on the name, server, domain, time zone, and culture of the location.

To add a location, select Add located above the name list in the Locations tab.
Enter the location Name, Server,Domain, Time Zone, and Culture. All fields are mandatory.
Select Save to confirm or Cancel to exit.

Figure 5: Add Location

Image5.jpg

After all information has been entered and saved, the new location will be placed on the name list on the main screen of the Locations tab.
After creating the location, a report group (Default Reports) is created (for this created location) and all predefined reports are assigned to this report group.

Edit Location

This function allows the Administrator to edit any location's name, server, domain, time zone, and/or culture.

To edit a location, select the desired location from the name list and then select Edit.
The Location Detail pop up displays. All fields are available to edit. After changing the desired information, select Save to confirm.
Select Cancel to exit.

Figure 6: Edit Location

Image6.jpg

The changes to the location will appear in the name list on the main screen of the Locations tab.

Delete Location

This function allows the Administrator to delete a location from the Location Name list.

To delete a location from the location name list, select the desired location and then select Delete.
A confirmation prompt will display. Select Yes to confirm deletion or No to cancel.

Figure 7: Delete Location

Image7.jpg

The location will be removed from the name list on the main screen of the Locations tab.

NOTE: It is not allowed to delete a location if data sources, report groups, reports or user permissions are created for this location.

Server

Definition: Server is where the MESWeb Execution application is installed.

The Server function located in the Locations tab allows the administrator user to add, edit or delete the servers that will be available for all locations.

To access the server function, select the Server icon located on the right of the main screen under the Locations tab.

Figure 8: Server

Image8.jpg

A server list displays containing all previously created servers listed numerically and alphabetically.

From this screen, the Administrator can add, edit or delete a server.

Figure 9: Server List

Image9.jpg

Add ServerName

To add a server, select Add located above the server name list.
The Server Detail pop up displays. Enter a name for the server and select Save.
Select Cancel to exit.
Once the server name has been entered and saved, the created server will appear in the server list.

Figure 10: Add a Server Name

Edit Server Name

To edit a server name, select the desired server name from the server list.
Select Edit located above the server name list.
The Server Detail pop up displays. After editing the server name, select Save to confirm.
Select Cancel to exit.

Figure 11: Edit Server

Image11.jpg

Delete Server Name

To delete a server name, select the server name from the server list.
Select Delete located above the server name list.
A confirmation message displays. Select Yes to confirm or No to exit.

Figure 12: Delete Server Name

Image12.jpg

NOTE: If the server has any location assigned, it not will be allowed to delete the server.

Data Sources

Definition: a given name to a database for a specific location. The reports will query data inside this database.

This function allows Administrators to add, edit, or delete data sources. Also located in this module is the ability to add, edit, or data source types.

Figure 13: Data Source List

Image13.jpg

Filter Data Sources

The filtering option located in the Data Sources tab allows the Administrator to search for specific data sources based on their location and/or name.

To filter the Data Source list, select the locations from the drop down box provided and/or enter the data source name.
Select Search to filter the Data Source list.
Select Clear to clear entries.

Figure 14: Filter Data Sources

Image14.jpg

Add Data Sources

This function allows the Administrator to add a data source based on the name, description, location, database type, and connection parameters associated to the database type.

To add a data source, select Add located above the Data Source list in the Data Sources tab. The details pop up displays.
Enter the data source Name, Description,Location,and theDatabase Type into the details pop up. All fields except the description field are mandatory.

Figure 15: Add Data Source

Image15.jpg

Depending on the database type (Database Type field), a subsequent Connection Parameters pop up displays below the details pop up. The information required in this pop up is dependent upon the Database Type selected. Enter the required information in to the Connection Parameters pop up.

Figure 16: Select Database Type

Image16.jpg

Figure 17: Conection Parameter

Image17.jpg

Add a DataSource in Central is easy. The user just needs to follow the steps.

Log in Portal -> Go to Administration -> Select MesWeb Central ->Select Data Sources -> Click Add button.
Fill out Name, Description, Location and Database Type.
The Database Types available are: MySQL, Oracle, Pervasive,Postgres SQL,SQL Server, according with the Database Type Selected. The screen will show the fields that the user needs to fill out to create the datasource connection.
Fill out Connection Parameters. The user has two options to fill out those fields:
The user can fill out the fields :Server, Port, Database, User and Password.
The user can fill out just the Connection String field. If the Connection String is valid, the fields Server, Port, Database, User and Password will fill out automatically. Example of the Connection String: jdbc:postgresql://p88meswebl1.sanmina.com:5432/bem?user=user&password=pass

The Connection String should have the following format.

SQL Server	jdbc:sqlserver://%Server%:%Port%;databaseName=%Database%;user=%User%;password=%Password%;encrypt=false
Oracle	jdbc:oracle:thin:%User%/%Password%@%Server%:%Port%:%Database%
MySQL	jdbc:mysql://%Server%:%Port%/%Database%?user=%User%&password=%Password%
Pervasive	jdbc:pervasive://%Server%:%Port%/%Database%?user=%User%&password=%Password%
Postgres SQL	jdbc:postgresql://%Server%:%Port%/%Database%?user=%User%&password=%Password%

SelectDataSource Type(s).
Click in Save button. If the parameters of the connection are correct, the Data Source will save, if not and error will show the error description.

Types: This is the schemas that the created data source has. Select the schemas dragging the items from one list to another.

Figure 18: Data Source -Types

Image18.jpg

Select Save to confirm or Cancel to exit

Edit Data Sources

This function allows the Administrator to edit the name, description and connection string of any data source.

To edit a data source, select the desired data source from the Data Source list located on the main page of the Data Sources tab.
Select Edit located above the name list.
The Data Source Details pop up displays. The name and description are available for editing. The Connection Parameters section is not available to edit, but the connection string below the connection parameters pop up can be edited.
After changing desired information, select Save to confirm or Cancel to exit.

Figure 19: Edit Data Source

Image19.jpg

NOTE: editing the Data Source, the Connection Parameters field will be displayed according to theDatabase Type chosen during the data source addition.

Delete Data Sources

This function allows the Administrator to delete any data source.

To delete a data source, select the desired data source from the name list located on the main page of the Data Sources tab.
Select Delete located above the name list.
A confirmation prompt will display. Select Yes to confirm or No to cancel.

Figure 20: Delete Data Source

Image20.jpg

Data Source Type

The Data Source Type function located in the Data Sources tab allows the administrator user to add, edit or delete the data source types.

To access the data source type function, select the Data Source Type icon located on the right of the main page under the Data Sources tab.

Note: if a data source type is deleted reports associated to it may not work correctly.

Figure 21: Data Source Type

Image21.jpg

A data source type list displays containing all previously created data sources listed alphabetically. From this screen, the Administrator user can add, edit or delete a data source type.

Add Data Source Type

To add a data source type, select Add located above the data source type list.
Enter a data source type and description, both mandatory fields.
Select Save to create Data Source Type.
Select Cancel to exit.

Figure 22: Add Data Source Type

Image22.jpg

Edit Data Source Type

To edit a data source type, select the desired data source type from the list.
Select Edit located above the Data Source Type list.
Both the name and description fields are available to edit. After desired changes have been made, select Save to continue.
Select Cancel to exit.

Figure 23: Edit Data Source Type

Image23.jpg

Delete Data Source Type

To delete a data source type, select the desired data source type from the list.
Select Delete located above the Data Source Type list.
A confirmation prompt will display. Select Yes to confirm or No to exit.

Figure 24: Delete Data Source Type

Image24.jpg

NOTE: It is not allowed delete a data source type if:#

If assigned to a data source;

If there is any report already created for this data source type;

Reports

The Reports Module was developed for employees with Security Manager (specific Location) and Administrator (all locations) roles. This section will cover how to navigate and execute all reports activities. The Reports module allows the user to edit copy or publish reports.

Filter Reports

The filtering option located in the Reports tab allows the Administrator or Security Manager users to search for specific reports based on the owner location, report group, name, owner user, data source type, and/or status.

To filter the report list, select an owner Location, Report Group, Data Source Type, and/or Status from the drop down boxes provided, or enter the Name and/or Owner User.
Select Search to filter the list or Clear to clear all fields.
The results will display in the report list.

Figure 25: Filter Reports

Image25.jpg

Note: just the Publish functionality is available for theReports module; the other functionalities are in WIP (work in progress) status.

Add Reports

This feature allows users to add reports that will be executed in the Execution Module.

Figure 26: Add Reports

Figure 27: Add Reports Basic

Image27.jpg

To add a report the user must enter all mandatory fields and go to the other configuration tabs too enter the necessary data to the report. Select Save to commit. For further information about these fields, see the respective modules (Location, Group (Report Group), and Data Source Type) in the Portal.

Note: Checking Private just the report owner will have permissions (open, edit, etc) for this report.

The default format will be the preselect format for the Execution Module, but it could be changed during the execution.

SQL Code

Figure 28: Report Maintenance: SQL Code Configuration

[[File:Image28.jpg|900px|Image28.jpg]

This feature allows the user to add a query and check if the query is valid by clicking on Check Code SQL. To add a parameter it is necessary to use the syntax: <%shop_order%>.

Parameters

At this point, the user will choose the parameters Types and Orders. For example, if the parameter will be a check box, a list box, text box, etc

The Report Maintenance page is displayed. Select Parameters tab to add a parameter.

Figure 29: Parameters

Image29.jpg

The first thing to be done is create a new parameter step. Parameter steps give us the ability to establish parent-child relationships between parameters.

Select "New Step"
With a new step in place we can begin adding our parameters.
Select â€œNew Parametersâ€ to configure the parameters;

Figure 30: New Parameter

Image30.jpg

There are three fields that are required of every parameter you setup:

Name is straight forward - what you type here is what will be used as the parameters caption. For example, "Customers" in the WIP Distribution report.

Instruction

The user will provide any important information for the end user regarding this parameter. In most cases this will be a very basic sentence such as "Indicate whether you want to see units that are in wip or not" that are already intuitive by just looking at the parameter. However, you might come across situations as you develop your reports where you create a parameter whose relationship to the report is not so obvious and this field will give you a great way to explain it to the user. The text enterered in this field will be displayed in this list.

Parameter Type

The Parameter Type Field will allow the user to choose the Type of parameter that will determine how this parameter is displayed. The available parameter types are listed below:

Drop Down List

Choosing this parameter type, the user will create a list according to the SQL code entered in the command line.

The Value field represents the value that will be replaced in the SQL Code.

Figure 31: Drop Down List Parameter

Image31.jpg

The user must enter the mandatory fields (Name, Instructions, Command, Data Type, Value Field, Display Field and the Parameter SQL).

Parameter SQL: this is where the developer selects the text in their report SQL that will be replaced by the values in the parameter they are currently creating. So if in their report sql they had "<%Customers%>" they would see an option in this field that would say "Customers". That's where the application would insert the customers the users select when they execute the report.

Data Type: this indicates what kind of data will be inserted. It is the value type (integer, string, date, and double);

Command: this is used to enter the SQL query that will fill the list with the data;

Value Field: this field is the column name. This value will be substituted in the SQL Code;

Display Field: this column name that will be displayed to the user;

Required: this field defines if the field is mandatory or not;

Note: The Optional Item section will be displayed if the Required field is not checked and it will be used to remove or replace code lines in the SQL Code in the Execution Module. This action is the same for all parameters types.

Check the All Option check box if you want to add an option to choose â€œAllâ€œitems in the list.

Figure 32: Optional Item

[[File:Image32.jpg|900px|Image32.jpg]

Select Add to open the maintenance screen.

Figure 33: Optional Item Maintenance

Image33.jpg

For example, the user can remove the <%location%> command and replace it for any value he wants.

Select Save to commit.

During the report execution, if no value is entered for this command, it will be replaced or removed automatically.

Also, the user can Edit or Delete items by clicking on Edit / Delete buttons. Select Save to commit.

Figure 34: Parents

Image34.jpg

Add Parent Parameter is a functionality that helps to share parameters between steps.#

Create a new Step;

Create New Parameter, fill out Parameter Name, Parameter Type, etc;
Click Add Parents in order to be able to use a parameter from other step. In this case we have available the Data Source parameter because is the parameter in step 1;
Now the useer can use the parent parameter to write a query in Command field.

The parents are the paramters created in the previous steps and they could be used in the command query.

For example:

select ***** where *** = <%param_2%>

where the tag <%param_2%> which is releated to the selected parent parameter (choosen as parent).

Figure 35: Add Parents

Image35.jpg

List Box

Choosing this parameter type, the user will create a â€œMultiple Choose Listâ€ according with the SQL code entered in the command line.

Figure 36: List Box

Image36.jpg

The user must enter the mandatory fields (Name, Instructions, Command, Data Type, Value Field, Display Field and the Parameter SQL) already described and:

Rows: this allows developers to configure how many rows the user can see in the boxes at a time. When's there's going to be several hundred choices for the user it might help for them to select a higher number making it easier to search through all of them;

Select Maximum: this puts a limit on how many items the user can select in the parameter. If there are maybe 10,000 options for the user to choose you wouldn't want to allow them to select that many;

Max Exceeded Msg: message that will be displayed if the user tries to select more data that was set in the Select Maximum field.

It is the same for options. The user must enter the mandatory fields (Name, Instructions and the Parameter SQL).

Data Range

This option is used to set a range of date.

Figure 37: Data Range

Image37.jpg

The user must enter the mandatory fields (Name and Instructions) already described;

Start SQL: it is the parameter name that will be substituted for the initial date range;

End SQL: it is the parameter name that will be substituted for the final date range;

Max Day Range: it is maximum quantity of days in the initial and final date range;

Display Time: Choosing this check box, the field to choose the time is displayed;

Date Time

This parameter type will allow the user to choose date and time.

Figure 38: Date Time

Image38.jpg

The user must enter the mandatory fields (Name, Parameter SQL and Instructions) already described;

Check Box

This will allow the users to choose values (Yes or No, On or Off or True or False).

Figure 39: Check Box

Image39.jpg

The user must enter the mandatory fields (Name, Parameter SQL and Instructions) already described;

Text Box

This allows the user to set any text entry.

Figure 40: Text Box

Image40.jpg

The user must enter the mandatory fields (Name, Parameter SQL and Instructions) already described;

Default Value: this is the initial value that will be displayed in the Execution Module.

Validation: it will allow the user to add a validation for this field (Text Box).

Figure 41: Validation Field

Image41.jpg

There are four validation types:

Data Type Validation

Figure 42: Validation: Data Type

Image42.jpg

If the user enters a different value chosen in the Data Type, the field will be invalid and an error message that was configured in the â€œError Msgâ€ field is displayed.

Expression Validation

Figure 43: Validation: Expression

Image43.jpg

Choosing the Expression as validation, the user is able to add an expression (e.g. /^[a-zA-Z0-9][a-zA-Z0-9\._-]+@([a-zA-Z0-9\._-]+\.)[a-zA-Z-0-9]{2}/)).

If the user enters a different value that is not accepted for the expression, the field will be invalid and an error message that was configured in the â€œError Msgâ€ field is displayed.#

Range Validation

Figure 44: Validation: Range

Image44.jpg

Choosing the Range as validation, the user is able to set a value interval with maximum and minimum values that is configured in the Min. Value and Max. Value fields.

If the user enters a different interval that is not accepted for the expression, the field will be invalid and an error message that was configured in the Error Msg field is displayed.

Value Validation

Figure 45: Validation: Value

Image45.jpg

Choosing the Value as validation, the user is able to set a validation for Operator (combo box) that defines which comparison will be done as displayed in figure 44.

Figure 46: Operator Field

Image46.jpg

Compare to field will receive the value to be compared with the value entered by the user.

If the user enters a different value that is not accepted for the comparison, the field will be invalid and an error message that was configured in the Error Msg field is displayed.

Multi-Line Text Box

It is like the Text Box, the difference is that the user can enter with Multiple Data. Each data must be in different lines.

Figure 47: Multi-Line Text Box

Image47.jpg

Input Limit will define the quantity of data can be entered.

Checking the Is Case Sensitive will allow distinguishing Lowercase and Uppercase.

Radio Button List

Choosing the Radio Button parameter type, all result of the SQL Code configured in the Command field will be a radio button.

Figure 48: Radio Button List

Image48.jpg

Note: The user will be able to select just one Radio Button.

Select Save Parameters to commit.

Note: If there is just one parameter created for a step and the user remove this parameter, the step will be automatically removed.

Drill Down

Drill Down is a link to another report. It is used to see detailed data in a separated report.

Figure 49: Drill Down

Image49.jpg

Add Drill Down

To add a DD report, select the Drill Down tab and click on Add button;

Figure 50: Add Drill Down Report

Image50.jpg

Current Report Column

It is possible to create one drill down report per column. All available parent report columns are displayed in the combo box list.

Child Report

It will display just reports that have the same data source type and were published in the same location of the parent report.

When the user selects a Child Report, all their parameters will be displayed in the list to be set the values that the parameters will receive when the report is executed. For each parameter, there are three values types that could be set as follow:

No index entries found.

Figure 51: Static Value

Image51.jpg

Static: will set a fixed value to the DD report parameter;

Figure 52: Field Value

Image52.jpg

Field: it will be the link value of the parent report that will be displayed in parameter field in the DD report;

All parent report columns will be displayed.

Figure 53: Parent Parameter

Image53.jpg

Parent parameter: the value of a parameter in the report already chosen as the main will be displayed in the parameter field of the DD report;

All parent report parameters will be displayed.

To finish, click on Save button or Close to cancel de action.

Remove Drill Down

Figure 54: Remove Drill Down

Image54.jpg

To remove a drill down, select the report and click on Remove button. Click on Yes to confirm orCancel to cancel the action.#

Testing

It is useful test the reports before publishing, to do this, after create a report, select Testing tab.

Figure 55: Testing Reports

Image55.jpg

Note that for each step, there are instructions displayed according to what were defined in the Instruction field.

Step1

This step will be the Data Source according to the Location and Data Source Type already configured.

Figure 56: Step1

Image56.jpg

NOTE: If there is just a single option of data source, it will be automatically displayed. Select Next Step to continue.

Step2

This is the first step created in the Parameter tab. The parameters that will be displayed in step2 are the ones defined according to the Parameter Type chosen.

Figure 57: Step 2

Image57.jpg

Output

Note: If there is no other step created, the Output is displayed. Select Go to see the result.

Figure 58: Report Result

Image58.jpg

NOTE: To execute a drill down report, click on the displayed link.

Summary

Go to Summary tab to publish the report.

Figure 59: Summary

Image59.jpg

Here the user will see the information about the report, the SQL Code and the parameters. This page canâ€™t be edited, it just bring the report summary.

1. Would you like to publish this report? Select Yes, I want to.

2. The message should be displayed: Thank You

Your report is now published and ready to be executed in the production environment.

Edit Reports

The Edit Report page is the same for Add Reports. See bellow the exceptions:#

If the report was already published, the Owner Location canâ€™t be updated;

If the report was already published, Summary page message is: â€œWould you like to update this report?â€ Clicking on â€˜ Yes, I want toâ€ a new version of this report is created.

Note: The user is able to edit several reports at the same time.

Copy Report

To copy a report, select the report and select Copy button.

The Copy Report page is displayed.

Figure 60: Copy Report

Image60.jpg

Enter the Mandatory fields and select Save to commit. The Edit page is displayed to make any update if necessary.

NOTE: Only Locations with the data source of the same type as this report are available to copy.

Publish Reports

To publish a report, select the report from the list and select Publish.

Note that Security Manager users are able to publish for locations that have assigned.

In this functionality, if the report was created and published from the Add or Edit for the chosen location, it will be available for publication for others. Otherwise, the Publish button will not available.

Figure 61: Publishing Reports

Image61.jpg

The Administrator user is able to:#

Update the report status that will define if the report will be displayed in the Execution module. Just the Active status will be displayed.

Choose the location and the report group to publish the report.

NOTE: Clicking on Test this Report will execute this report and an execution screen is displayed;

To remove the location, select the location and select Delete. The report is no more publish for the selected location.

NOTE: It is not allowed to delete the location that the report was created.

Figure 62: Test the Report: Execute

Image62.jpg

For further information about this page, see Testing tab.

Select Save to commit.

History Reports

Figure 63: History Report

Image63.jpg

This page displays all created report versions.

The version displayed in blue is the current version.

The user is able to rollback the version if there are old versions in the list selecting the version and clicking on RollBack button. The Edit page will be displayed and any update can be done. See Edit topic for further information.

Selecting any version and clicking on Execute button, the Execute page is displayed. See Test the Report topic for further information.

Predefined

The predefined reports code cannot be changed. This kind of reports is considered complex and their code are maintained for the MESWeb development team.

In the MESWeb Central Predefined functionality, the users are able to map or manage the reports (add and/or edit).

Figure 64: Mapping Predefined Reports

Image64.jpg

Administrator and Security Manager users are able to execute this function. Due to the chosen location, the users select the reports that the location will have access. These reports will be displayed in the Default Reports list of the chosen location.

Predefined Maintenance

Administrators and Security Manager users are able to execute this functionality and it gives access to chosen reports to others.

Edit Predefined Reports (Maintanance)

Just Administrator users are able to add Predefined Reports.

Figure 65: Edit Predefined Reports

Image65.jpg

Report Groups

With this submodule, the Administrator and Security Manager users can access report group maintenance to perform searches, create, edit or delete report groups and add reports to groups.

Filter Report Groups

The filtering option located in the Report Groups tab allows the Administrator user to search for specific report groups based on the location, name, and/or description.

To filter the report group list, select a Location from the drop down box provided, and/or enter the Name and/or Description.
Select Search to filter the list or Clear to clear all fields.
The results will display in the report group list.

Figure 66: Filter Report Groups

Image66.jpg

Add Report Groups

This function allows the Administrator to add a report group based on the report group name, description, and location.

To add a report group, select Add located above Report Group list.
The Report Group Detail pop up displays.

Figure 67: Add Report Group

Image67.jpg

Enter the Report Group Name and Description and select a Location from the drop down box provided. All fields are mandatory.
Select Save to confirm addition.
Select Cancel to exit.
The new report group will appear alphabetically in the report group list.

Edit Report Groups

This function allows the Administrator and Security Manager users to edit a report groupâ€™s name, description, and/or location.

To edit a report group, select the desired report group from the list.
Select Edit located above the report group list.
The Report Group Detail pop up displays.

Figure 68: Edit Report Group

Image68.jpg

NOTE: Location is a read only field.

After completing changes, select Save to confirm.
Select Cancel to exit without saving.

Delete Report Groups

This function allows the Administrator to delete a report group from the report group list.

To delete a report group, select the desires report group from the list.
Select Delete located above the report group list.
A confirmation prompt will display. Select Yes to confirm or No to exit.
The report group will be removed from the report group list.

Figure 69: Delete Report Group

Image69.jpg

NOTE: It is not allowed to delete a report group if:#

A report were created or published to the report group.

Any user has permission for this report group.

Add Report to Group

This function allows the Administrator to add a report to a report group by searching for its location and data source type.

To add a report to a report group, select the desired report group from the list.
Select Add Report to Group located above the report group list.

Figure 70: Add Report to Group

Image70.jpg

The Report to Group pop up displays. Search for the specific report by selecting the location and data source type of the report from the drop down boxes provided.
Select the search icon located to the right of the drop down boxes.
The report will display in the left Available column. To move the report to the Selected column, double-click or drag and drop the report.
Select Save to add the report to the report group.
Select Cancel to exit.

Access Control

The Access Control module was developed for employees with Administrator and Security Manager roles. This section will cover how to navigate and execute functions in Access Control. With the Access Control module, the Administrator is able to search, add, delete or edit users or user groups (will be developed).

To access MESWeb, navigate to Administration > MESWeb Central.
Select the Access Control icon located on the MESWeb Central Main page.

Figure 71: MESWeb Central Access Control

Image71.jpg

Upon selecting the Access Control icon, two additional icons become available: Users and User Groups.

Figure 72: Access Control Functions

Image72.jpg

Once either icon is selected, it is placed in a tab at the top of the Access Control page. The user can navigate between both icons by placing them in tabs that can be easily accessed.

Figure 73: User Icon in Tab

Image73.jpg

Users

The Users icon under the Access Control screen in MESWeb Central allows Administrators to manage user permissions and edit user information. With this portlet, administrators can assign Administrator permissions to specific users for assigned locations and edit the userâ€™s information.

1. 1. Filter Users

The filtering option located in the Users tab allows the Administrator to search for specific employees by User Name, Full Name, and/or Email.

To filter the User List, enter the desired User Name, Full Name, and/or Email address into the provided fields.
Select Search to filter users.
Select Clear to clear all fields.

Figure 74: Filter User List

Image74.jpg

1. 1. Manage Permissions

This function allows Administrators to assign Administrator permissions to users for specific locations.

To assign Administrator permissions to a user, select a user from the list by placing a check in the box to the left of the User Name.
Select Manage Permissions.
The User Permissions pop up displays.

Figure 75: User Permissions

Image75.jpg

With this pop up, the administrator can assign Administrator permissions to a user by checking the box to the right of the Administrator option.
Upon selecting a location, two panels display allowing the Administrator to assign Roles, Report Groups, Reports, Mesr Customers, Data Source, and Group Permissions to the user.

Figure 76: Assign Privileges (User Permissions)

Image76.jpg

To move an Available Role/Report Group/Report/Mesr Customer/Data Sources to the Selected column, double-click or drag and drop the selection.

NOTE: Under the Mesr Customers tab, the Administrator must first select a Data Source from the drop down box before moving customers to the selected column.

After moving all applicable selections in each tab, select Save to assign permissions to the user.
Select Cancel to exit.
The user will appear in the user list with the Administrator box selected.

1. Edit Users

This function allows Administrators to edit the following user information:*

Full Name

Email
Language (under development)
If Active
If Expires
Expiration Date
If Customer
Hide Main Navigation
Show Icons

To edit users, select the desired user from the user name list and then select Edit.

Figure 77: Edit Users

Image77.jpg

The User Search Detail pop up displays. All fields are available to edit except for the user name. Make desired changes and then select Save.
Select Cancel to exit.

Figure 78: User Search Detail

Image78.jpg

1. Import Users

This function allows Administrators to import several uses at the same time using the available Template.

Select the Import buttom and the Import Users dialog displays.

Figure 79: Import Users

Image79.jpg

Search the file and select it. It is possible to skip existing users or update them by selecting the radio buttons.

Selecting theGet Template button, the user gets a template that can be filled and imported with new users.

Figure 80: Import Users Template

Image80.jpg

User Groups

The User Groups icon under the Access Control screen in MESWeb Central allows Administrators to manage user Groups by add, edit, delete, manage users and manage permissions.

To access the User Groups, select theUser Groups icon in the left panel. The User Groups tab is displayed.

Figure 81: User Groups Main Page

Image81.jpg

1. Filter User Groups

The filtering option located in the User Groups tab allows the Administrator to search for specific groups by User Groups Name or Location.

To filter the User Group List, enter the desired Name, and/or Location into the provided fields.
Select Search to filter users.
Select Clear to clear all fields.

Figure 82: Filter User List

Image82.jpg

1. Add User Groups

This function allows the Administrator to add a user group based on the user group name, description, and location.

To add a user group, select Add located above User Group list.
The User Group Detail pop up displays.

Figure 83: Add User Group

Image83.jpg

Enter the Name and Description and select a Location from the drop down box provided. All fields are mandatory.
Select Save to confirm addition.
Select Cancel to exit.
The new user group will appear alphabetically in the report group list.

1. Edit User Groups

This function allows the Administrator and Security Manager users to edit a user groupâ€™s name and/or description.

To edit a user group, select the desired user group from the list.
Select Edit located above the User Group list.
The User Group Detail pop up displays.

Figure 84: Edit User Group

Image84.jpg

NOTE: Location is a read only field.

After completing changes, select Save to confirm.
Select Cancel to exit without saving.

1. Delete User Groups

This function allows the Administrator to delete a user group from the user group list.

To delete a user group, select the desired user group from the list.
Select Delete located above the user group list.
A confirmation prompt will display. Select Yes to confirm or No to exit.
The user group will be removed from the user group list.

Figure 85: Delete Report Group

Image85.jpg

NOTE: It is not allowed to delete a user group if:#

the user group has users assigned;

It is possible select more than a user group at the same time to make a massive delete.

1. Mapping User

These functionality map users to a selected group.

To map users, follow the stepes bellow:#

Select a group name in the list and select Mapping User;

The Mapping User pop up displays;
In the rigth side of the page, the filter will display the users registered in the system. Just move the user to the left side and it will be part of the group.
To remove users from the group, move the user to the right side.

Figure 86: Mapping User

Image86.jpg

1. 1. Import Users to Group

This function allows Administrators to import several uses at the same time using the available Template.

Select the Import button and the Import Users pop up displays.

Figure 87: Import Users to Group

[[File:Image87.jpg|900px|Image87.jpg]

Search the file and select it. It is possible to skip not found users or update them by selecting the available radion buttons.

Selecting theGet Template button, the user gets a template that can be filled and imported with new users.

Figure 88: Import Users Template

[[File:Image88.jpg|900px|Image88.jpg]

1. Manage Permissions

This function allows Administrators to assign permissions for groups.

To assign user group permissions, select a Name from the list by placing a check in the box to the left of the Name.
Select Manage Permissions.
The User Group Permissions pop up displays.

Figure 89: Manage PermissionsUser Group Permissions

Image89.jpg

Figure 90: Assign Privileges

Image90.jpg

To move an Available Role/Report Group/Report/Mesr Customer/Data Sources to the Selected column, double-click or drag and drop the selection.

NOTE: Under the Mesr Customers tab, the Administrator must first select a Data Source from the drop down box before moving customers to the selected column.

After moving all applicable selections in each tab, select Save to assign permissions to the user.
Select Cancel to exit.
The user will appear in the user list with the Administrator box selected.

Appendix A

Access Control

It is a module that will set the permissions for users and external customers of 42Q

administrator

the System Administration has full access to MESWeb - all s, all reports, all customers.

customer user

user for external customers to access the application

find username

for the "find" when we look up the username we use a web service at the Helpdesk, so it's finding something that's separate from MESWeb

MES Web

application that provides reporting capabilities through a web-based interface.

parameters

definitions for data, reports, or configurations.

roles

user profile inside MESWeb

SiteMinder

Universal login of 42Q

user

the User role is able to execute only those reports specifically granted access to him/her, and may not create new reports or modify existing reports. Administrators may restrict users' access to only that data belonging to specific customers.

username

the username is the siteminder username (or a partial string)

Revision Log

Date	Author	Title	Version	Change Reference
04/08/14	Elaine Fonaro	Technical Writer	v 1.0	This is the first revision of MESWeb - Access Control Work Instruction
04/08/14	Ashley Martin	Technical Writer	v 1.0	General Review
07/21/14	Elaine Fonaro	Technical Writer	v 1.0	Add the Report Module and general review
10/29/14	Claudia Urenda Elaine Fonaro	Business Analyst Technical Writer	v1.0	Final Review
04/28/16	Elaine Fonaro	Technical Writer	v 1.0	Converted to 42Q
08/05/16	Elaine Fonaro	Technical Writer	v 1.0	Converted to Google Doc
03/22/18	Elaine Fonaro	Technical Writer	v 1.0	Applyed new Template for format.
05/25/18	Elaine Fonaro	Technical Writer	v 1.0	Reviewed and Update all images according new user interface Added the User Groupnew topic

SOP-MES0039 MESWeb Central

Contents

Introduction

Locations

Filter Locations

Add Location

Edit Location

Delete Location

Server

Add ServerName

Edit Server Name

Delete Server Name

Data Sources

Filter Data Sources

Add Data Sources

Edit Data Sources

Delete Data Sources

Data Source Type

Add Data Source Type

Edit Data Source Type

Delete Data Source Type

Reports

Filter Reports

Add Reports

SQL Code

Parameters

Drill Down

Add Drill Down

Remove Drill Down

Testing

Summary

Edit Reports

Copy Report

History Reports

Predefined

Predefined Maintenance

Edit Predefined Reports (Maintanance)

Report Groups

Add Report Groups

Edit Report Groups

Delete Report Groups

Access Control

Navigation menu

Search