Append Function Break the existing calculated Dimensions

[Former Member]

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

[Henry_Banks · Accepted solution]

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

[Henry_Banks]

Yes indeed, this feedback has been communicated recently!

Please add your votes to Appending new data in Lumira Desktop is very limiting after calculations/hierarchies are created : V... and Auto update calculated dimensions/groups when appending data : View Idea

Regards,

H

[Former Member]

Hi Henry,

Thanks for your reply

For this one, I would treat it as an issue rather than enhancement

Anyway, I have voted to the Idea Place from the Link you sent

Best regards

Alex yang

[Henry_Banks]

Sure, if you want to make your case, please do contact the technical support via component BI-LUM-DSK on this website Report an Incident | SAP Support Portal

Regards

H

[AlexBW]

Alex, agree.

Definitely it's bug and should be fixed asap

voted.