In
this weblog, we are going to see tips on how to carry out an intercompany knowledge translation with ease,
This
rule ensures intercompany knowledge is clear, aligned, and immediately processed when
customers save a kind. It applies commonplace naming and enterprise logic
routinely—no guide cleanup wanted. Information flows straight into the goal dice or POV, lowering cycle time and
reconciliation effort. It improves auditability and consistency throughout
entities, accounts, and merchandise. The outcome? Quicker closes, fewer errors, and
extra belief in your numbers
Advantages
of This Rule?
- Sensible Information Transformation: Automates the
cleanup of messy or inconsistent member names. No must depend on guide
fixes or assume customers all the time get it proper. - Correct Intercompany Processing: Ensures
intercompany knowledge is grouped and processed appropriately essential in monetary
programs. - Dependable Save Operations: Solely runs when
there’s one thing price saving. It will not crash or run on an empty kind. - Higher Information Integrity: Ensures the info
written to the dice follows anticipated patterns and naming requirements,
lowering errors and rework. - Repeatable & Scalable: This logic can
be reused throughout entities, merchandise, and accounts. One rule to rule them
all.
The
Rule’s job is to:
- Guarantee a
kind has been saved (aka, there’s a grid of information to work with). - Group
modifications made to the shape by the “Intercompany” dimension. - Remodel
the info (regulate dimension members if wanted). - Load the
remodeled knowledge into a particular dice or POV.
Consider it like having a spreadsheet
the place customers can enter some monetary knowledge. Once they click on “Save”,
this rule springs into motion behind the scenes, cleansing up the info, fixing
naming conventions, organizing it, and stuffing it into the suitable place within the
dice. Fairly cool, proper?
Right here
it does test for the info Grid, after which entry the supplied dice. On this
case its Fin_Pln. Then retrieve all the scale of the dice.
Retrieves all the scale and their members a part of the POV. Additionally will get the scale that aren’t a part of the POV.
Will get the edited icp members and for every icp member a POV is created and an information grid builder is created.
For every edited icp member a column is added and rows are added that are a part of the info kind.
Then the transformation occurs as per the icp logic for the scale members that wants transformation. Right here its for product, element & account dimension members.
Lastly the info is saved to the grid and the log is printed to the job console for debugging and audit.
Conclusion:
if (!operation.hasGrid()): Checks if
there’s a saved kind with knowledge. If not, it throws an error and stops
the whole lot. No knowledge? No get together.
operation.getGrid() and getCube(‘PCM_CLC’):
These strains seize the saved kind knowledge (the “grid”) and the dice we’re
working with. Consider it like opening the suitable Excel tab and grabbing the
spreadsheet.
Gathering the POV and Dimensions: It
figures out which dimensions are fastened within the kind’s POV (like headers) and
which of them are in rows or columns. Why? As a result of the rule must know the place to
inject the info.
Grouping Edited Cells by Intercompany:
This half organizes all of the modifications the consumer made by the
“Intercompany” member, which helps the rule act neatly and
effectively by dealing with one intercompany worth at a time.
Information Transformation: Right here’s the place the
rule earns its maintain. It modifies:
- Account
names (e.g., “0010” turns into “0010_icp”), - Product
names (“Product_NA” turns into one thing clearer), - And
Element entries to standardize them.
Constructing the Information Grid: For every
Intercompany group, the script builds a grid with all of the wanted POV values and
remodeled row values, then writes it again to the dice. It is like taking
cleaned knowledge from one tab and pasting it neatly into one other with excellent
formatting.
Customise
it as wanted and check out it out as per your software,
Comfortable
days on the Cloud!!!
