I am trying to create a module where I will have a list that rolls up to two different parents.

Dasgups3 · 2023-09-04T12:21:16+00:00

There was an error rendering this rich post.

I am getting an error "an invalid Applies To for Test because Domestic and International have a common ancestor."

I am trying to create a module with few list member that rolls up to two different parents. For example- Product A Product B is a part of Domestic Sales destination and Product C and Product D is a part of International Sales Destination.

Also Product A is a part of Domestic A channel category, Product B is Domestic B category. Also Domestic A and B is a child of Domestic Sales Destination.

I tried to create subset under Domestic Sales Destination with Domestic A and Domestic B and call those in module as separate dimension but getting error "an invalid Applies To for Test because Domestic and International have a common ancestor."

Please guide me.

Accepted answers

All comments

aakash

Hi @Dasgups3 ,

From your question,

The correct list structure should be for a possible solution to your problem

You can also choose to keep Domestic A and Domestic B as a property of the list that has elements (A,B, C and D)This would depend upon the exact requirement you have. Hope this helps,Regards,Aakash Sachdeva

Dasgups3

Product	Channel	23-Jan
Product A	DomesticA
Product B	DomesticB
Product C	DomesticC
Product D	DomesticD
Domestic		Total Domestic
Product E	International
Product F	International
International		Total International

I want the set up like this. DomesticA, DomesticB should be a channel list separately and also Product A will roll up to Domestic A and Domestic. I have created a list for Product A, Product B that rolls up to Domestic and created Channel Subset. But that Subset is not taking in the module dimension. Getting error.

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…