Office Hours
Questions and Answers from real consultants

Knowledge Base Articles

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...

OSAdmin_0-1628694066964.png OSAdmin_1-1628694097326.png OSAdmin_2-1628694119931.png QandA.png
OSAdmin by Valued Contributor
  • 216 Views
  • 0 comments
  • 0 kudos

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...

OSAdmin_0-1628014997360.png QandA.png
OSAdmin by Valued Contributor
  • 322 Views
  • 0 comments
  • 0 kudos
Top Contributors