need to get lineitem into module with different dimensions

Olek P

Hi All,

In need of some dire help right now.

Background: I work for a lending company. We dimension the data by turn (you can think of this as length of the loan)

How can I pull the "override amount" line item in ss1 into the "override from UX" line item in ss2?

it can go into any of the list members in dimensioned in the columns if it has to idc. Thanks

Accepted answers

fabien.junod

@opolishchuk

As @Sai_Bharadwaj_Venati mentioned it, the module in ss2 has few more dimensions. Hence, if you directly reference the override from ss1 in ss2, that override would be "sent" to each list items of the extra dimensions. As a result, you would be counting multiple times the override.

If you don't want that and would like to send the override to a specific line item for each dimension, you could write

IF list_item_1 and list_item_2 and list_item_3 THEN override from ss1 ELSE 0

where list_item_x are boolean line items in the SYS module for each of the additional dimensions where the desired list item is set as TRUE

All comments

Sai_Bharadwaj_Venati

U r module 1 has dimensions -> Turn, Month; U r module 2 has some extra dimensions but includes Turn, Months. I think directly referring to module 1 should fetch the data.

fabien.junod

@opolishchuk

If you don't want that and would like to send the override to a specific line item for each dimension, you could write

IF list_item_1 and list_item_2 and list_item_3 THEN override from ss1 ELSE 0

where list_item_x are boolean line items in the SYS module for each of the additional dimensions where the desired list item is set as TRUE

Olek P

Hi Fablen,

Thank you so much. One quick follow up question.

Could you elaborate on the last part of your message please? So what would I have to do if I want to only add 10 million to one dimension? (turn 6) Would I have to select one specific item for the rest of the dimensions?

ss6_151957.png

ss7_151957.png

Olek P

and what would the system modules look like? what are the dimensions?

fabien.junod

Hello @opolishchuk

Let's assume in your target model (C18 Allocated Production Summary) you have 3 extra dimensions that are not in you source module (C76 checkbox Q > M). I have highlighted those extra dimensions in yellow (Credit, Radio and New Cash Advance)

Let's also assume these are the items in those dimensions (i.e. lists)

For each of those lists, you create a SYS module with a bollean "list item for override" line item. The SYS module only have one dimension (Credit, Radio and New Cash Advance). Then you select in which list item you want the override to flow to. ONLY select ONE list item

Then, in you target module the formula for the "Override from UX" would be

IF SYS Credit.List item for override AND SYS Radio.List item for override AND SYS Cash Advance.List item for override THEN 'C76 Checkbox Q>M'.Override Amount ELSE 0

You can see the override appears under the selected list items in the SYS modules. In my case, I selected "Credit 2", "Radio 1" and "Cash Advance 2"

Olek P

thank you so much, you're the GOAT

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…