Implementation Q&A Archive
Questions and Answers from real consultants

Knowledge Base Articles

Question: Is there a way to force zeros into the cube from an api.data.calculate where one of the source intersections may have no data?

Question (con't) For example, if we have "Bonus = Sales * Bonus %", not all intersections in the sales account will have values but the client wants the result of the calculate function to load a zero to the corresponding bonus intersections. Answer ...

OSAdmin_0-1627910864971.png QandA.png
OSAdmin by Valued Contributor
  • 600 Views
  • 0 comments
  • 1 kudos

Question: How do you run a consolidation, or a force calculate, in a business rule? I’m copying data into another scenario and then want to calculate the member formulas in the account dimension.

Answer Rather than triggering a calculation/consolidation from the business rule, consider adding it as a second step in a data management sequence instead (for example after the ‘data copy’ custom calculation step). Otherwise, one can create a calcu...

OSAdmin_0-1627910507914.png QandA.png
OSAdmin by Valued Contributor
  • 1487 Views
  • 0 comments
  • 1 kudos

Question: When exporting data to excel from a cube view, is it possible to export the scaled values as the true value? The data is being extracted for loading into another system (Workiva) which the client wants to load scaled amounts.

Answer OneStream is storing the true value and using a number format to display the values as scaled. If the client only takes scaled amounts, rounding could cause reports to not foot correctly in Workiva. Possible options: Dynamic calculation on the...

OSAdmin by Valued Contributor
  • 749 Views
  • 0 comments
  • 0 kudos

Question: Does OneStream have the equivalent of FDM logic accounts? The client wants to load the same source file data row to two different accounts in the cube.

Answer Yes, this can be achieved using derivative rules. Derivative rules apply logic to the stage data. There are two types of derivative rules, Source and Target. Source Derivative rules are created to apply logic defined by the inbound source data...

OSAdmin by Valued Contributor
  • 405 Views
  • 0 comments
  • 1 kudos
Labels
Top Contributors