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

Guilhermecord10

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?

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:

I would like to export it like this:

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.