Application Analysis Reports

Dimension Member Statistics

This report provides a quick overview of the number of dimension members defined in OneStream. It shows the member counts for each dimension name, organized by dimension type for the specified year.

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 dimension name and dimension type for each dimension name. This report shows you the contents of each defined formula to assess if improvements or changes to a formula are needed.

Formulas provide intuitive formula organization and promote the reusability of dimensions with their associated calculation across multiple cubes. They also enable parallel processing for performance optimizations 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 automatically calculated. It is the number of cube rows divided by the number of imported staging rows.

Data Unit Statistics

Reports the number of data records by entity name for each cube name. You can see more Data Unit details in OneStream, right-click on a cell in a cube view under (OnePlace > Cube Views) then click Data Unit Statistics.

See: Data Unit section in Workflow in the Design and Reference Guide for more information on data units.

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 automatically calculated. It is the number of cube rows divided by the number of imported staging rows.

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.