Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Compare Aliasname with a Textcell for a large memberrange - [[PlanningFunctions.getIdForString — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Compare Aliasname with a Textcell for a large memberrange - [[PlanningFunctions.getIdForString

Received Response
22
Views
1
Comments
edited Oct 10, 2022 7:11PM in Planning 1 comment

Summary:

to perform a selective datatransfer (@Xref logic) from source to target cube (where the location information is in a textcell in the source cube compared to members/aliases in a dedicated dimension in the target cube, we need to compare the textvalue of an account (Location_ID) with the Aliasname of the members in the Location dimension.

[[PlanningFunctions.getIdForString("Aliasname")]] worked good in other situations in this application, when we could hard-code a few cases in an if elseif statement. E.g. IF("Location_ID"==[[PlanningFunctions.getIdForString("FRA")]] )

However now I need to check for approx. 700 Locations - any help on the proper syntax or a completely different approach would be helpful. The system and interfaces are more or less finalized after several months of development, so replacing/adding dimensions, renaming all members/aliases, creating a datamanagement interfaces with mapping tables or adding additional SmartLists or UDAs for each member are probably only the last option, as these locations keep changing.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!