As a modelbuilder I would like to use FindItem with a property or line item

DEFLOTHE · 2023-08-29T08:58:25+00:00

There was an error rendering this rich post.

I have seen that I am not the only one facing the issue that there is property or lineitem which is neither a code or name of list but it is needed for identification, like a WHERE statement in SQL.

Might it be possible to extend the FINDITEM function by an optional parameter to reference a property or lineitem which has the list as dimension.

FINDITEM(List or Time, Item to find, [Property or Line Item to use for comparison])

We have different systems connected to Anaplan which have different codes e.g. for projects and I need this feature to identify them correctly without changing the code property on every import or creating help tables with cross mappings.

Comments

xin

Totatly agree. Similar to import where you can use property to identify an item instead of a code, as in a numbered list name does not work

Quick Links

New ideas

Administration Console: Keep Last login in Date format, on top of new format
It is great to know how old is the Last Login, but: 1.It would be great to keep the old Date format as well, to be able to make more easily some ad hoc analysis (older than X days, months etc…, as shown in example further below). The filter on new format is not possible and would not be meaningfull. 2.It would be great to…
Synchronized Scroll on Worksheet with an Expanded Grid Card
It would be incredibly helpful to have the ability to group the main worksheet grid with an expanded card for synchronized horizontal scrolling. Use Case: In my worksheet, I have the Time dimension on columns and a list on rows in the main grid. I also use an expanded grid card to show a different breakdown—still by Time,…
Line Item Spacing within a Text Box
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Option to adjust line spacing within a text box. Who is this impacting? (ex. model builders, solution architects, partners, admins,…