Base Report Definitions

The system provides a large collection of base report types that you can run and view. Utilizing the report types will allow you to view different representations of the data in the form of tables and charts. The following section gives a description on each of the different report types.

Note: Your system administrator or site configuration determines the report types you can access. This means that some report types may not appear in your report menu.

Cross Purchase Analysis

For this report, the user must select two sets of entities. One set is called the column entities (the first column entity is a reference entity), as these are rendered as column items in the tabular version of the report, and the other is called the row entities, as these are rendered as the row items in the tabular version of the report. The report essentially calculates the measures for each row entity across the column entities.

Note: This report is limited in the number of columns you can select for comparison. Do NOT try to run this on all the SKUs in a category, the report will error out. It is recommended to keep the columns you select to 15 or less.

Penetration Analyzer

This report evaluates the number of stores, called the Scanning Stores, which sold each Analyzed Item as a percentage of the stores which sold a Reference Item. The Analyzed Item can be a list of multiple items or item groups; the Reference Item is a single item or item group, and is rendered in the first row of the table. The report also calculates the size of prize, or opportunity gap associated with the non-selling stores. Size of Prize is a calculation defined as average dollars per scanning store, multiplied by total additional stores that could sell the item.

Rank Analyzer

This is a generic report that can be run on any entity or entity group within the reference data, e.g. items, stores/customers, regions, etc.

This report ranks a list of selected entities or entity groups for a selected list of measures. When multiple measures are selected, the global ranking is performed against the first measure in the list of selected measures.

The percentage growth period-on-period, and ranking for the previous period, are shown if the report is run for a period-on-period analysis.

Report Group by Measure

Generate a group based on specific measures for a period.

Sales Distribution Matrix

This report renders a matrix with a selection of entities as the rows versus a selection of entities as the columns, and calculates the selected measures for each combination. The period-on-period percentage changes of the measures are shown if period-on-period is selected.

This report can be used to construct a matrix of arbitrary row entities versus column entity measures.

Sales Report

This is a roll-up report which calculates, for each entity within the selected group(s), the selected measures for each of the selected periods. The year-on-year or period-on-period growth/shrinkage is also shown if this option is selected with the periods. The first entity in the list of selected entities can be specified as a reference entity, in which case the measures for each entity are shown as a percentage relative to the reference entity (relative entities MUST be selected in this case, e.g. Dollars %).

Sales Report (Periods by Row)

This is a roll-up report which calculates, for each entity within the selected group(s), the selected measures. The year-on-year or period-on-period growth/shrinkage is also shown if this option is selected with the periods. The first entity in the list of selected entities can be specified as a reference entity, in which case the measures for each entity are shown as a percentage relative to the reference entity (relative entities MUST be selected in this case, e.g. Dollars %).

Share Analyzer

This report calculates the selected entities' share of the selected reference entity on each selected measure. The report ranks the entities according to their share of the reference entity, and also renders the percentage change, share and share rank for the previous period when the period-on-period option is selected.

This report is most meaningful when it is run for a period-on-period analysis, in which case the performance of the ranked entities, in terms of period-on-period growth, relative to the reference entity is highlighted: the report highlights (in red) the ranked entities whose period-on-period growth is less than that of the reference entity, e.g. if a particular product's growth is less than the growth of a category, where the category is the reference entity.

Stores Not Scanning

This reports lists the stores not scanning during the specified time period.

Time Series Analyzer

This report generates a time series chart (with tabular report) of the selected measures for the selected entities. The period group-by parameter determines the time series data points. This is a generic report that can be used to compute a time series analysis for any selected entities on any selected measures. The report also calculates the period-on-period difference, and plots the time series for the previous period if the period-on-period option is selected.

Time Series Analyzer (Cumulative)

Top Selling Items

This report will display and rank the top 10 items within every Category, which has been preselected for you based on the FIRST measure that you select. The report automatically ranks the top 10 items, and you cannot change that quantity.

Top Selling Items by Supplier

This report will display and rank the top 10 products for each supplier within each category. The report automatically ranks the top 10 supplier products, and you cannot change that quantity.

Menu

Articles in this section