need to get lineitem into module with different dimensions

Olek P
edited January 2023 in Modeling

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

Tagged:

Best Answer

  • fabien.junod
    edited November 2022 Answer ✓

    @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

Answers

  • Sai_Bharadwaj_Venati
    edited November 2022

    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. 

     

     

    V.Sai Bharadwaj

    Connect on LinkedIn

  • Olek P
    edited November 2022

    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? 

  • Olek P
    edited November 2022

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

  • fabien.junod
    edited November 2022

    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)

    fabienjunod_0-1668533471855.png

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

     

    fabienjunod_1-1668533525392.png

    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

    fabienjunod_2-1668533642441.png

     

    fabienjunod_1-1668534095150.png

     

     

    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

    fabienjunod_3-1668533818857.png

    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"

    fabienjunod_4-1668533916040.png

     

     

     

  • Olek P
    edited November 2022

    thank you so much, you're the GOAT