Concatenation in SAC data actions

[edwardh]

We have the need to concatenate two dimension IDs in a data action to form a new ID for another dimension. One of the original IDs is populated from an attribute of another dimension and does not come in with the data so we cant do this at the time of modelling.

e.g.

Plant: 1

Product: A (gets populated by a previous data action)

Plant\Product: 1A (or 1-A if we can use a delimiter)

Can this be done? if not, when will it be added?

Ed

[N1kh1l · Accepted solution]

edwardh

I do not think this will be currently possible. You requirement requires SAC to support string manipulation functions like CONCAT or &&. Once this is supported it should boil down to some syntax like below

DATA([d/dim]=[d/PLANT].[p/ID] && [d/PRODUCT].[p/ID])=RESULTLOOKUP()

DATA([d/dim]=CONCAT([d/PLANT].[p/ID] , [d/PRODUCT].[p/ID]))=RESULTLOOKUP()

There is already an influence request for this feature which you should upvote

need to have CONCAT() function in Data action advanced formula

Hope this helps !!

Br.

Nikhil

[PRAT280]

Hi,

We cannot use data action to generate a "new id" ( master data) for a dimension. You have to first create the master data and then use the advance formula script. Advance formula's are targeted to manipulate the fact data

Thanks