Target module with less number of lists

In my situation here, I have a source module that has two dimensions - EMP and Geo and Time and line item called MAP which is list formatted (GEO).
Target dimension has one dimension EMP and Time and line item that is list formatted (GEO).
I want to bring in the Geo from source to target in this case. Since the target has less dimension, if I were to bring in number, it would give me the aggregated value from the source to the target by default, however, since I have list-formated item I want to bring, the option I am aware of is to bring in the firstnon blank or lastnonblank. So in this case, since my source GEO list has summary method of lastnonblank, my target shows South for Jan.
a. Is there any option to bring in GEO of my choice in this scenario or
b. bring in multiple values in the target. In this example, Sam is tagged in East as well as South. Is there option to bring in both in some way?
Thanks

Accepted answers

All comments

HimanshuRaj

Hi @khoonks

You can follow below steps:

Create a sys lookup module as mentioned below and apply formula as shown in second window. You can pull "Geo" based on the selection
You can use textlist to pull in all geo's mapped to an employee. Although textlist should be avoided due to performance issue.

Cheers!!

rob_marshall

@khoonks

It is possible you put together an ad-hoc example, but I "think" your first module (EMP_reg) is over-dimensionalized as I don't believe you need the region dimension (the current row axis). This doesn't solve your issue, just something I noticed. Also, I am not sure if you have seen this or not, but you might want to take a look at this thread on TextList()

https://community.anaplan.com/discussion/53085/lookup-sum-and-textlist-cheat-sheet

Textlist() should be avoided at all costs, it is absolutely horrendous on performance.

khoonks

How about pulling the other way round, where the source has No time dimension but the target does.

I have a kind of a mapping table by EMPLOYEE NAME and REGION. There is a boolean line item called MAPPED?

I have a target table with TIME, as well as REGION and a dimension called Entity.

I tried using FIRSTNONBLANK as the summary method for EMPLOYEE NAME in source module, however, it does not seem to work. Can I do some kind of LOOKUP on the BOOLEAN (MAPPED? ) line item to get those values.. Note that CHECKED is BOOLEAN.

Thanks

khoonks

Thanks all for the advise.

khoonks

Thanks, I was able to figure out a way of bringing the code from source. Thanks anyways.

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
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…