Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Append Function Break the existing calculated Dimensions

Dear Experts,

I have faced one strange situation in 1.21 and not sure whether you see same issue in your side

I have data file structure like below

Country GSV

CN        1000

AU        100000

Then I create one calculated dimension called Region

The logic is, if country value  is NOT Equal to AU, then value is SA, else is NA

Then the result structure in Lumria is like below

Country GSV      Region (Calculated Dimension)

CN        1000      NA

AU        100000   SA

Then I append another file with same original structure as below

Country GSV

KR        5000

so the value in Lumira becomes like this

Country GSV      Region (Calculated Dimension)

CN        1000      NA

AU        100000   SA

KR        5000

At this time, I treat this is due to the formula cannot be recognized then I go to formula and click Edit and click ok

Result is still as below

Country GSV      Region (Calculated Dimension)

CN        1000      NA

AU        100000   SA

KR        5000

Finally, I tried to click Refresh button and result is still no change

Country GSV      Region (Calculated Dimension)

CN        1000      NA

AU        100000   SA

KR        5000

Please let me know your comment on this

Best regards

Alex yang

Former Member
replied

Hi,

this definitely could be improved !!!

Firstly,  I tried by defining an empty column 'Region' in the Append dataset, this made no difference

if {Country} <> "AU" then "SA" else "NA"

Secondly, i tried "Appending" the KR dataset, then adding the 'Region' if-then-else logic - this made no difference to target dataset.

To conclude -  the only way you can do this, is to : "acquire" the 2nd dataset (don't Append/Merge yet..) then duplicate your logic in 2nd dataset.   Then Append into 1.

regards,
H

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question