Example Dashboard - Cost and Revenues Dashboard

This example explains how to design and create a dashboard which will provide a quick overview of revenue and expenditure position of a selected company, for a selected year and a period. This dashboard consists of a number of charts to display different aspects of revenues and expenditure. Some of these data visualization are for the selected year and period while others provide a trend up to the selected period within the selected year.

The created dashboard can then be published as a quick report in IFS Enterprise Explorer so that the users can view the dashboard via IFS Navigator. The values for parameters Company, Year and Period can be changed and the dashboard can be viewed by users for their specific needs.

Contents

How to Get Started

  1. Go through Getting Started section.
  2. Open Business Reporting & Analysis/My Reports page in IFS Enterprise Explorer and click Report Builder to start the reporting tool.
  3. Create a new, blank report using the New Report or Dataset dialog box.
  4. Create a data source and a dataset as described in Data sources and Datasets section and set up the GL_Balance_Dataset as mentioned there.
  5. Enter Company as a dataset parameter with 900 as the default value if it is not already entered when creating the dataset.
  6. Enter Year and Period as report parameters. Set Data Type of Year parameter to Text and Data Type of Period parameter to Integer. Enter 2006 as default value for Year parameter and 3 as default value for Period parameter.
  7. Resize the dashboard report area:

    From Properties pane change Size property of Body to Width = 10in and Height = 7.5in

  8. Click Header in Insert tab to add page header. Enter header text as Revenue/Expenditure Dashboard with parameter values as shown below.

     

    Figure 1: Dashboard header

  9. Divide the design area by inserting rectangles depending on how the dashboard should be displayed. In this exercise, four rectangles of equal size (Width, = 4.75in and Height = 3.5in) will be placed in the design area.

Creating a Chart to Analyze Revenue, Business Unit wise

  1. Enter chart title Revenue, Business Unit wise (font Verdana and font size 12) in a text box and place it as the header in the top left rectangle.
  2. Enter a column chart using chart wizard with following settings:

    For Value - BALANCE

    For Categories - Code_D (for Business Unit)

  3. Add Abs() function to Sum(BALANCE)expression to remove minus sign from revenue balances.
  4. Resize and place the chart in correct position of the rectangle.
  5. Delete Chart title, Legend and Axis titles.
  6. In Chart Data pane, go to Category Group Properties, change Label to Code_D_Description.
  7. Click on the columns and enter expression for Tool Tip property (copy the expression from Sum(BALANCE) and paste here).
  8. Select the chart and enter filter criteria as shown below. Make sure to enterCInt( ) operator to Accounting_Period expression in order to convert period value to integer to be able to compare with integer Period parameter values.

       

    Figure 2: Filters entered in chart properties dialog

  9. Select the chart and change Palette property to BrightPastel.
  10. Change the background color using BackgroundColor, BackgroundGradientEndColor and BackgroundGradientType properties.
  11. The preview of the chart is as shown below:

     

    Figure 3: Preview of column chart for Revenue Business Unit wise analysis

Creating a Chart to Analyze Expenditure, Cost Center wise

  1. Click Insert Chart and add a bar chart to the bottom left rectangle. Delete the chart title.
  2. Enter Expenditure, Cost Center wise (font Verdana and font size 12) in a text box and place it as the header in the rectangle.
  3. Enter the following settings in the Chart Data pane:

    BALANCE forValues field

    Code_B for Category Groups field

    Account_Group for Series Groups field

  4. Do similar changes as charts above to set Tool Tip, Filters and Palette, and BackgroundColor properties.
  5. Preview a chart will be as shown below:

    Figure 4: Preview of pie chart for Expenditure cost center wise

Creating a Chart to Analyze Year-to-Date Expenditure

  1. Click Insert Chart and add a line chart to the top right rectangle. Delete the chart title.
  2. Enter Year to Period Trend of Expenditure (font Verdana and font size 12) in a text box and place it as the header in the rectangle.
  3. Enter the following settings in the Chart Data pane:

    BALANCE for Values field

    Accounting_Period for Category Groups field

    Account_Group for Series Groups field

  4. Do similar changes as charts above to set Tool Tip, Palette, and BackgroundColor properties.
  5. Add following filters for the chart (see the screen below). Make sure to include Accounting_period <= <Value of Period parameter> and enter CInt() operator in expression to convert Accounting_Period values to integer values in order to be able to compare with Period parameter value.

     

    Figure 5: Filters for line chart and Expression for Accounting_Period field value

  6. Preview a chart similar to the one below:

     

    Figure 6: Preview of line chart for Year to Date trend of expenditure.

Creating a Chart to Compare Expenditure Across Years

  1. Click Insert Chart and add a 3-D clustered column chart to the bottom right rectangle. Delete the chart title.
  2. Enter Period Expenditure Comparison Across Years (font Verdana and font size 12) in a text box and place it as the header in the rectangle.
  3. Enter the following settings in the Chart Data pane:

    BALANCE for Values field

    Accounting_Period for Category Groups field

    Account_Group for Series Groups field

  4. Add filters similar to the earlier chart including the CInt() operator for Accounting_Period but with following changes:

    Accounting_Period = <value of Period parameter>

    Accounting_Year <= <value of Year parameter>

    Note: If you want to put a lower limit to the accounting years that are displayed, do enter an additional filter condition similar to: Accounting_Year >= 2005

  5. Do similar changes as charts above to set Tool Tip, Palette, and BackgroundColor properties.
  6. Preview a chart similar to the one below:

    Figure 7: Preview of 3-D column chart for Period Expenditure across years

Save, Publish and View the Dashboard via IFS Enterprise Explorer

  1. The preview will be as shown below once the dashboard is created:

     

    Figure 8: Preview of the complete dashboard (zoomed out)

  2. Save it in Dashboards folder in report server site.
  3. Then login to IFS Enterprise Explorer as an administrator.
  4. Open Solution Manager/Administration/Quick Reports.
  5. Define the dashboard as a quick report (as shown below). The Presentation Object field will be automatically updated when the dashboard is published. Make sure that the file name you enter is the same as the file name with which the dashboard is saved in the report server.

    Figure 9: Defining dashboard as a quick report

  6. Click Publish in the Quick Report window to allow other users to view the report. (Note that the possibility for other users to view the report also depends on the security settings for the presentation object.)
  7. Open Business Reporting & Analysis/Dashboards to view the dashboard. You will find the above dashboard listed under Dashboards folder (or under DASHBOARD type in Quick Reports window).
  8. Click on the dashboard name to view the dashboard in IFS Enterprise Explorer as shown below:

    Figure 10: Viewing dashboard via IFS Enterprise Explorer (only part of the dashboard viewed in resized IFS EE)