Filtering on USER

Hi Team,

I'm wanting to filter a list dependent on which USER is viewing the module but I do not want to include USER as a dimension in the module

I have a Filter Module which has the Department List, USER list and a Boolean line item to indicate which Users I wish to have view access/filter access to Departments

The module which contains the Department List but not the USER list. It is filtered on the Filter Module.Line Item but this is filtering out all items

Is there a way to reference the current user without using the USER Dimension?

Many thanks

Mark

Accepted answers

andrewtye

Hi @MarkTurkenburg

Either i'm misunderstood but I think you're nearly there - yes you could use selective access but you're basically after is DCA but using the native user list, not a fake user list.

So i've done the modules that you've explained in the attachment plus what the filter needs to look like to make it work... the module with the line item/time in it doesn't have user at all.

Modules:

Filter:

You can also put this into the DCA settings which would clearly blank out the information without removing them entirely.

BTW... you did remember to select something on the filter module didn't you?

Andrew

All comments

JaredDolich

@MarkTurkenburg

Best thought I have for this condition is to create a system module that uses the "user" as a dimension and contains all of your properties, including a line item that is list formatted to the list that you'll need to use for the valid users in your dependent drop down.

The system module can be converted to a calculation module if you want, so you can effectively map the user list to your user-defined list.

Let me know if you'd like an example - happy to try to build that - but one way or the other, it seems to me you're going to need a 1:1 match between the current user and the user-defined list you're working with (by department).

MarkTurkenburg_*8288

Thanks @JaredDolich for the quick reply

In this example I want the USER to be able to view multiple items on the Department list so not sure the USER list with Department List as a line item will achieve this, as this would only allow for 1 item to be mapped through

Effectively I'm trying to recreate Selective Access with out activating Selective Access but it may just be a lot simpler to use it

Thanks

Mark

JaredDolich

@MarkTurkenburg

Is selective access a practical solution?

It does seem the easiest way.

I feel this is a common question though. I know I've had to deal with this on numerous projects.

Let me know. Happy to work out a solution with you if you want.

MarkTurkenburg_*8288

@JaredDolich

Yes I can use Selective Access, just a bit of a brain exercise to determine if I could get the result I wanted without it but it seems a little too difficult

Thanks for your help!

Mark

andrewtye

Hi @MarkTurkenburg

Either i'm misunderstood but I think you're nearly there - yes you could use selective access but you're basically after is DCA but using the native user list, not a fake user list.

So i've done the modules that you've explained in the attachment plus what the filter needs to look like to make it work... the module with the line item/time in it doesn't have user at all.

Modules:

Filter:

You can also put this into the DCA settings which would clearly blank out the information without removing them entirely.

BTW... you did remember to select something on the filter module didn't you?

Andrew

MarkTurkenburg_*8288

Thanks @andrewtye!

Yes that does work as I initially thought it might, I have no idea what I was doing the other day to result in a fail test but it's working now as expected (you do not require the USER dimension in the current module to filter it by USER)

Mark

andrewtye

Awesome. Glad that it confirmed what you were doing should've worked.

Maybe not working on a Sunday is the way forward??

MarkTurkenburg_*8288

Haha - unfortunately it was Monday for me, i'm based in Melbourne

Thanks

Quick Links

Can you help?

Unanswered questions

AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
Using time for something not time related - special characters :)$
We had a recent challenge with the need to "clean" invoice data descriptions from special characters. This was done previously in SQL with the a long convoluted formula "REPLACE(REPLACE(REPLACE('Ana&plan', '&', '') that would have to edited by a developer in case any new special characters came through. Using the replace…