ETL - Summary for hierarchy

Hello!

I am trying to build an ETL that will upload into a client's ERP system. They have some nuanced requirements, and I'm struggling to build one of those into our module. In the image below, I need to have the parent values displayed for the highlighted columns:

This module uses L2 for account numbers, and the parent is in L1. Is this possible? Blueprint is below:

Accepted answers

KirillKuznetsov

@DavidHunter

Check this topic. Might be helpful

https://community.anaplan.com/t5/Anaplan-Platform/To-display-code-of-Child-and-parent-in-a-single-line-item/m-p/146683#M39467

All comments

JaredDolich

@DavidHunter

Hey David. You can just add a line item that uses the PARENT function. This will allow you to have both the ITEM and the PARENT, L1 and L2, in the same grid for export.

KirillKuznetsov

@DavidHunter

Check this topic. Might be helpful

https://community.anaplan.com/t5/Anaplan-Platform/To-display-code-of-Child-and-parent-in-a-single-line-item/m-p/146683#M39467

DavidHunter

This is great, thank you! I'm realizing the hierarchies we're using for this specific ETL aren't designed for that type of solution. However that's an easy fix. I'll just implement this systems module with the whole income statement then reference it via lookup.

Thanks again for the solution!

rob_marshall

@DavidHunter

Quick question, why are needing to export summarized/aggregated data? Usually, you only need to export detailed level data and then the target system aggregates the data.

DavidHunter

Hey Rob, This is how the request came through. I do not have the details on the system being uploaded to unfortunately.

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…