Ranking Report with Graph

 

The Ranking Report with Graph template is an invaluable tool with regards to Business Intelligence Reporting.

Within the prompt page of the application built with this template, your users will be able to:

· Select the number of records they wish returned

· Select the order in which they are returned

· Control the dimension of the report

· Control the field by which the report will be sorted

Within the output page, your users will:

· Be shown a numeric list counting the number of records displayed

· A dynamic column that will show the dimension field’s values

· Have a pie graph that shows each dimensions percentage of total graphically

· Have the ability to re-order any column, thus redrawing the data graph

A key feature of this report is that it does not require any painting, as the features listed above are completed at compile time.

Prompt Page Features

· The Top/Bottom option allows your user to select either “Top” or “Bottom” of their data set.

· The Count option is hard coded with nine popular values. This value controls the number of records returned within the report.

· The Dimension dropdown controls how your data will be grouped. You must select a field as a Sequence Key to make it eligible as a Dimension field.

· The Based on Measure option controls which field your application will be sorted upon. Additionally, the field will also be graphed.

Note: The fields contained within the option are all numeric fields that are not sequence keys.

Output Page Features

· The Select Criteria box will only show the criteria the user has chosen. If they do not enter any criteria, then no criteria options will show (For example, the above example has 4 criteria to choose from, I have only selected one of them. Because of this, only 1 criterion is shown within the output). This feature was designed to save space.

· The Rank feature is automatically populated for your user, allowing them to quickly count the number of records selected.

· The Dimension column will automatically populate with the appropriate data chosen from the Dimension field option on the Prompt Page. Additionally, the correct column heading will also be populated (For instance, in the example above, the second column has been filled with Product Number information. However, if I would have chosen Customer Name on the prompt page, the second column would have been filled with each Customer Name).

· The Graph will automatically show the percentage of total for the given dimension. The graph, by default, will render as a 3D Pie Graph.

Note: The graph title will only show the number of records returned, regardless of the numbers you have asked to return (This often applicable when you have asked to see more records than are available).

· The Sorting options allows you to sort any column. Doing so will re-draw the graph.

General Suggestions

To minimize any unnecessary modification of the html, mrc recommends the following:

· Use “Field Settings” to set the fields that you do not wish to see to “Not Display” (Almost always, the only fields you will want printed are numeric fields).

· Within the prompt page, if there are extra fields you do not wish to include within the Based on Measure dropdown list, consider removing them within m-Painter.

· Only fields that are used as sequence keys are available to use as Dimension fields.

· The output shown is based off of subtotal information. If you see empty columns or summed numeric data that you are not interested in, considering setting the field to “Not Display” in “Field Settings”.