Export with different dimensions

Hello,

I am trying to make an export. In my Export, I need to show on a column category Int and category Ext (both on same column). The problem that I have is that the domensions that I need to use for this information are in the Children of my dimension. Let me make a scheme;

Dimension A - the one I have to use

Dimension B (child of A) - with Subset sB - in the Subset I have my Category Int

Dimension C (child of B) - with subset sC - In the subset sC i have my Category EXt

In my Export module, i need to show somehow the two categories Int and Ext linked to the elements of Dimansion A. Any ideas? Maybe a Lis would help? Tryed several but Im stuck.

Thanks

Accepted answers

All comments

pvijayteja

If I understood this right, you're trying to use both a parent level and two child levels into same view.
Anaplan doesn't allow this for good reasons.

One alternate is using flat lists - You can use flat list versions of your data as dimensions in the module. Your new module for example can have three dimensions as described above, but Dimensions B and C will be flat and not be children of Dimension A.

Dikshant

I agree. You can create an import, and out of those two subsets in List A, you can create two flat lists and use those two new flat lists along with List A as a dimension in a new module.

Would like to see a mockup, why you wanted to create such module and what's the use case/ problem statement to think if there is any other solution to it?

ilincach

Thanks @Dikshant . Not sure I understood right what you meant by "you can create an import, and out of those two subsets in List A, you can create two flat lists and use those two new flat lists along with List A as a dimension in a new module"? What import are you refering at exacly? So I will leave the initial subsets and create two flat lists with those two subsets?

Dikshant

@ilincach, Exactly, you can maintain two subsets, but you need to have those items in a separate lists, so that you can have all of them together in a module.

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…