LOOKUP towards a line item that has less dimensions

0 Kudos

LOOKUP towards a line item that has less dimensions

Please add an option to use LOOKUP function towards a line item that has less dimensions. For example: I have a line item that has three dimensions:

  • Client
  • SKU
  • Month

I try to get some masterdata from Region, Month level that doesn't have SKU dimension. When I try to use [LOOKUP: Client.Region] towards this line item it works fine. But only until this is the only aggregation function within the formula. If I add a single SUM, the LOOKUP part starts returning an error.

I've had a discussion with Anaplan support team and they always refer to the Anapedia article that says the following:

The dimensions of the mappings must be dimensions of the result line item

The problem is that this constraint doesn't apply all the time. Mostly the formulas do work fine.

The content in this article has not been evaluated for all Anaplan implementations and may not be recommended for your specific situation.
Please consult your internal administrators prior to applying any of the ideas or steps in this article.
1 Comment
Community Manager
Status changed to: Needs Community Support