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.
Henning
OneStream Employee
OneStream EmployeeHi, do you wish to see the mapping as per what Teresa pointed you to, or do you mean you wish to see the mapped data?
If you want to see a table that includes mapped source and target members as well as data of loaded data, you can use a data adapter that pulls data from the view called "vStageSourceAndTargetData".
To check the table and the columns, you can start by using e.g.
SELECT TOP (10) *
FROM vStageSourceAndTargetDataIn the table, e.g. the column "Ac" will display your source account member before the mapping, and the column "AcT" will display your target account after the mapping for the data record of the respective row.
And yes, you can enhance this will all kinds of approaches such as business rules and more advanced dashboards if needed, but the data adapter with limited SQL is the easiest to begin with.
HenningOneStream Employee
OneStream EmployeeJust 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.