Overview
In this session, we’ll turn the dashboard we designed into a dashboard app. We’ll begin by looking at what dashboard app is and how they’re configured within Kepion. Then we’ll learn how to navigate an app and enter data. And lastly, we’ll examine the details behind creating and saving submissions.
Transcript
[transcript]
In this session, we'll turn the dashboard we designed into a dashboard app so that end users can interact with it and input data. We'll begin by looking at what a dashboard app is and how they're configured within Kepion. Then we'll learn how to navigate an app and enter data. And lastly, we'll examine the details behind creating and saving submissions.
Let's begin by explaining the difference between a dashboard and a dashboard app.
In Kepion, a dashboard is the component we created that consolidates our forms, filters, and rules into a format that end users can interact with. Before anyone can use the dashboard, however, we need to configure some basic settings such as which users have access, which models they're allowed to write to, and what kind of approval process the submissions undergo.
The combination of a dashboard and all its related security and workflow settings make up a dashboard app. This distinction allows us to design multiple workflow processes around a single dashboard.
Let's begin in the administrator module. We'll look at managing users, security, and workflow in a later session, so for right now we'll cover just the basics to get our dashboard app up and running.
In the permission section, we can configure which dimensions and models users can read from and write to. At the top, we can select which user we want to configure.
Let's select our own credentials and then click model permissions.
We'll check both boxes to give us read and write access to every model.
Now let's move to the dashboard app section and add a new app. We'll name it revenue planning, and then select the dashboard we configured. Let's click add.
Select the new dashboard app from the navigation pane and click edit.
In the configuration tab, we can change the initial settings. The rest of the options here we'll revisit when we design our workflow. All we need to do to access our dashboard app is to add ourselves as a contributor.
A contributor is a basic workflow role that can create new submissions and modify data. In the user tab, we can click the contributor button and then select ourselves.
Let's save the application.
If we navigate to the apps module, we can now see our dashboard app. We can start a new submission by clicking on the plus icon.
Now we can interact with the dashboard. The P and L report isn't inputable, so let's jump to the trade spend page. Here we can enter data into the form. We can also click and drag to quickly fill the form.
Notice the blue indicator in the corner of the cells. This tells us that the data only exists locally and hasn't been posted to the database yet.
To submit these values, we need to trigger the update action. You'll notice the update bar appears in the center of the application. This indicates that changes are pending and ready to be posted.
We could do that directly by hovering over the action menu and selecting update. However, we also tied the same action to the update button, so selecting either of these options would give us the same result.
If we return to the P and L report, note how the post invoice accounts are still empty. That's because all the data we enter into the trade spend form goes into the trade spend model. We'll create a rule later on that moves this data into the reporting model.
In the base assumption tab, we can use our account filter to switch between the volume, cost, and price of our product. Let's enter values for all three of these metrics.
Then we can do the same for the deflator percent form.
Now let's save and exit the plan.
In the apps page, we can resume our submission here or delete it. It's important to understand that even if we deleted the submission, it wouldn't delete the numbers we entered.
In Kepion, all users are reading and writing from the same database. When we create a submission and post our data, the values get sent to that database. Deleting the submission or creating a new one doesn't affect those values.
In this session, we walked through the steps to configure a user with the necessary permissions to access a dashboard app. Then we saw how to navigate an app and enter data. And lastly, we examined some of the details around creating and saving submissions.
In the next session, we'll look at ways we can manage the data in our application using measure groups and partitions.
[/transcript]