Forum Discussion

Spalomino's avatar
Spalomino
New Contributor II
6 months ago

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 do I confirm accounts (A#)?

Thanks,

Steve P.

Infrastructure
  • Henning's avatar
    Henning
    6 months ago

    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.

  • Spalomino's avatar
    Spalomino
    New Contributor II
    6 months ago

    Thanks everyone for the help.  I very much appreciate the input and information.

  • T_Kress's avatar
    T_Kress
    Contributor III
    6 months ago

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

     

     

     

  • Spalomino's avatar
    Spalomino
    New Contributor II
    6 months ago

    Teresa:  Thanks for the response.  You are on the right track.  What if I want to see "all" of my 30 entities at once?  Can I go into OneStream and use a data adapter and write a SQL script against a table and see all the mapping?  To avoid having to go one by one.  Hope my question makes more sense.

    Thanks,
    SP

    • Henning's avatar
      Henning
      Valued Contributor II
      6 months ago

      Hi, 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 vStageSourceAndTargetData

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

      • Henning's avatar
        Henning
        Valued Contributor II
        6 months ago

        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.