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

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…