cancel
Showing results for 
Search instead for 
Did you mean: 
Office Hours
Questions and Answers from real consultants

Knowledge Base Articles

Question: What happens when a metadata change is committed? We are creating members on the fly and receiving errors when the members are being added during the transformation event.

Answer Would suspect this is going to be environment specific and will need some analysis of the logs. Advised to reach out to support for assistance in understanding and resolving the error. Source: Office Hours 2020-7-2 - Partner Enablement

QandA.png
OSAdmin by Community Manager
  • 44 Views
  • 0 comments
  • 0 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 Community Manager
  • 161 Views
  • 0 comments
  • 0 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 Community Manager
  • 87 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 Community Manager
  • 71 Views
  • 0 comments
  • 0 kudos
Top Contributors