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
  • 309 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
  • 212 Views
  • 0 comments
  • 0 kudos

Can you give an example of the best way to sum a row from a cube view? For example, if I add two rows to a cube view, one with a selection of members, how do I make the second row a custom sum of the first? I know one way to do it, but I don’t love it, I would love to see what else you guys recommend.

Clarification – this is referring to using Cube View Row/Column math when members expansions are in use. Answer No “elegant” ways to address this currently – options are: Avoid using member filters (i.e., break the source rows down to more detail) Re...

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

Question: When working with business rules, as the buttons of “Save” and “Undo” are placed next to each other, it sometimes happens that you hit “Undo” instead of “Save”. Is there an option (e.g. Shortcut) to “Redo” the action and get back the script deleted by “Undo”?

Answer No, not at this time. Enhancement Status: We have had requests for a “Redo” function to be added to CVs and in Excel, but do not see any such request for the BR editor. Source: Office Hours 2020-03-26 Partner Enablement

QandA.png
OSAdmin by Valued Contributor
  • 130 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
  • 463 Views
  • 0 comments
  • 0 kudos

How can you adjust the column width on cube views?

Answer For the Row Header width: This can be found under General Settings > Header Size, and can be either set to a specific width, or –1 for default sizing. Needs to be set independently for Data Explorer, Excel & Report modes.For the Column width: ...

OSAdmin_0-1629130139004.png QandA.png
OSAdmin by Valued Contributor
  • 428 Views
  • 0 comments
  • 0 kudos

Question: Can you please provide guidance as to the best way to handle entities with different calendar and fiscal years? Main company is Aug fiscal year close. A few legal entities are March close. One is December close.

Answer Answer: Configuration touchpoints:EntityTime ProfilesScenariosFX RatesCubesData Integration – moving data between cubes Case Study A Two completely separate organizations: Retail/Commercial organization – “Business” FEBRUARY year-end Charitabl...

OSAdmin_0-1629140136897.png OSAdmin_1-1629140185205.png OSAdmin_2-1629140220207.png OSAdmin_3-1629140232656.png
OSAdmin by Valued Contributor
  • 351 Views
  • 0 comments
  • 1 kudos

Question: Is it possible to run an automated consolidation task every hour using only the task manager to set everything up (i.e., without business rules/windows scheduler/PowerShell)? And, if it is possible, what are the steps to get there?

Answer No…Task Manager can be used to launch tasks, but is not there for automation of tasks. Automation, as posed in the question, would still need to be done using PowerShell, or other job automation mechanisms. Underlying purpose of Task Manager i...

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