Fields inside Data unit statistics?

OS_Pizza
Contributor III

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

OS_Pizza_0-1676442808730.pngOS_Pizza_1-1676442825327.png

 

2 REPLIES 2

NicolasArgente
Valued Contributor

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 !

 

Connect with me on:
LinkedIn: https://www.linkedin.com/in/nicolas-argente/
Website: https://aiqos.io
If you want to lift yourself up, lift up someone else.

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)

Please sign in! OS_Pizza