Concentrating two dimensions elements together to form a unique identifier
Posted: Fri Mar 01, 2024 5:37 pm
Hi,
I was wondering if it is possible to design a TI Process to take two dimensions elements and concatenate them together to form a unique identifier in a new dimension that i could setup as a chore? Ideally i would like to do this using incremental loads, rather than clearing out the new UID dimensions elements as a mapping cube will be built off the back of my new dimension. Both dimensions have differing number of elements and would create a UID for every possible dimension element combination.
Additionally, i am also wondering if there is a PAX formula available that would enable me to pull down a elements name (or alias) based on it's top level hierarchal parent or an attribute or both! I'm currently using SUBSN and DIMNM but both aren't quite what i'm after.
Any assistance would be greatly appreciated!
Thanks in advance,
Kane
I was wondering if it is possible to design a TI Process to take two dimensions elements and concatenate them together to form a unique identifier in a new dimension that i could setup as a chore? Ideally i would like to do this using incremental loads, rather than clearing out the new UID dimensions elements as a mapping cube will be built off the back of my new dimension. Both dimensions have differing number of elements and would create a UID for every possible dimension element combination.
Additionally, i am also wondering if there is a PAX formula available that would enable me to pull down a elements name (or alias) based on it's top level hierarchal parent or an attribute or both! I'm currently using SUBSN and DIMNM but both aren't quite what i'm after.
Any assistance would be greatly appreciated!
Thanks in advance,
Kane