Dimensions & Lookup

Anaplanners,

Been struggling on this particular piece:

We have a module where we have a Country Dimension and Serial Number list, as each country has a fixed number of 10 agents and some attributes (line items).

Refer Snip:

Agent Name & Agent Role are list formatted Line Items. "Country" and "No." are lists.

Requirement:

We want to avoid the "No." list and only show Country-Agent-Role. It was initially designed with fixed "No." list of 5, where countries may or may not have 5 agents, as in the case of Canada where they have just 3, while Asutralia as full 5.

I have already managed to get the country & agents using agent allocation formula however unable to get the role to this view.

Any suggestion/tip to solve this would be helpful. Thanks

Accepted answers

All comments

HimanshuRaj

@Sachinsourav02 I think a simpler approach would be to pivot this and have No. list then country list in rows

Hide No. list from UX by dragging the table header a little to left and use filter for isnotblank to only show entries where data exists

Cheers!!

umangsinghal

Put formula "Agent Role[Lookup: Agent Name]" in Target line item where Agent Name is the header you used in Target Module.

Sachinsourav02

@Umang Singhal That will not work, because of the "No." Dimension, hence looking for a workaround

Sachinsourav02

@HimanshuRaj

Yes that would have been great but there are other items as well that we bring in with this view. Each country has a Country Chair, Country VP, Country Head. These users (coming in from the same Agent List) does not have "No." list since they are one-to-one mapped to a country directly .

So this report is a consolidated view of country - its employees and their role. Employees include senior folks and agents (with "no" dimension)

HimanshuRaj

@Sachinsourav02 That should still be fine, as you should just create the subsidiary view line items for these and have them applicable only by Country. Have then arranged in columns but the filter for isnotblank should still work same

Cheers!!

Sachinsourav02

@HimanshuRaj I'm afriad that will not work, let me explain how:

Agent Name & Agent Role is dimensioned by Country and "No.", so agent is tagged to a "No."

Now to display a consolidated table with Country Dimension (excluding "No." list) including aforementioned Agent Name & Agent Role; plus leadership team details which Leadership Team Name and Leadership Team Role, this will have to be brought in with a different line item (like you suggested that does not have "No." dimension) then effectively we will have "split view" which is not desirable.

So i do not think it will be possible to bring them in a subsidiary view. Rather would there be a way to bring all of them in a separate module which avoids "No.".

albin

I believe you don't want the No dimension, am i right? you would like to transfer all the data to a new module without the No. dimension. If you're only worrying about the view, creating a separate view hiding No. will work.

joycesteffen

@penalty shooters 2 If you're facing challenges or need assistance with a specific aspect of this module, please provide more details or let me know the specific issue you're trying to address. This could include questions about the structure of your module, formula calculations, or any specific problems you're encountering.

linnea2

@Sachinsourav02 Is there a possible solution to display a consolidated table with Country Dimension, Agent Name, Agent Role, Leadership Team Name, and Leadership Team Role without having a "split view" or including the "No." dimension? Alternatively, is there a way to bring all the mentioned details into a separate module that avoids the "No." dimension altogether?

dinosaur game

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…