TEXTLIST- multiple dimensions

Could any Anaplan pros please assist with a TEXTLIST aggregation? I am not sure how I would do this over multiple dimensions. It is basically concatenating all the applicable pages numbers into one text based line item for each employee / report version / user.

I have attached the blueprint. The line item I am trying to solve is highlighted in yellow and the values I am trying to concatenate are in the line item called 'Text to Use'.

CAL17 Page Numbers.xls

Thank you in advance!

Accepted answers

sobaid

Hi @kristenr ,You can try, and let me know if you've any questions

1.You can create another module with dimension, say Employee dimension and Report version
2. Create a line item, and input the formula
TEXTLIST('CAL17 Page Numbers'.Text to Use, ",", User, ALL)
you can even try below formula if you want unique page numbers and not repeated TEXTLIST('CAL17 Page Numbers'.Text to Use, ",", User, unique)

3.Under Cal17 module under Text List line item, with subsidiary view dimensioned by Employee dimension and Report version, you can fetch using direct reference
4. After you achieved, If you want to increase column size, right click on line item under column settings→Individual column width →input the number say 250 for Text List line item and save the main/Saved view

sobaid

Hey glad it worked out!, would you mind marking the post as answered! Thanks!!

All comments

sobaid

Hi @kristenr , if you could picture the scenario or a screenshot of the module view would be helpful

kristenr

Thanks @sobaid - I have hidden the dimensions - they are employee, report version, user

sobaid

I am sorry asking again for details, how do you want the output to be or look like

kristenr

@sobaid - like this:

1,2,3,4,5,6,8,9,10,11,12,13,14. It so the user can copy and paste it into the export pdf select pages field.

sobaid

Hi @kristenr ,You can try, and let me know if you've any questions

kristenr

@sobaid - thank you so much, it worked!!

sobaid

Hey glad it worked out!, would you mind marking the post as answered! 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…