Hello All ,
I would like to know what is the best approach to follow if you have to pull HANA views into BW when your database is not HANA. The virtual provider is the option to go for if your BW system is on HANA database. In my case, since the database is SQL, when I attempt to create the virtual provider, I do not see the option "Based on HANA model".
We are on BW 7.4 and our company is migrating to HANA database sometime next year. So, need to figure out what is the best alternative solution to extract data from HANA views into BW.
I have to load HANA view data into the virtual cube of BW and slip it in a multiprovider.
Thanks