ITEM(TIME) on Parent Time Items

MarkTurkenburg_*8288
MarkTurkenburg_*8288
in Modeling

Hi Team,

 

I'm creating a Time Map module  for Time Dimension - Months for a Model Calendar with Weeks with Half-Year Totals selectred

 

The 1st Line Item in my Time Map is ITEM(TIME) which Time Period - Month as the Format & Formulas as the Summary

 

My expectation was that for Parent items, e.g. Half-Year or Year, it would return the Half-Year or Year ITEM but it is returning the 1st item in that Parents list. So for H1 FY20 it is returning Jan20. Any ideas on why this is not returning those values?

 

 

IMG1.PNG

 

IMG2.PNG

 

 

This question has arisen because I was trying to create a filter for Time - Weeks where Weeks & Months were TRUE but Half-Year & Year were FALSE

 

Thanks!

 

Mark

 

 

 

Tagged:

Best Answer

  • rob_marshall
    rob_marshall
    Answer ✓

    @MarkTurkenburg ,

     

    Here you go...

     

    In the Weekly SYS Time module, create a line item Weekly? formatted a boolean with the formula being TRUE.

     

    2020-06-22_14-42-21.png

     

    Do the same thing for Month (create a SYS Time - Month) module:

    2020-06-22_14-42-57.png

     

    Go back to SYS Week Time module and create the following line item (Week and Month):

    2020-06-22_14-44-32.png

     

    And then change the summary to Formula:

     

    2020-06-22_14-44-14.png

     

    For a Final result of:

     

    2020-06-22_14-47-21.png

     

    Hope this helps,

     

    Rob

Comments

  • rob_marshall
    rob_marshall

    @MarkTurkenburg ,

     

    For the parents, simply create new line items for half, and year and the formulas will be parent(of the below member).  For example, for

    Quarter=parent(item)

    Half=parent(quarter)

    Year = parent(Half)

     

    So now, if you are wanting to see the Half but the module is dimensionalized at the month level, you would just bring in the Half line item.

     

    Rob

     

     

  • MarkTurkenburg_*8288
    MarkTurkenburg_*8288

    Thanks @rob_marshall 

     

    I have those line items too but was surprised the ITEM formula didn't return the parent items in the list - I just tried it on General List and it errors if you use Formula as the Summary option so this must not be possible

     

    My end aim is to create a Line Item in the 'Time Filter (Weeks)' module where it is TRUE for all Weeks and all Parent Item Months but FALSE for Parent items Half-Year & Year

     

    My inital thought was to do:

     

    IF TimeMap (Months).ITEM <>  TimeMap (Half-Year).ITEM OR TimeMap (Months).ITEM   <> TimeMap (Year).ITEM 

     

    But this won't work due to not being able to return the Parent items with the ITEM formula

     

    Is there any other way to return 1 level of Parent as TRUE in the Summary but not others?

     

    Thanks

     

    Mark

     

  • MarkTurkenburg_*8288
    MarkTurkenburg_*8288

    Thanks @rob_marshall!

     

    I actually just finished the solution as the email notification popped up. I had the same solution as yourself but I created a Boolean in each of the Time Map modules for Time (Weeks) & Time (Months) & set both to TRUE with Summary as NONE

     

    Then the same Formulas as yours for the Time Filter (Weeks) module with a direct reference to both line items above joined by an OR with Summary as FORMULA

     

     

Categories