Skip to main content
O
OS_Pizza
February 15, 2023

Fields inside Data unit statistics?

  • February 15, 2023
  • 1 reply
  • 1 view

1. Why is the "Total number of stored records" same across all months for one year ?


OS_Pizza_0-1676442808730.png

OS_Pizza_1-1676442825327.png

 

1 reply

N
NicolasArgente
February 15, 2023

Hi!
OneStreams stores data for each year in a different table. So you have the table for 2022 and another one for 2023. The number of row in the table is the number of stored records you see under GENERAL. 
After that the data unit filters "kind of" on those Store Records. 
If you are interested wit the statistics, please have a look at the Application Analysis Report. In this Report, there are key metrics that support Data Unit records, Data Unit sizes, and the optimization of formulas. 

Analysis.png

Look below I did a filter on the database and I have the same values than in my Stored Records.

 

Press the Kudo if you like the answer !

 

O
OS_PizzaAuthor
February 16, 2023

That means the total no of record is the row count of 2022 data table (filtering on my S#,E#,C#,Cube) and not the total no of records for a particular month.

1) What is number of NODATA,Zero,Real,Derived cells ? And why are they all under NODATA Status ?

2)

Terms & ConditionsAccessibility statement