Implementation Q&A Archive
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
  • 566 Views
  • 0 comments
  • 1 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
  • 1791 Views
  • 0 comments
  • 0 kudos

Question: When using QuickViews in the Excel add-in, is it possible to do asynchronous reporting (as possible in the competitor tools)?

Example: Row Definition = A#Sales.Children – this produces 3 children rows Nested Row Member = U1#Product.Children – this produces 5 product rows for each of the 3 Account rows Desired is if for the 3rd account row, 3 products are removed from displa...

QandA.png
OSAdmin by Valued Contributor
  • 354 Views
  • 0 comments
  • 1 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
  • 924 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
  • 626 Views
  • 0 comments
  • 1 kudos

Question: If actuals are included in People Planning, how do you limit the periods loaded into the cube when calculating forecasted amounts?

Answer Transformation rules can be set-up to map the time range period in order to load only applicable periods. Use a global variable in allocation methods to allow dynamic period selection for loading. Source: Office Hours 2020-02-13 Partner Enable...

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