About MarkTurkenburg

Thanks @DavidSmith. I think the pertinent point there is 'don't over think it' 😂 As per usual I think I may of been getting too in the weeds but it's good to flush out the issue with the experts   Appreciate the assistance provided by yourself and everyone else on this thread   Mark ... View more

12k line items! @nathan_rudman  🤕   I was actually referring to how the model performs in general, e.g. how fast it is to move around, open modules etc rather than the initial opening          ... View more

Thanks @Misbah!   Funny but this session by @Griffink was exactly what I was referring to in my original post. I was in the audience for the session & remember being super impressed but it was also the 1st place I encountered the 'Waves' concept   I'll work through it 👍   Mark ... View more

Agreed with all of those @JaredDolich    I guess I'm trying to determine if all of those standard best practice items that you mention have the same impact of reducing calculation waves   I'm rambling too but just putting the thoughts out there 😁   Mark  ... View more

Thanks @JaredDolich    Yes it's an interesting one & I might be thinking too deeply about it but I remember during 2020 CPX there was a session on Best Practices & they spoke briefly about calculation waves and the effects on performance   I guess I am trying to increase my understanding of the Hyperblock/best practices to determine whether I should be materially focusing on Waves when building a model or if function/formula composition, avoiding text/using Booleans etc & dimensional consistency (referencing modules with the same dimensionality) is more impactful to performance   Thanks ... View more

Thanks @rob_marshall    Yes I can see that sometimes they may not be 100% ideal but it's not the end of the world to use them   Appreciate your help!   Mark ... View more

Nice @jasonblinn!   That's a pretty cool solution, I would not of thought of using a Subsidiary view to attain this result but I can see how it works   Thanks for the effort involved in creating this!   Mark ... View more

I think I'll have to but was whether it would cause any adverse consequences. I think there are 2 that can be mitigated:   1) Adds to module space but by turning off SUMMARY this can be reduced (not appropriate in all circumstances) 2) Incorrect formulas from a module without the dimension referencing a module with the dimension will return a value (SUMMARY). Previously an error would occur & this would help assist you in remembering you should not have a dimension mismatch when this List is included   Thanks!   Mark   ... View more

Thanks @jasonblinn  but I can't use the ANY function unfortunately, let me step out my issue a bit more clearly 😊     I have a module which is dimensionalised by 'Ramp-Up Month' which is the column dimension (1,2,3 etc). This dimension does not have a Top-Level as it is not required to be aggregated. The Line Item is an 'Override' Line Item & I need to produce a Filtered view of the module for any intersections whereby there is a value <> 0.    If I try to do a standard Filter straight out of the module I need to select which List items to use for the Filter & hence I cannot chose the Top Level for the Ramp-Up dimension   If I create a new SYS module without the Ramp-Up dimension I could use this for the Filter but I need to be able to return a TRUE for any intersection dimensions from the original module where ANY of the Ramp-Up items was <> 0. I can't use ANY here because I do not have the Ramp-Up list as a dimension     Thanks           ... View more

My bad I was reading the instructions incorrectly   It was just that simple!   Thanks     ... View more

    Hi @Harsha_D    Anapedia states the syntax is (cell containing text, text to find, starting point) which is what I did.    Is Anapedia incorrect?   Thanks       ... View more

Awesome - thanks @anikdas !   Mark ... View more

Good idea @jasonblinn - thanks! ... View more

Good idea @NakulAggarwal  in increasing the 2nd Column size rather than the 1st - nice simple solution ... View more

Hi @einas.ibrahim    I meant "down the bottom" of my screen shot - I had " " & was copying the space between the 2 quotes   But it doesn't work for me. I copy the character but when I paste there is no invisible character that is pasted ... View more

Of course - yes Black Magic!   It makes sense but I can't get it to work @einas.ibrahim    I have copied the space between the 2 quotes down the bottom but when I paste into the sentences above there is no space added   Is this the same process you use?   Thanks   Mark     ... View more

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     ... View more

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   ... View more

That would work perfectly @Misbah but unfortunately I have other modules dimensionalised by Time that sit above this module & I need them to line up too so I cannot swap the 2 modules around   Good to know it is simpler in the NUX - time I moved across   Mark ... View more

Yes @einas.ibrahim!   That's exactly what I'm after - how did you do that?   Thanks   Mark ... View more

Hi @Misbah    Yes the label is disabled so there is no text/labels at the top of the module. I have wrapped the text but I need to increase the size of the label to 18 before it lines up with the other module. Not ideal because there is a little but of text still showing   Maybe this is easier on the new UX? I haven't moved across yet   Thanks!   Mark ... View more