count of projects within user access

Hi,

I have a list of projects that is in selective access. I need to be able to get the count or number of projects per user. For example user A has access to 1 project. Total count of projects is 4.

When I do a count line item (formula = 1 ) my line item result if 4 even if I only have access to 1 project. How will I be able to get the to get the result or 1 for the count. See screenshot below :

Thanks,

Ana

Accepted answers

All comments

ArunManickam

Hello Ana,

Aggregation of data is not impacted by filters and user access.

If you need to aggregate data based on user access, it is not possible straight. You need to follow some workaround, that creating the selective access as a module and referring this module to do the calculations.

You can import the data from this module into the User setup.

Selective access module ==> User Setup (Import process)

Selective access module ==> Drive calculations

Thanks

Arun

Ana22

Hi Arun,

Thanks but I'm confused on how to set up the selective access module with user set up? Do you mean I need to create a module with dimension of user and my project list?

Thanks,
Ana

akhil.kohli

Hi @Ana22

As @ArunManickam said there is no direct way to do this.

The only way I can think of is as follows

1. Export the users from Model Settings>Users in a CSV/TXT file.

2. Create a module with user dimension and get the 'project selective access' field from the exported users file to a text field. Though using text is not the best practice, but because a user will have an access to multiple projects, and those will be separated by a comma, thats the only way.

3. Using conditions, you will need to map the text with a line item with users and project as 2 dimensions. You can skip this line item and pass directly to 4 as well. Remember, Booleans are best in terms of performance while calculating.

4. Build a line item which has convert the conditions in the above line item to number. So it will be if true then 1. Dimensions being users and project. Summary being 'SUM'. Again if you skip 3, then you can have only this line item. Just that if there are multiple conditions, try avoiding.

5. In the final line item you will need to have it with the user dimension and get point it to the previous line which will aggregate the total across users.

Let us know if you have any further questions

Thanks

Akhil

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…