Skip to Content
0
Jul 03, 2020 at 06:09 PM

Merge with calculated dimension

38 Views

Hi,

I am trying to merge two tables with slightly different dimension values.

Table 1 Project ID Project Name 1234 Project1 5678 Project2 1122 Project3 5566 Project4 Table 2 Project ID Project Type 1234_D1 New 5678 Old 1122_D2 New 5566 New

Table 2 Project_ID has underscore in it and the result of the merge doesn't work properly.

I created another dimension:

Project_ID_2 =If(Pos([Project_ID];"_")>0;Left([Project_ID];Length([Project_ID])-3);[Project_ID])

But how can i merge Table 1 with Project_ID_2? is there another way to solve this?

Note: I'm using SAP WEBI BO