Users list and Lookup

damien.bouquier

Hi Everyone,

I have two modules A and B.

The module A has one line item formated as a list "Users". Let's call it myUser.

The module B's dimensionnality is Users (only). It has one boolean lineitem called myBool.

I would like to retreive the value from B.myBool to A.

I wanted to use the formula in module

A.myBool = B.myBool[LOOKUP : myUser]

Anaplan failed with the following error message :

Invalid use of 'Users' list with function 'LOOKUP'

Do you have any workaround ?

Best regards

Accepted answers

All comments

rob_marshall

Damien,

If you create a new list called "Fake Users" with a top level, you will be able to accomplish in the exact same way as you have stated below, if I am understanding you correctly. Please see the attached.

Please let me know if this helps.

Fake_Users_36138.docx

rolympia

As of today 5/6/2019, Anaplan does not allow you to transfer values of a line item with the dimensionality of Users to another of different dimensionality (say, Custom_Users), even with the use of a mapping (lookup) from Users to Custom_Users. The reverse is permissible: if the source is a line item of dimensionality Custom_Users, it can be brought into another with dimensionality Users using a mapping (lookup) from Custom_Users to Users. There's a distinction to be made, as sometimes, you do want the final working dimension to be a normal non-Users list (since that has a top level, etc.). In that case, the process would have been 1) input using Users-dimensioned line item, 2) transfer to Custom_Users, and 3) do calculations and reports using Custom_Users. Again, as of writing this is not permissible.

I offer two workarounds:

1) Run an import process that transfers data from the Users-dimensioned to the Custom_Users-dimensioned.

2) Use Custom Users as the dimensionality, applying a filter with dimensionality Custom_Users x Users (TRUE if Custom_Users = Users). This ensures a User can only see his/her corresponding Custom_Users list element.

I will be first to admit that neither are perfect, 1)'s disadvantage being dependence on a process to be run, and 2)'s disadvantage is requiring a Custom Users maintenance to Users, though this can be solved easily by using the same coding and doing a finditem. Let's hope some enhancement comes its way.

dafinkapancheva

Hi @damien.bouquier and @rolympia ,

I have some exciting news - we are looking to enable LOOKUP, SUM, TEXTLIST and a number of other functions to be used over the Users list in early Q2.

Keep an eye on the upcoming releases!

Best Regards,

Dafinka

tompatrick.ting

@dafinkapancheva Hi,

Do we have any update on this ?

Thanks,

Tom

rob_marshall

@tompatrick.ting

Things are still on track, look for something coming out towards the end of this month. The Users list will not have a Top Level, but you will be able to lookups like @dafinkapancheva mentioned.

Rob

rob_marshall

@damien.bouquier @tompatrick.ting

Please take a look at this...Also, @damien.bouquier take a look at the first example, it should look familiar.

https://community.anaplan.com/t5/How-To/Summary-Calculations-With-the-User-List/ta-p/106027

Rob

Quick Links

Can you help?

Unanswered questions

How to create identical child items for multiple parents
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…