You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Lexical parameter in Fusion BI Publisher Report ( SAAS)

Received Response
38
Views
1
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 1 comment

Summary

Lexical parameter in Fusion BI Publisher Report ( SAAS)

Content

We want to create a report using Dynamic table name.

 

We had followed the Oracle provided document mentioned in the link below:

 

https://docs.oracle.com/middleware/12212/bip/BIPDM/GUID-F9F844BA-5831-46E5-B085-44D82258A9A9.htm#BIPDM482

 

Using the lexical references we could pass the dynamic SQL, but in SAAS we may not able to create packages where lexical reference needs to be defined.

 

What other possible options are there to create a query where we can pass the table name dynamically.

 

Any document or information would be of great help with respect to the same.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!