How to make an export that contains the dimensions' parents in separate columns?

Hi guys!

I would like to know if there is any way to create an export of a model so that the parents of the dimensions are in separate columns, for example:

This is my module

When I export, the table looks like this:

I would like each "parent" to be a separate column, even if it repeats the information. No problem.
In a similar way to pivot in excel.

Taking advantage, if this is possible, is it also possible to leave the visualization in an app like this?

Accepted answers

All comments

seymatas1

Hi @Guilhermecord10,

Did you try all the pivoting options?

Did you try all the export options?

Do you want to have both months and parents in the columns? This means you will have a lot of columns.

Can you create an expected outcome in Excel?

Guilhermecord10

Hi!It's like this today:

{6FFAE5A1-422C-4DC6-AC82-32BEB0FA53B9}.png

I would like to export it like this:

{B1DEACC0-3EC9-4F2C-9792-7A250C91E729}.png

In this example, "Facilities" is the parent of "Utilities" and "Office", which in turn "Rent" is the child of "Office" and "Fixed Costs" is the child of "Utilities".

When I refer to "even if the information is repeated.." it's like the example where "Facilities" appears on several lines.

luke_e

I think you can do this using the 'Labels' function within exports.

It does however require you creating a property against the list to represent the 'parent', and the parents'.. parent if appropriate.

For example, by default for a non-numbered list, you'd see 'Name' and 'Code' as additional label options.

In the below list, we've also created an additional list property which represents a linkage to another business unit and we're able attach this property when running exports.

In cases where we do this, we typically built out an export action because it can be tedious with numerous lists and a saved export definition will preserve the setup.

The only limitation is that properties are not versioned, but if you're just looking to show parents, I don't think it's an issue.

Hope it helps.

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…