We have an issue where our TI process is not recognising a new alias that has been added earlier in the same load process.   We have created a TI process that on loading the data we check if the element exists in the dimension using the alias name from the source data.  The source data will only hold the alias name.  If the alias is not found in the dimension, we add a new base element, a sequential number, and add the new alias.  However, if the same alias appears later in the source data the TI process checks for the alias and does not find it and therefore will wrongly create a new base element sequential number.

Is there a technique that will resolve this issue?

Thanks in advance for any help

------------------------------
Paul Brann
------------------------------

#PlanningAnalyticswithWatson

Hi,

Are you creating the new elements in the metadata tab and then adding the alias values in the data tab?

Without knowing the specifics, a work around might be to do this in multiple passes.  Have the first pass create an entry in a temporary dimension with the new alias names being added as the primary key, and the sequence as an attribute.   Then have another process that reads the temporary dimension and creates the required dimension element and alias and then deletes it from the temporary dimension.

------------------------------
Scott Brown
------------------------------

Original Message:
Sent: Mon January 06, 2020 04:43 AM
From: Paul Brann
Subject: TI process - Issue using alias to test if an element already exsists

We have an issue where our TI process is not recognising a new alias that has been added earlier in the same load process.   We have created a TI process that on loading the data we check if the element exists in the dimension using the alias name from the source data.  The source data will only hold the alias name.  If the alias is not found in the dimension, we add a new base element, a sequential number, and add the new alias.  However, if the same alias appears later in the source data the TI process checks for the alias and does not find it and therefore will wrongly create a new base element sequential number.

Is there a technique that will resolve this issue?

Thanks in advance for any help

------------------------------
Paul Brann
------------------------------

#PlanningAnalyticswithWatson