Create Hierarchial list using import

Hi,

I am trying to create a list as shown in the attached image. Here i have'nt created the seperate list for 5804 (which is like parent list). To avoid sparsity & size constrain, i am trying to create parent & child list in the same list. I know how to create in the tool for less items. Can someone tell me how to use Import data to create such list with bulk data.

Thanks,

Sangeetha

Accepted answers

All comments

PaulRitner

Hi,

the Excel add-in can be obtained here:

https://help.anaplan.com/anapedia/Content/Extensions_and_Addins/Excel_Add-In.html

paul

dimonk

Hi,

I think that my question is about "exporting data". 🙂

I want to get data from module without "process action". I want to do it as in Excel add in.
So - I need the description of protocol between "Excel add in" and "Anaplan".

Do somebody know this protocol?

PaulRitner

Hi,

The link to the Excel Add-in describes the full capability of pulling a saved view (or the default view) from modules in Anaplan. This doesn't involve export actions at all.

The protocol between "Excel add in" and "Anaplan" is pretty straight forward:

Download and install the Excel Add In (see link in last post)
Open Excel
Click on the Anaplan Ribbon
Log into Anaplan via Excel
Query Anaplan from Excel by selecting Model, Module, View (Saved or Default).
The queried data (in Excel) can be shared with other people as a static data set / report, but can only be refreshed by users with appropriate access in Anaplan.

Other methods for getting data out of Anaplan all involve an Export Action. For example, if we use the Restful API or Anaplan Connect, there would have to be an Export Action referenced. The Excel Add-in pulls data into Excel directly from modules.

Good luck!

Paul

dimonk

Hi, Paul!

Thank you for answer!!!

>>Query Anaplan from Excel by selecting Model, Module, View (Saved or Default)

I would like to use it in my own application (direct reading data from module as in excel add on). I do not want to use Restful API (with Export Action).

Quick Links

Can you help?

Unanswered questions

Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…