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

Dont want to pass prompt values across action links

Received Response
54
Views
9
Comments
user12863665
user12863665 Rank 6 - Analytics Lead
edited Aug 13, 2024 7:06PM in Oracle Analytics Cloud and Server

Hi, i am using action links(navigation to webpage) to navigate from one page to other page in same dashboard.by default first report prompt values are passing to target report when i click on the action link.But i don't want to pass all prompt values in first report to second report(Want to pass only specific columns). Anyone suggest me how can i achieve this?

Answers

  • Apoorv
    Apoorv Rank 1 - Community Starter

    In the second report (Target Report), In the filter conditions set the 'Is Prompted' only to the specific column values which you want to pass

  • user12863665
    user12863665 Rank 6 - Analytics Lead

    Thanks for your response.

    my issue is I should have the same columns in both prompts And users should have ability to pass values from prompts.

    i Just want to keep something like default value for target report prompts.

    BAsically this issue came because of based on the other filter this report not returning any data for the values we are passing from other report.

    please suggest me how can I fix this?

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Are your individual prompts set to Page level scope?

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    If you dont want to pass all parameters, you should put it out the prompt in your targert reports.

    Kind Regards,

  • user12863665
    user12863665 Rank 6 - Analytics Lead

    I Have both detail and summary reports in one dashboard.

    both pages have separate prompts and reports and set prompts scope to page.

    both prompts in summary and detail report has same columns. I navigate from summary report to detail report only with navigation Links.

    IN this case all column values in summary prompt are passing to detail prompt.

    But my requirement is I need same prompts in both summary and detail reports. But I don't want to pass one column value from summary to detail.instead I need to pass default value in detail prompt for detail report.

  • Joel
    Joel Rank 8 - Analytics Strategist

    Hi @user12863665

    A workaround would be to "trick" OBIEE into thinking that the colum is different in the detail report by appending a space to the end of the column for example. You'll need to do this in both the column and its prompt on the detailed report.

  • user12863665
    user12863665 Rank 6 - Analytics Lead

    TThank you so much for your response.

    I Just realized that all columns using in prompts are hierarchical columns.can you suggest me the work around?

    SOrry for the confusion.

  • 1034244
    1034244 Rank 1 - Community Starter

    Hi,

    If you don't want to pass the prompt means do this step.

    *) Open the report where you don't want to prompt.

    *) Open the column --> edit formula and change the datatype. ex. If it is a varchar then CAST(columnname AS CHAR) or if it's a number the CAST(columnname as INT)

    Try to change the datatype size.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Long thread short if you want to start being picky about what gets passed across and what not then you're best off just using Go ORLs with parameter:

    http://docs.oracle.com/middleware/1221/biee/BIEIT/apiwebintegrate.htm#BIEIT365

    OBIEE 10G/11G - Passing Filters through the Go and Dashboard URL [Gerardnico]