Skip to Content
Jan 15, 2021 at 03:11 PM

Temporary Table not supporting in SAP BO 4.2 Data Federation multisource query


as we know I,T,P are strategies available for Data Federation engine - when i do "Explain Query" in Query Panel, it shows "Supports Temporary Tables" in red color under "Capabilities -> Miscellaneous"

this is for Oracle 12c connection (tested with both Oracle client & ODBC)

as a result, the queries only show "I,P" in expected plan

is there anyway to enable this option ?