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.
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:
This will open the Data Explorer menu in a runtime environment.Click ‘Explore’ on the model you have developed for users:
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.
- 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.
Promote to Production
When promoting Data Models, the following table lists out the necessary files required to be promoted:
|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|