Office Hours

When writing custom consolidation rules in HFM, hs.con is frequently used. Is there a similar function in OneStream?

Answer If there is a consolidate elimination, there is an elimination finance type that can be utilized. You can utilize a set data cell, set data buffer, or api.data.calculate inside the finance rule. The api.data.calculate is similar to hs.con. Sou...

How do you clear elimination records for parent members that have been cleared/removed but cannot be deleted due to existing elimination data?

Answer The data is stored in the intersection even when the parent is removed. To clear the data, you would need to put the children back under the parent, run a DM job to clear data that is for E#[YourTopParent].DescendantsInclusive and T#[YourAppli...

Question: I am trying to clear out aggregated zero value rows after the transformation rules have been run but prior to the intersection validation. Can this be done without directly impacting/deleting rows in the stage tables?

Question (cont) The client is loading rows with net zero values from the source system and currently these are being loaded to a suspense account. Answer It is possible to interact with the process using an event handler business rule. However, you a...

Question: Can Transformation rules be edited in bulk? When loading rules, they merge instead of replacing.

Answer •The quickest way is to load the mappings into a new group and delete the group if no longer needed. •Currently, the functionality to bulk delete mappings is not available. Source: Office Hours 2020-06-04

OneStream Community

Knowledge Base Articles