Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
How to correctly write a BIP query in the OAC environment
Summary:
Obtain the value list of launch parameters in a BIP report on the OAC environment
Content (please ensure you mask any confidential information):
Hi
when I write the standard sql code on OAC (as well as on OTBI) I get the expected results but I cannot get the values returned by the selected launch parameters, so the report becomes useless without them.
I have tried using an alternative syntax (Adding Parameters to a Data Model in Oracle Business Intelligence Publisher) that allows me to get the results of the launch parameters, but the query stops working when it starts getting more complicated and I can't figure out why.
Tagged:
0