Forum Discussion

ozmike's avatar
ozmike
Resolver I
9 years ago
Solved

Formula Firewall ..?

  Hi have a query an get this error ..       Formula.Firewall: Query 'CallListquery' (step 'Source') references other queries or steps, so it may not directly access a data source. Please rebuil...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    The cause of the error message is that you use data from another table (in your KEYListFunction) to access data in your Saphana database. Such a combination may violate privacy level settings.

     

    Probably the only way to solve this issue is to adjust your privacy level settings:

    go to File - Options and Settings - Options - Privacy (almost at the bottom) and check

    "Ignore the Privacy Levels and potentially improve performance".

    On that screen you can also find a link to more information on privacy levels, which brings you here.

     

GilbertQ's avatar
GilbertQ
Super User
9 years ago

Hi ozmike

 

Possibly try this

 

let
xx =   KEYListfunction(),
sel = "select * from ""XXX.xx::XXX""  where ""column"" IN  ("  & #"xx" & ")  ",
Source = SapHana.Database("XXX:12345", [Query=sel])
in
Source

If the above works, when you define a parameter or as in your example the (xx) when then using it within the Query Editor it has to have the HASH DOUBLE QUOTE PARAMETER NAME DOUBLE QUOTE - #"PARAMETER"