nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Dont want to pass prompt values across action links

user12863665

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?

Find more posts tagged with

Accepted answers

All comments

Apoorv

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

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

Are your individual prompts set to Page level scope?

cesar.advincula.o

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

Kind Regards,

user12863665

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 Acha

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

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

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]

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]