Office Hours

Question: Are there any issues changing the setting on an account to “Is IC Account = TRUE” once the account already has data?

Answer If the account is initially set to “Is IC Account = FALSE”, then presumably all data in the account is sitting in I#None. If this is the case, changing to “Is IC Account = True” should be OK. The reverse of this might not be though…

Question: If you have a parent corporate cube with two divisional extended cubes, and IC accounts have been extended in each, can you do eliminations in the Corp cube?

Answer Yes, you can, but generally there will be issues with IC matching functionality working properly in the workflow. But, there are work-arounds for this. With the above, IC matching will not work properly because the account containing the offse...

Is it possible to write intercompany eliminations to a specific UD member in addition to the out of the box use of the Elimination members used by OS in the Consolidation and Origin dimensions? Looking for the member formula/BR syntax and hoping this can be done without the need to turn on the consolidation algorithm in the application/cube settings.

Answer The rule should write the data to the C#Elimination and O#Elimination members. We can also isolate the accounts the rule should run for by using a filter to only run for the accounts that we tagged. The rule can be written in a business rule o...

OneStream Community

Knowledge Base Articles

Question: Are there any issues changing the setting on an account to “Is IC Account = TRUE” once the account already has data?

Question: If you have a parent corporate cube with two divisional extended cubes, and IC accounts have been extended in each, can you do eliminations in the Corp cube?