SAP IDT Business Layer Refresh

building semantic layer
,
1

Hi,

I am using SAP Webi 4.2 version
I have added few columns in my database , so I refreshed the data foundation layer and saved it . I am able to see the newly added columns in data foundation layer , but I am unable to see those columns in business layer
I have got solutions regarding the insert candidate objects , but I am not able to find that option

Can somebody help me find the solution?

Thanks,
Smita Kate

2

Hi,

After refreshing the data foundation layer, save it, and if you’ve multiple data foundation layers in that project, make sure you’re using the correct data foundation, and hopefully you’ll find the columns in the table while searching from the business layer.

Thanks,
Mohammed

3

Thanks Mohammed, I did try your solution but it is not working for me.
Can you or anybody suggest me any other solution?

4

Is the data type long text or CLOB? You may have to change the data type in order for the business layer to see the column. I am a big believer in derived tables. Mostly because you can convert or cast offending data types easily.

5

Hi,
I have modified my my derived query to add a new column and saved it . I am able to see the newly added column in data foundation layer , but I am unable to see those columns in business layer.
Can somebody help me …