Check this http://docs.oracle.com/cd/E23943_01/bi.1111/e22254/create_rtf_tmpl.htm#BIPRD3265

I got your question but I was not sure about your ability to create Prompt You are going to use 2 dates Open and Closed in the Prompt and set Presentation variables. In the report for that 1 date column use <= and >= instead of Between operator.

Check this OBIEE - Date Format in presentation variable, dashboard prompt and logical SQL [Gerardnico]

create min(date),max(date) fields in the rpd and set content level for Month level or try start->TIMESTAMPADD(SQL_TSI_DAY,1,min("Time"."Date" by "Time"."Month Name")) last->TIMESTAMPADD(SQL_TSI_DAY,1,max("Time"."Date" by "Time"."Month Name")) in report.

Check BI Apps configuration for those specific modules.

See how that works with Cloning!

make sure you can open the rpd with given password. Note: RPD versions change with releases of OBIEE: 349 = 11.1.1.9.0 326 = 11.1.1.7.1 325 = 11.1.1.7.0 318 = 11.1.1.6 308 = 11.1.1.5 Check your version and try once

Check this doc https://docs.oracle.com/cd/E23943_01/bi.1111/e16364/apiwebintegrate.htm#BIEIT357

Make sure that the query is correct and fetches some data using toad etc.

I would suggest to go with SQL expression using Convert this filter to SQL and there you write "YourColumnName" LIKE 'p_org%' or "YourColumnName" LIKE '@{PSvar}%'

Are you still looking for solution? let me know based on that I can help you.

if I understand your question correctly; I would say you might be doing it wrong way, we can pass value to another report using action links as long as column is prompted in target report or else you may use presentation variables for the same.

Use Column properties->Interaction tab, then at Value select Action Link and give the target report name

I mean DAC parent folder. individual file or parent folder level is good. In general connection file stored something like the below all depends on the version you use. \orahome\10gR3_1\bifoundation\dac\conf\connections

You may change the folder permission on orahome to specified user or any user

Explore options with Action links or Master detail report

Wow thats nice.

Cool. mark as correct and close this post

is your query correct? for instance p_org_id is null then what value query should take from org_id? example, org_id IN Nvl(NULL, org_id) !!!!

It would be nice to have a column for LASTUPDDTTM