To display code of Child and parent in a single line item

Options
riyazpasha
riyazpasha Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 Frequent Contributor
in Planning & Modeling

Hi,

Is it possible in Anaplan to display the codes of both Child and parent in a single line item. I have requirement to show the code of both in the same line item.

If its Boolean then Any or All summary would work since its text and the list would be at child level I can't apply Formula as a summary so any work around for this. 

 

I have attached the screenshot for reference 

riyazpasha_1-1662875343019.png

riyazpasha_2-1662875369416.png

Regards,

Riyaz Pasha

Tagged:

Comments

  • Misbah
    Misbah Member, ALL USERS, GroupMember, Partner, User Group Leader, Certified Model Builder Posts: 5

    @riyazpasha 

     

    No, You can not get the codes of the Child and Parent in the same line item by changing the Summary because that line will be dimensioned by one or other list of the same hierarchy. You will have to create multiple lines - one for child and one for Parent  & other technical lines - then merge them into one.

     

    https://community.anaplan.com/t5/Anaplan-Platform/RANK-within-Multiple-Hierarchies/td-p/59564

     

    See if this article helps, you may need to read just a few paragraphs.

    Misbah

    Miz Logix

  • riyazpasha
    riyazpasha Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 Frequent Contributor

    Hi @KirillKuznetsov 

    Thanks for the quick response

     

    I need the child and Parent code in line item Code F2 which is at F2 Assets level.

    Can I get the codes highlighted in yellow in the code F2 which is written in the blue text. Not to concat the child and parent code

     

    Basically I want to show child code( Campus Communities 1,2,3), Campus communities(F1 level) code and Campus communities at Code Reporting level in the same line item

    riyazpasha_0-1662915129362.png 

    Regards,

    Riyaz Pasha

  • riyazpasha
    riyazpasha Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 Frequent Contributor

    Hi @Misbah ,

     

    Thank for the wonderful article. 

    I guess it works for the non number list but for number list it might not work. Currently in my case I have number list so I tried same logic which is not working as NAME(List) will give me #1(ID) but if I try to replace by referencing the display name it would work for F2 Assets but not for F1 and Reporting level so I guess there is no work around for it.

     

    Regards,

    Riyaz Pasha

  • riyazpasha
    riyazpasha Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 Frequent Contributor

    Hi @KirillKuznetsov ,

     

    For a number list NAME(F1 Investment) will give ID. That's what I meant in my previous reply. 

    Thanks for the prompt response.

    riyazpasha_0-1662992480273.png

    Regards,

    Riyaz Pasha

  • riyazpasha
    riyazpasha Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 Frequent Contributor

    @KirillKuznetsov ,

     

    Yep I can use lookup I didn't thought about this.

    Thanks for the response

     

    Regards,

    Riyaz Pasha

Categories