Application Analysis Reports Group

Use the Application Analysis group reports to understand how effectively the data entities in OneStream, such as dimensions and cubes, are implemented to meet your organization’s needs.

Application Analysis Group Report Filters

Year

The year for data in the report. Click the Year drop-down to select the year, then click Run Report. This filter is available on all reports in this group except Dimension Member Statistics, Formula Statistics, and Formula List.

Application Analysis Group Reports

Dimension Member Statistics

This auto-generated report provides an overview of the number of dimension members defined in OneStream. It displays the current dimensions and number of members for each dimension.

Formula Statistics

This report shows member formula statistics such as pass#, stored counts, dynamic counts, ratio of stored and dynamic accounts, sign flip, and CPU usage for dimension names. Formula statistics are shown in the report by dimension type.

Formula List

This report shows the contents of member formulas. Formula contents are displayed by name and type for each dimension. This report shows you the contents of each defined formula to assess if improvements or changes to a formula are needed.

Formulas provide intuitive organization and promote the reusability of dimensions with their associated calculations across multiple cubes. They also enable parallel processing for performance optimization using advanced multi-threading that runs multiple formulas at the same time.

Data Statistics

Reports cube data statistics for cube records, imported records, and explosion factor. Explosion factor is the number of cube rows divided by the number of imported staging rows, and is calculated automatically.

Data Unit Statistics

Reports the number of data records by entity name for each cube. To see more Data Unit details in OneStream, right-click on a data cell in a cube view.

See Data Unit.

Cube Data Partition Statistics

Reports cube data records by entity, sorted by partition number.

Stage Data Partition Statistics

Reports data records for each stage profile, sorted by partition number.

Task Activity Sample

Reports statistics for the top 200 longest running application tasks by stage load, process cube, consolidate, and the name of the application server that ran the task.

Data Statistics (Binary)

Reports cube data statistics for cube records, imported records, and explosion factor. This report is only for applications using binary storage.

Explosion factor is the number of cube rows divided by the number of imported staging rows, and is calculated automatically.

Data Unit Statistics (Binary)

Reports data unit statistics grouped by entity name, then by cube name. This report is only for applications using binary storage.