Unable to adjust the length of the column of HANA View

[former_member647661]

Hi Experts,

I am unable to adjust the length of the column of HANA View.

Scenario: I have used a HANA View into my BW Info Object. Then this Info Object is used all across other objects. Finally I build a Input enabled BEx Query on Aggregation Level. But when I am trying to save the data from Analysis Template, it is resulting into uncaught exception. I searched for this issue & found the reason: "Different length between infoobject and column of SAP HANA view". SAP Note: 2589744.

The solution recommended in that SAP Note is : "Adjust the length in the infoobject or the column of SAP HANA View."

But I am unable to adjust the length the column of a HANA view.

can someone please help me in this scenario.

Thank You,

Mukesh Kumar

[Geetha_Madhuri_Bobbili]

Hi,

• For column table, only increasing the size of a column data type is allowed to prevent data loss. For example, changing from NVARCHAR(20) to NVARCHAR(10) or from integer to tinyint will raise an error.
• For row table, only increasing the size of VARCHAR and NVARCHAR type column is allowed. Other data type changes are not allowed.

Regards,

Geetha.