Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

How to get URL which consist parameters(dashboard prompts) used in the DV workbook

Accepted answer
51
Views
3
Comments
AmarP
AmarP Rank 2 - Community Beginner
edited Apr 8, 2025 3:31PM in Oracle Analytics Forum

Hi,

We need to generate a URL which consist the parameter available in the workbook when we share the URL. Requirement is to get similar URL which we get from BIP Report where parameters are configured. Expectation is to configure these Workbook URL under APEX application so users can only access data as per their access . We are trying these functionality under OAC Embedded in FDIP

Any suggestions would be helpful.

Best Answers

  • SteveF-Oracle
    SteveF-Oracle Mod
    edited Apr 8, 2025 5:29PM Answer ✓

    Hi @AmarP ,

    Welcome to the Oracle Analytics community!

    Can you check if this prior post helps with your question

    https://community.oracle.com/products/oracleanalytics/discussion/25133/oracle-data-visualizer-analysis-not-recognizing-parameter-in-url?utm_source=community-search&utm_medium=organic-search&utm_term=URL+parameters

    There is also a tutorial here, if you are looking for a "how to"

    https://docs.oracle.com/cd//E83857_01/paas/analytics-cloud/tutorial-pass-param-values/index.html

    Thanks for your question, other comments always welcomed.

  • SteveF-Oracle
    SteveF-Oracle Mod
    edited Apr 9, 2025 7:49PM Answer ✓

    Hi Amar,

    You can pass parameters when embedding content.

    Pass Parameters to the HTML Page for Embedded Oracle Analytics Content

    This Oracle blog on the topic may be more of what you are looking for.
    A Guide to Embedding Oracle Analytics into Oracle APEX

    https://medium.com/oracledevs/a-guide-to-embedding-oracle-analytics-into-oracle-application-express-apex-1799f6ba4626

    Specific sections:
    Embed a URL link to Oracle Analytics workbook and Passing Parameters on a Workbook URL

    Hope that helps.

Answers

  • AmarP
    AmarP Rank 2 - Community Beginner

    Hi @SteveF-Oracle,

    Thanks for the response, this helped!
    Can we pass a variable to parameter. Our requirement is that these workbooks would be accessed from APEX application so when the user logs into the APEX instance, data level filters should be applied to Workbook for which user is trying to access it.

    As of now I tried appending the parameter name and no parameter values by using syntax of
    &p1n=ParamterName1&p1v=&p2n=ParameterName2&p2v=
    With such configuration Workbook is working as if it is being accessed using normal URL without parameter