Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Lexical parameter in Fusion BI Publisher Report ( SAAS)

Received Response
665
Views
1
Comments
KashifBaksh
KashifBaksh Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

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.

 

Regards

Tagged:

Answers