Get Consolidated Data from a User dimensioned module to a module without User dimension

Hi,

I have an input module with a user dimension, published in a DB where End users can enter the inputs. I want a consolidated module where I can view all the entries/data but without user details or dimension as it has nothing to do with users.

I used the User dimension in the input module to avoid overlapping or overwriting of data of other users when multiple users are entering the data at a time and bring flexibility where everyone's data is recorded.

Thanks,

Arnab

Accepted answers

rob_marshall

@Arnab116

Take a look at this article as I think it may help you. Also, I would stay away from TextList as much as possible as it could have performance impacts.

https://community.anaplan.com/t5/How-To/Summary-Calculations-With-the-User-List/ta-p/106027

Rob

alexpavel

@Arnab116 The aggregation of data by Users it is possible and it is very well explained in the @rob_marshall article.

The aggregation of the data by the Users native List has exactly the same approach as you would like to consolidate data for a "normal" list that does not have a total element (Top level) defined.

Just a clarification about the usage of the Users list:

I would be careful to use a Data Input module with Users list as the "final holder" of the data. The Users list can be a quite volatile list and new users can come..but also users can leave the company or change position and the security on a model could change for a user in "No Access" or the user can be deleted from the workspace. In these situations, all the input or saved data related to that user will be lost and you could have issues with the integrity of the consolidated data.

Users list it's a really helpful feature, but I would use the list only as a temporary holder of input/saved data or in modules related to filtering functionalities (where input data by the user is not important).

I hope it helps

Alex.

All comments

KirillKuznetsov

@Arnab116

Main problem is that userlist doesn't have top level.

You can try to use aggregation with a dummy list with a single element and a top level. This list can be used for SUM/TEXTLIST functions.

The same list has to be used in calculation module to aggregate as a mid-step.

After the aggregation you can pull this data to your target module as already you would have a top level in the calculation module.

Kirill

rob_marshall

@Arnab116

Take a look at this article as I think it may help you. Also, I would stay away from TextList as much as possible as it could have performance impacts.

https://community.anaplan.com/t5/How-To/Summary-Calculations-With-the-User-List/ta-p/106027

Rob

alexpavel

@Arnab116 The aggregation of data by Users it is possible and it is very well explained in the @rob_marshall article.

The aggregation of the data by the Users native List has exactly the same approach as you would like to consolidate data for a "normal" list that does not have a total element (Top level) defined.

Just a clarification about the usage of the Users list:

I hope it helps

Alex.

Quick Links

Can you help?

Unanswered questions

Hide the cards under "Models" section once connected
Hi Is there a way to hide the cards under the "Models" section once connected, as I would like the users to see only the links to the apps? Thank you
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…