The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Intercompany Transformation rule profile
Good Day All:
What table would contain the intercompany rule profile. I see source value and target value in the grid. But I want to see all mapping. On target value, I just see entity name, how ...
Just to add to this, this is how the data adapter can look like:
And this is the result in my case (scrolled to the right to display Ac and Act in column 1 and 2 on the left hand side):
This is of course - as per screenshot - a very raw form of looking at the table. With some more simple SQL, this will look nicer and easy to consume.
T_Kress
OneStream Employee
OneStream EmployeeI am not 100% sure I am following but first, you would want to go to the WF import profile to where you are loading and mapping data:
From the correct WF profile you can find the "Transformation Profile Name". Then you would go to that transformation profile name and there you can find the intercompany mapping table:
The table above will tell you how all the intercompany data in a source file is mapped to ICP dimension.
As you probably know you it is a combination of E# property settings and A# property settings that ultimately control what accounts and entities are allowed to have IC mapping.