Hi @DavidSmith, FYI, This post presents a very interesting perspective of the HyperBlock behavior. It would be great to understand the reason behind these numbers.
... View more
Hi @simon_ritchie , Thanks for looking into this! Yes, New UX is on its way to fix this problem, as for a single structure model we might have different apps per market (that's how I see it). We're not there yet, though... We are missing couple of key functionalities in the new UX (ie. Assign) to allow us to even consider a move to new UX.
... View more
Hi @DavidSmith, Great Article! Aren't these results affected by CODE & _ & CODE being executed also with extra month dimension? or was it run with extra subset on the line item without months? It's hard to believe that optimized formula with CompanyCode & _ & ProductCode is running 6x longer than CompanyCode_ & ProductCode. Does it mean that CompanyCode & _ & _ & ProductCode would run 12x longer? It is very unclear when this inefficiency is coming from as concatenation is being done anyway and "_" is a constant, so no calculation should be required. Some extra explanation would be appreciated, but still - this is a fantastic article - please do more of these :).
... View more
Hi, It kind of depends if itemcode is numeric list or not. if yes, you can use RIGHT(itemcode.DisplayName, 3) if no, you can use RIGHT(NAME(itemcode,3)) or RIGHT(NAME(ITEM(itemcode)),3) <- if it is in module dimension I hope that helps! 🙂
... View more
