02-15-2023 08:03 AM
1. Why is the "Total number of stored records" same across all months for one year ?
02-15-2023 12:28 PM
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.
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 !
02-16-2023 11:09 AM - edited 02-16-2023 11:12 AM
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 ?