Skip to main content

I have a rather large transaction list (roughly 5M rows) with several dimensions.  I need to map the combination of these unique dimensions to assign my data into user managed groupings.  To do that, I need to do a 2 part calculation by first concatenated the various dimensions and then matching it to the grouped dimension.

MATCH(

'_ Subscriber Activity'.'Account Type'.Name &"-"& '_ Subscriber Activity'.'Product Group'.Name &"-"& '_ Subscriber Activity'.'Product Subscribe Group'.Name &"-"& '_ Subscriber Activity'.'Device Sub Cohort'.Name &"-"& '_ Subscriber Activity'.'Device Type Cohort'.Name &"-"& '_ Subscriber Activity'.'Marketplace Cohort'.Name &"-"& '_ Subscriber Activity'.'Customer Subscribe Category'.Name,

'_ Product Attributes'.Name)

 

The problem is that I get an error that is: “Product Attributes: Formula timed out (> 3 minutes)”.  I’m not sure how to work around this error with a more optimized approach.  Any help will be much appreciated.

Kevin

Hi, from the look of it, the formula may be very taxing on processing as it combines multi concatenations + matching in one go

I would try to split the formula in 2 with one part doing the concats and the second one calling the first and doing only the matching and see where it gets you from there.

As a general piece of advice in financial modelling, it s best to separate concerns into dedicated line items (or whatever is called in the tool you are using) rather than long multipurposes formulas

 

Thank you for the reply.  I’m not sure I totally understand what you mean by splitting up the formula in 2.  Is this something where you would create a property that just does the concatenation and then another property that does the match?  So one field would be a text and the other a dimension?  Or is there another way to split up the formula in just one property.  Any additional insight would be appreciated.

Ask your question here!

Terms & ConditionsCookie settingsAccessibility statement