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.
3 Answers
-
Posted on Mar 06, 2017 at 08:01 PM
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)
Add comment
-
Former MemberPosted on Mar 06, 2017 at 09:16 PMAmit,
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.
Add comment
Add comment