Hi experts, How to do data tiering on SAP BW 753 SP02 on HANA ? Or other method which can store data in third-part location that can be read from BW query.
I cannot provide official/secured information... but maybe you can investigate yourself into the direction if Sybase IQ is also useful for data tiering in an embedded BW.
For regular BW on or 4/HANA it is clear... but for S4, I don't know.
create a open ods view / virtual provider that connect to the third party tool. Thai will be cold data. Create a composite provider that combines the cold data from the ods view and the hot data from current dso.
the Bw quey should automatically control the execution plan and fetch the required data from hot/cold datasets depending on what you are trying to fetch.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.