Hi, please read this blog entry and the comments for more information on
this. SELECT Like a Boss With Query Parameters - OneStream Community
(onestreamsoftware.com) Using Query Parameters is highly recommended!
Hi Marco, there are various selections (as you know, of course) to
determine the workflow steps. For your case, maybe choosing Import,
Validate, Workspace is helpful for you to customize whatever actions you
deem a 'clean process'. Meaning, on Worksp...
Hi, there are different options, some of which are: (1) retrieve the
historical data from your regional ERPs and load the data on the "new"
level also for historical data (difficult for statutory consolidation,
more feasible for management reporting ...
Hi Jake, V#Annotations is as you correctly point out for strings.
V#periodic or V#YTD etc. are for data. Those two are inherently
different and are treated with a logic that takes that into account in
OneStream. I.e. I am not aware of a setting that ...
The other (i.e. safer) way is the one Jana mentioned. Pull the rows from
the DataAttachment table, loop through them and use
api.Data.SetDataAttachmentText() to set the ones someone wishes to
delete to nothing. Then you are only using SQL to query th...