Skip to main content
O
OS_Pizza
Veteran
February 17, 2023
Solved

Dataunit statistics

  • February 17, 2023
  • 1 reply
  • 0 views

Can you please guide me the definition for the below points - 1) What is number of NODATA,Zero,Real,Derived cells ? And why are they all under NODATA Status ?

OS_Pizza_0-1676627976899.png

 

    Best answer by JackLacava
    • Real cells are intersections for which actual numbers have been stored or created.
    • Zero cells are real cells with a value of 0.
    • NoData cells are intersections that don't have data for one or more periods in the year but have (or have had) real data in later periods.
    • Derived cells are intersections that don't have data for one or more periods in the year but have (or have had) real data in previous periods.

    For performance reasons, you want to keep the number of NoData and Zero cells to a minimum, since they generate actual database records that have to be loaded and examined when calculating and consolidating.

    They are grouped under "nodata status" for convenience, since they are related from a logic perspective.

    1 reply

    J
    OneStream Employee
    JackLacavaOneStream EmployeeAnswer
    OneStream Employee
    February 17, 2023
    • Real cells are intersections for which actual numbers have been stored or created.
    • Zero cells are real cells with a value of 0.
    • NoData cells are intersections that don't have data for one or more periods in the year but have (or have had) real data in later periods.
    • Derived cells are intersections that don't have data for one or more periods in the year but have (or have had) real data in previous periods.

    For performance reasons, you want to keep the number of NoData and Zero cells to a minimum, since they generate actual database records that have to be loaded and examined when calculating and consolidating.

    They are grouped under "nodata status" for convenience, since they are related from a logic perspective.

      O
      OS_PizzaAuthor
      Veteran
      February 22, 2023

      Thank you for your answer. I have now implemented removezeros and nodata function in the calculations but still have a large zero and no data in the system which is ( calculated, durable and input). How do I remove Nodata and zero cell from the system.?

      J
      OneStream Employee
      JackLacavaOneStream Employee
      OneStream Employee
      February 27, 2023

      You want to investigate api.Data.ClearCalculatedData. It has options to clear calculated data and durable data too.

      As for input data, that's stuff that was either imported or copied from other scenarios. You can clear it from the Import step (if loaded) or with api.Data.SetDataCell - look for the "Clear Data" snippet.

      One thing to mention is that you'll likely never be completely free of NoData and zero cells, simply because of how the system works. The objective should just be to keep them to a minimum, ensuring your rules don't create more when they run.

        Terms & ConditionsAccessibility statement