I would like to check if it is possible to configure the datastore in SAP Business Object Designer such that the tables will reside in the extended storage/dynamic tiering in SAP HANA instead of the default in-memory destination.
I'm not particularly familiar with BOBJ Designer. I did take a short look a that BOBJ Universe Design Tool user guide. Is that the same tool or should I be looking at something else?
A couple of questions that I have for you:
1) Are you creating tables through Designer or all those already created?
2) Are you inserting/updating/deleting data through Designer or are you just selecting existing data?
3) If you are creating tables through Designer, do you have the ability to customize the CREATE TABLE... SQL statement that is generated?