Skip to Content
0

HANA SPS12 - Alter Virtual table definition

May 08, 2017 at 09:54 AM

564

avatar image
Former Member

Hi,

we are using HANA SPS12 and our requirement is to refresh our virtual table definition (via SDA) to pull in the new fields created in source system (SQL Server) but the command ALTER VIRTUAL <table> REFRESH DEFINITION is not working. So I request you to pitchin with your ideas.

P.S: I don't prefer to delete the table and re-create it as there are multiple views built on top of these virtual tables.

Thanks & Regards

DD

SAP HANA remote data sync
SAP HANA smart data integration
Answers Answers and Comments
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
avatar image
Former Member Answered May 21, 2017 at 01:40 PM
1

Hi DD,

We had exactly same problem and SAP responded that this command is only available from HANA 2.0. Sorry for bad news!

They provided me with following workaround:

1. Add the column you need to the source table

2. Create a new virtual table based on this source table

3. Follow the Steps "Replace a Data Source in Calculation Views" to modify your Calculation View.

https://help.sap.com/http.svc/rc/fb8f7a9f7860468b84a07eab0a7d0a98/2.0.01/en-US/SAP_HANA_Modeling_Guide_for_SAP_HANA_Studio_en.pdf

Show 1 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Former Member
Oct 11, 2017 at 12:53 PM

Thank you for your brilliant post Dorothy! This is exactly what I'm after and yes it is indeed bad news! :) Bring on HANA 2.0!

L

0
Comment