Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

SAP HANA DirectQuery SQL code

Hi all,   I am facing the following issue when trying to connect an existent query from SAP to PBI through the DirectQuery feature.       The code I am using is:   SELECT T0."itemcode",...
  • Anonymous's avatar
    Anonymous
    5 years ago

    Anonymous 
    Is "oitm" a variable or a temporary table? If "oitm" is just a variable, you have to write ":oitm" (with the colon in front).

    SAP HANA will determine if and what needs to be materialized during run time.

     

    Paul Zheng _ Community Support Team
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.