Filter based on User dimension

I am having 2 dropdown selections "Start Date & End Date" which is with respect to default users dimension.

There is a date formatted line item (Load Date) in target module which is dimensioned by a list "A" and not having users list as dimension.

Now, the target module needs to be filtered out based on the logic (Load Date>=Start Date and Load Date<=End Date).

Could you please help with this.

Regards

Shirisha.

Accepted answers

All comments

AjayM

Hi Shirisha,

You can't achieve this without adding a filter dimensioned by both users list and list 'A', since the start date and end date selections are by user.

In other words, add a boolean lineitem dimensioned by 'users' and list 'A' in the target module, and enter the formula (Load Date>=Start Date and Load Date<=End Date) here. Now, on the UX page, when you publish target module, you should add the filter, which respects start date and end date selections for respective user.

Cheers!

1635834

@AjayM

Thank you. I did the same, but I need this in old UX (Classic).

Created a saved view in the target module, but when applying the filter I am not able to select Current user as the module is not dimensioned by Users. Hence it's not working for all the users. It's only working for the user selected in the filter.

Any idea about this.

Regards

Shirisha.

AjayM

Hi Shirisha,

While adding filter to the module (be it on module's saved view or on the dashboard), your filter should default to current user, which would auto apply to respective user, whoever operates the dashboard.

Can you please retry and share snapshot of your filter and blueprint view of the target module, if it doesn't work still?

Quick Links

Can you help?

Unanswered questions

How do I determine why Anaplan API login fails intermittently ?
Hello, My interface uses basic authentication to log in to Anaplan. The login process has been failing intermittently for about a week. How can I identify the root cause of these Anaplan API login failures? Username and password are correct. The account is not locked or expired. Thanks, Jorge Palma
Anaplan XL license issue
Hello , I recently started Anaplan XL course , added XL however not able to add license How to ad license
Error while uploading ADO screenshots
Hello Anaplan Community, I'm facing an issue while uploading ADO screenshots, crosschecked my file size and naming conventions they are correct as mentioned in the lesson. Anyone faced the same issue? Pls let me know how if any solution to this problem. Thank you.