Users List-Workspace Admin

Sachinsourav02
Sachinsourav02
in Modeling

Hey guys,

Got a query, i have a module with Users and Business Line and boolean line item which enables each user to a  business unit. 

I published the same on a page but users without workspace admin are unable to view the users list, is there a way to make it enabled for them ? Or a workaround for this issue ?

Thanks

Tagged:

Best Answers

  • anand.shekhawat
    anand.shekhawat
    Answer ✓

    @Sachinsourav02 

    You can create a Custom User List and use this as a dimension in your module. Create one more user formatted line item and map this custom user list to the Anaplan's User list by using the formula FINDITEM(Users, NAME(ITEM(Custom User List))). It will serve your purpose

     

    I hope it helps

     

    ~Anand

    https://in.linkedin.com/in/anand-shekhawat-35645486

  • anand.shekhawat
    anand.shekhawat
    Answer ✓

    @Sachinsourav02 

     

    Kindly follow the below steps and snips to achieve the linking capability of both the modules.

    Step 1) The below Module B is created with custom user list or fake user list. Data 1 and Data 2 are taken for reference.

    anandshekhawat_0-1625302731806.png

    Step 2) Module A is created with the Anaplan Users List. Data 1 and Data 2 line items get their data from the Module B. The third line item 'Finditem Custom User List' is 'Custom User List' formatted.

    anandshekhawat_1-1625302959016.png

    anandshekhawat_2-1625303145829.png

    The formulas used are mentioned below

    Data 1: Module B.'Data 1'[LOOKUP: Finditem Custom User List]

    Data 2: Module B.'Data 2'[LOOKUP: Finditem Custom User List]

    Finditem Custom User List: FINDITEM(Custom Users List, NAME(ITEM(Users)))

     

    Like wise you can pull all the data from the Module B into Module A by using lookup.

     

    I hope it helps

     

    ~Anand

     

    https://in.linkedin.com/in/anand-shekhawat-35645486

Answers

  • Sachinsourav02
    Sachinsourav02

    @anand.shekhawat  Hey thanks for that, I am able to get it. 

    Could you help me on how i can link this to my original module ? Like i have two modules, Module A with users and Module B with fake users. In module B using find item i have achieved to get users but how do I link the values selected in module B to Module A, i do not want to change that as there are series of other dependent modules to A which use users as dimension.

    Thanks 

Categories