Office Hours
Questions and Answers from real consultants

Knowledge Base Articles

Question: When you have a data management job attached to the process button of a workflow, is there a way to have OS finish the data management job before returning control to the end user?

Answer The Data management jobs are kicked off by a DataQualityEventHandler. In the DataQualityEventHandler, there is a line that actually runs the DM job. ExecuteDataMgmtSequence - Runs the DM job and will not return control until it finishes. Sourc...

OSAdmin_0-1628882108915.png OSAdmin_1-1628882115313.png QandA.png
OSAdmin by Valued Contributor
  • 370 Views
  • 0 comments
  • 0 kudos

Is there a batch functionality for journals?

Answer There is currently no batch functionality for journals. A workaround is to run a BR that loops through all the journals for a specific time period and post each one. Source: Office Hours 2020-04-09 Partner Enablement

QandA.png
OSAdmin by Valued Contributor
  • 230 Views
  • 0 comments
  • 0 kudos

Question: Is there an option to clear non-calculated data in a “bulk” (as known from hs.clear) other than looping through the data buffer and use “SetDataCell” (which has a higher performance impact)? The “ClearCalculatedData“ is not impacting input/imported data – right?

Answer Non-calculated data can be cleared outside of rules From Workflow: From Data Management Jobs: However, there is no equivalent of hs.clear to clear non-calculated data within OneStream (by design…because it “breaks” the audit trail inherent in ...

OSAdmin_0-1629129779258.png OSAdmin_1-1629129810197.png OSAdmin_2-1629129863153.png QandA.png
OSAdmin by Valued Contributor
  • 534 Views
  • 0 comments
  • 0 kudos

Question: If there is data in BI Blend tables, how do I track if there are changes in the BI Blend data from period to period in my workflows?

Answer Use the workflow type of “BI Blend, Workspace”. This way you can import/transform the data and then immediately afterwards use a dashboard to query review the data on each cycle. If the workflow tracking frequency is monthly then the a new BI ...

OSAdmin_0-1629226204779.png QandA.png
OSAdmin by Valued Contributor
  • 201 Views
  • 0 comments
  • 0 kudos

Question: When a client is moving from an import process consisting of loading .csv files over to a direct connector, is there anything that should be taken into consideration when changing the data source on the existing workflow that was previously used to load the data manually?

Answer •Be aware that if you go back and reprocess prior months that leveraged the previous load process then it will clear out the data from those intersections. •These prior periods should be locked so data is not lost. •Audit integrity should be m...

QandA.png
OSAdmin by Valued Contributor
  • 226 Views
  • 0 comments
  • 0 kudos
Top Contributors