To view the results of a run, click on Analyze at the top of the page. This leads to a page with a list of runs. Click on the run you want to look at.
This will bring you to the Results page for your run. In the upper right, there are three buttons. Duplicate will create an identical projection and immediately run it. Re-Run will run this projection again, replacing the results. Delete will delete this projection and its results. Note that these three buttons impact the projection itself, not the projection template.
Below these three buttons are 4 more buttons: Dashboards, Explore Data, Inputs Used, and Run Logs. Dashboards will bring you back to this initial page, where you can view created dashboards and create new ones. Explore Data lets you create tables to analyze the results of the run; this will look similar to the Projection Template. Inputs Used will take you to a page that lists the model point files and tables used in this projection. Run Logs show the raw logs created by SLOPE. Click on Explore Data.
There's a list of areas you can explore, based on the level of data. Note that "Model Point Results" will give results on the calculations from a single line of any model point file. "Model Points" will give information about the data in the model point files. "Product Results" will give data aggregated to the Product level (e.g. the total Cash Flows for all Term Life policies). For more information, see the Explore Results article. Click on "Model Point Results."
On the left side, you will see a listing of the Filter-Only Fields, Dimensions, and Measures. We will use these to create a table. Let's say we want to see the Ending Balance of certain variables at each time. First, click on Ending Balance and Time. This sets Time as the Y-axis variable and sets our measure as Ending Balance. Now, put your cursor on Variable Name. Notice that three buttons appear: Pivot, Filter, and a gear icon for custom filters. Click on the Pivot button. This will set Variable Name as our X-axis. Finally, click the Run button in the upper right. After a few moments, our table will be generated.
Now let's look at the filters. Projection ID is already filtered to the current run number. Note that this run number is also in the URL of the current page. Put your cursor over Product Name and click on Filter. Type "Term Life" and hit enter. Now, click on the Filter button next to Variable Name. Type "Reserve", hit enter, and change the dropdown to "contains". Next, click on the column header for "Model Point Results Time" in the upper left of the Data chart until it has an up arrow; this will make sure the outputs are listed in ascending order of time. Finally, click "Run" again.
We now have a table with the ending balances of each of the reserves by time for the Term Life product. Note that this model only has 1 model point per Product and 1 scenario; for more complicated models, you should also consider filtering on Model Point Record # and Scenario #.
You can also export the results of this custom query to save outside of SLOPE. Now click on the gear icon next to Run. Click on "Download..." This will create a window with options on how to download this table as a file. For File Format, select "Excel Spreadsheet (Excel 2007 or later)". Click Download to save the file.
Click on the Dashboards button in the upper right. This brings us to the page we started with. On the left side, there's a list of System Dashboards. Click on the Model Point Details dashboard. Under Product Name, select "Term Life." Click the Apply button.
This will give you a dashboard with 4 sections, each detailing the 1st model point row of the Term Life product. There are a lot more useful System Dashboards. For now, let's create our own. Click on "Add New" at the top of the Dashboards section. Enter "My First Dashboard" for the Name and click the Create button.
Click "New Tile" in the upper left of your dashboard.
You will now see a list of areas to explore, just like the Explore Data section of this article. Click on Model Point Results. This screen should seem very similar to the Explore Data screen, so let's make a new table. Put your cursor over Projection ID and click on Filter; type your run number (remember, this number can be found in the URL). Put the cursor over Product Name and click the Pivot button and the Filter Button. Enter "Life" and change the dropdown to "contains". Click on Time. Put your cursor over Variable Name and click the Filter button. Type "Cash Flows". Click Ending Balance. Click Run in the upper right. Finally, click on "Model Point Results Time" in the upper left of the Data chart until it has an up arrow; this will make sure the outputs are listed in ascending order of time.
We now have a table with cash flows by time and product for Term Life and Whole Life. In the picture above, the Visualization section is collapsed to make it easier to read. If your Visualization section is collapsed, click on it now to expand it. Then click on the Line Chart type icon (the 5th). Let's rename our tile by clicking "Untitled" in the upper left and replacing it with "Liability Cash Flows". Finally, click the Save button in the upper right.
Your dashboard now contains one tile that shows a line graph of the cash flows for your liabilities. You can 1) make more tiles by clicking on New Tile, 2) move your tiles by dragging the upper left corner, 3) edit them by clicking the edit button at the top, 4) duplicate, download, or delete them by clicking the upper right, or 5) resize them by clicking on the lower right. When you finish, click "Done Editing" in the upper right corner.
Now that you've learned the Explore Data function, Run Logs, and dashboards, you can use these not only to analyze your data but to figure out the cause of errors. We'll go into more detail about that in the next article - Troubleshooting.