Office Hours
Questions and Answers from real consultants

Knowledge Base Articles

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
  • 380 Views
  • 0 comments
  • 1 kudos

Question: What’s the method to override the aggregation of a parent UD member when it is desired to have the UD parent be a calculation and not an aggregation.

Answer It is not possible to override the aggregation and store a different value in a parent because UD parents are not stored members. The only way to accomplish this is make the parent member a dynamic calculated member and define the calculation ...

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

Question: For the UD dimensions, the “None” member is not utilized and instead an equivalent member (e.g., UD1#No_CC, UD2#NOFUNC) has been created. What are the design considerations of this?

Answer This is quite common and sometimes a necessary design, especially if using “stacked” dimensions where the None member can’t be used in multiple places without “doubling” the values. In addition, properties on the UD None members cannot be chan...

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

Question: An issue has been encountered where an entire Dashboard Maintenance unit is extracted to be imported into another application/environment.

Question (cont) On occasion, the import fails because of the order of components within the XML, even if the components are all in the same maintenance unit. Is there any way to address this other than manually reordering items within the XML file? A...

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

Question: Is it possible to add metadata via DRM?

Answer •We do not support the use of DRM for metadata updates in OneStream, as it does not know the concept of “Extensible Dimensions” •However, there are ways of adding metadata “on the fly” using Transformation Event Handler business rules. •Update...

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

Question: How do I resolve this error message, “Error creating parent-child relationship. Members in a hierarchy path cannot transition between the current dimension and inherited dimensions more than once”?

Question (cont) We have an Account Dimension for Actuals that we are extending for Plan. In the extended Plan dimension, we need to use members that are inherited from the ACTUALS dimension. We need to use some of the Actuals accounts within the Plan...

QandA.png

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 Valued Contributor
  • 167 Views
  • 0 comments
  • 0 kudos
Top Contributors