Overview
In this session, we’ll begin building the forms we need. We’ll start with the P&L report. First, we'll define the structure of the report. Then we’ll layer in some details and fine-tune a few of the settings. And lastly, we’ll make some cosmetic changes and style the report appropriately.
Transcript
[transcript]
In this session, we'll begin building the forms we need. We'll start with the P & L report. First, we need to define the structure of the report. Then we'll layer in some details and fine tune a few of the settings. And lastly, we'll make some cosmetic changes and style the report appropriately.
The P & L report is in the reporting model. We can go to the forms node and add it here.
Click edit and open the layout tab. This is where we define the form structure. Note that we don't need to build all the calculations at this point. We only need to set up the general layout. We can see all the model dimensions listed here.
Under each dimension node, there are three types of icons: member lists, leveled hierarchies, and attribute hierarchies.
On the columns, we see the three axes: row, column, and filter. We just need to assign the dimensions to the axis they belong to.
Let's refer back to our architecture document. The P & L report has account on the rows, months on the columns, and the rest of the dimensions on the filters.
So in Kepion, let's check row for account, column for months, and then filter for the other dimensions. Make sure to select the product and entity hierarchies rather than the flat member lists. Let's also include the fiscal year attribute from the time dimension.
Next, let's configure which dimension members we want to display on each axis. We can start with row.
On the left hand side, we have the account member list. We can either click on the members individually to add them to our form, or we can use the actions here to bring in whole sections of the hierarchy together.
Clicking single will bring only the selected member. Descendants will bring in all the members below the selected member. Children will bring in just the members on the next level of the hierarchy, and leaves will bring in all the members on the lowest level of the hierarchy.
As we need all of the members under the P &L header, we can select P & L and click descendants.
Moving on to the column tab, we want the ability to view any month. So let's begin by selecting the all node and choosing leaves.
If we return to the main tab, we can see our form start to take shape. However, listing out every month on the columns makes the report much too long. Let's set up the filters to scope it down.
In the filter tab, we have a few options available to us. Under header display, we can change the display name of the filter. As the name suggests, default member allows us to choose which member is selected by default. The scope option allows us to limit how many dimension members are available as options in the filter. Selecting read only prevents users from changing the filter selection, and multi select allows them to choose more than one member.
Let's select default options for each of our filters.
Let's take a look at the form we have now. Since we selected FY25 in our fiscal year filter, only months from that fiscal year are visible on the form. Now the general structure matches our architecture document, but we still need to fine tune some details.
First, we want to be able to see the total values for the year. So let's return to the column tab and select the all node itself by double clicking all in the member list. In our report, this column will now show the total values for the year for each account.
Now let's work on the rows. First, we want to show the indents in the hierarchy. To do this, we need to go to the property tab.
Here, we can override the default display settings. To show the hierarchy structure, we need to override the row definition. We'll choose to show the member name with the indent hierarchy option checked.
Now we can see the account hierarchy. In the architecture document, we have the parent members listed under the child members. We can quickly change this by going to the layout tab and checking reverse for account. Now our bottom line is at the bottom of the report.
We'll finish the report by adding some general formatting. As a best practice, try to set formatting by sheet, row, or column if possible, as this will decrease the form size compared to formatting individual cells.
In the advanced settings tab, we can change the default cell colors, show or remove grid lines, and enable our hierarchy to be collapsible.
Now our P & L form is complete.
In this session, we looked at the basics of form design. Most forms you build will follow a similar process. First, we defined the overall layout and structure of the report. Then we layered in some details and configured a few settings. And lastly, we styled and formatted the report appropriately.
In the next session, we'll create our three input forms and explore some additional options available to us when designing forms.
[/transcript]