I think you need to start drilling down on the unexpected amounts to
figure out from where the questionable amounts originate. If you can
chase the amounts all the way to base level, you can determine if the
cell came from Stage, Journal, Form, Calcu...
You could put the Detailed Description of usage in one of the Text
properties. the Text properties can vary by ScenarioType/Time, which
could allow the instructions to similarly vary if ever needed.
If you are relatively new to OneStream, you should start with
Application Import/Export of Metadata to extract and import Metadata.
Import/Export generates XML format flat files which you can edit in
Notepad, or whatever tool you would like. If you n...
You will need to loop through the desired list of members that was
derived with an appropriate where Text Contains abc clause. Within the
loop, get the data cell you want for the entity, and accumulate that to
a running total.