Adding a common line item associated with a single list item

Options

Hello all,

 

Can you please advice how to add "line item associated with a single list items"?

 

In the attached screen shot, 

•MU approved/agreed and 

•GS approved 

are list items and I have created a nested dimension in module, such that the line item is common for these list items. 

 

Now I need to add, the columns highlighted in yellow but I am unable to get it.

 

Can you please guide on it.

 

Thank you,

harshitha N.

Best Answer

Answers

  • harshitha.narayan@sony.com 

     

    You can not have a line item associated with list items. Line items are applied to the entire list (or in other words dimension). There will be some empty cells that we call Sparsity in Anaplan language, that is fair but there is no slice and dice in such cases.

     

    If it is for reporting purpose then I would say consider using SHOW or HIDE options.

     

    Thanks,

    Misbah

    Miz Logix

  • harshitha.narayan@sony.com 

     

    Glad that you figured it out but I would advise not to use SELECT. Instead you can use LOOKUP to avoid getting into scalability issues.

     

    Thanks,

    Misbah

    Miz Logix

  • I did try using Lookup but it did not give me the results. For any similar issues in future shall use the lookup functionality.