Can't add a parent to a existing list

Options
LucaRicci
LucaRicci
edited November 2023 in Modeling

Hi all,

I am having some troubles adding a new hierarchical level to an existing list, which is called BU01 Business Unit and it's not a numbered list; the new parent should be BU00 Business Unit Combine:

image.png

If I try to compile the parent hierarchy column, I get this error:

image.png

If I try to delete All Business Unit from the Top Level column, I get this other error:

image.png

How can I solve this issue?

Thanks

Tagged:

Answers

  • axel.frot
    axel.frot
    edited November 2023
    Options

    Hello LucaRicci !

    In this kind of exercise, it's important to check that the formulas don't use top levels.
    In this case, doesn't your formula have a "formula" summary?

  • Ashutosh
    Ashutosh
    Options

    Hi Luca,

    You need to check parent and child level and modify the formula's accordingly. Coz if u are adding new hierachy in between. Parent and child relation will change and formula will give error.

  • pyrypeura
    pyrypeura
    Options

    Exactly as pointed that changing the parent breaks some formula logics in the model. You should start by removing the conflicting formulas. Then change the parent list and lastly fix the formulas that were causing problems.

  • AkhilEmmanual
    AkhilEmmanual
    Options

    Hi @LucaRicci ,

    1. Remove the top level . For that you need to check in which all line items where this list is not a dimension and data is coming from line items where this list is used as dimension.In those line items remove the formula .
    2. Add Parent
    3. Put back the removed formula.

    I hope this may solve your issue.

    Thanks and Regards,

    Akhil Emmanual

Categories