Skip to Content
0

Hana View not Refreshing in IDT

Mar 06, 2017 at 07:47 PM

51

avatar image

Hello All,

I have added a new calculated Column in my Hana model, but after successfully added the column, it show in data preview. Now when I open the universe it is referred, the universe is not refreshing the structure of the underlying Hana view. If I open the universe connection and drill thru to the view I am referencing, it has the column I have added. But not refreshing the structure.

I tried to refresh the struture still nothing is happening,

The BOBJ-IDT was built on a Derived Table, for me to add the column the underlying table need to show the column what I am adding.

if anybody is aware of the same issue or solution , please let me know.

Thank you,

Arthur.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

AMIT KUMAR
Mar 06, 2017 at 08:01 PM
0

are you able to see the new column in the table? Not in derived table..

If yes then what is the sql of your derived table.

It's like select table.col1,table.col2 from table (if this type of sql then you have to add column manually)

Or

Select * from table (if this type of sql then object will be added automatically)

Share
10 |10000 characters needed characters left characters exceeded
ARTHUR ALEXIS Mar 06, 2017 at 09:16 PM
0

Amit,

Yes I am able to see the column if I drill thru the connection, but the new column is not even showing the Table "_SYS_BIC"."HANA_MODEL"

(Where we create the Derived table with SELECT).

To add a Column in the SELECT statement it should exist in the underlying table though... that is what is missing)

But though it is not showing the newly added column I went ahead and type the column name and the SELECT statement validated fine. Something did not get refreshed and I am not sure...

Thank you,

Arthur.

Share
10 |10000 characters needed characters left characters exceeded
ARTHUR ALEXIS Mar 06, 2017 at 09:17 PM
0

Amit,

Thank you for looking at it, and I close it now.

Arthur.

Share
10 |10000 characters needed characters left characters exceeded