Click here to access the legacy version of this documentation.
The m-Power Data Explorer allows users to design their own queries based on data sets created for them by m-Power developers. This separation ensures that end-users have access to a wealth of key features, such as:
- Overall layout (such as data listing, Pivot Table, graphing, etc…)
- Column choice and ordering
- Run-time filtering
- Dashboard customization
- And much more
At the same time, end-users do not have to be bothered with how to join tables or worry about other database concerns. Instead, they will have access to a data set that an m-Power developer creates for them. Developers can apply global filtering, row level security, or useful calculations that will automatically be included with the data set. Developers can be confident that end-users won't accidentally create a bad query, because the developer has the ultimate control of the underlying data set presented to the user.
Table of Contents
- Video Walkthrough
- Initial Configuration
- Creating Data Models for Data Explorer
- Promote to Production
- Important Notes
Watch this 5 minute video that illustrates how to create an m-Power Data Model.
This document will walk you as a developer through the entire process of configuring Data Explorer, and ultimately creating and deploying data models for end-user consumption in a runtime environment. Please see this document to learn more about how to utilize the Data Explorer at run-time and creating designs from models.
Data Explorer is built right into the m-Power platform and is accessible to all developers who have login credentials to the m-Power Development Interface. This means from the m-Power development interface, a developer may explore Data Models they've created and save designs directly from these models. However end-user accessibility to Data Explorer to explore these Data Models and view/create saved designs in a runtime environment will require an additional license. Please contact firstname.lastname@example.org for more information on licensing m-Power Data Explorer. If this is your first experience working with the Data Explorer, a timed trial license may be available.
Creating Data Models for Data Explorer
- Create a New Model – To create a new Data Model, click the "Models" button in the header. Then click "Create New Model." Create your model as you would create any application. Some important notes about creating Data Models:
- Assign model to user roles – Now that your data set has been created, it can be assigned to user roles (Models that are unassigned are visible to all, assuming they have not been marked Private). To do this, click the "Assigned Roles" option at the bottom of the left panel. To assign, click the Role you wish to assign to this model. When completed, click "Close"
- Provide end-user access – To allow your end users to explore this Data Model, click the "Launch Runtime Data Explorer and Dashboarding" button on the Data Explorer menu:
- Customizing the Dataset – While you cannot use m-Painter for your m-Power Data Model, you can utilize Field settings to control aggregate behavior, dropdown/calendar options, etc.
This will open the Data Explorer menu in a runtime environment.Click 'Explore' on the model you have developed for users:
Note: In this separate runtime Data Explorer menu, an end-user is contained to Data Explorer and cannot access any features of the developer interface. This includes editing m-Power applications, Data Models, and accessing Admin features. Giving end-users access to this runtime Data Explorer environment, specifically to explore and create designs from Data Models, will require a license file from mrc as noted at the beginning of this documentation. Please contact email@example.com for more information.
Once the Explorer window opens, you may copy and paste the URL from your browser to share directly with users. Otherwise if using m-Power's built in menuing system, you may alternatively add this as an option on the menu for easier user access.
Promote to Production
When promoting Data Models, the following table lists out the necessary files required to be promoted:
Note: Replace any references of 'DD' with your corresponding Data Dictionary name. Replace any references of 'DXXXXX' with your Data Model number. If your Data Model is #10, the corresponding files will be D00010s.json and D00010p.xml.
|saved-data-models-vue.json||/m-power/mrcjava/WEB-INF/classes/DD||List of all Data Models within the data dictionary|
|DXXXXXs.json||/m-power/mrcjava/WEB-INF/classes/DD||Data Model specifications|
|DXXXXXp.xml||/m-power/mrcjava/WEB-INF/classes/DD||Data Model properties|