To prompt while refresh and not to prompt for DAS

scheduling Broadcast Agent (BCA)
1

Hi,

Would appreciate a solution to the following.

What expression or logic to use for creating a BO report where : 1> I will be prompted for say, a date, when I refresh it 2> and this same report when I submit to DAS, a subquery will compute the date without being prompted.

I am using Oracle 7.3.4 as backend and BO 4.1.5.

Thanks much in advance.
Regards,

Unni
E-mail : K.Unnikrishnan.Nair@ercgroup.com

Listserv Archives (BOB member since 2002-06-25)

2

Unni,

What do you mean by Sub-query? Can it be represented by BO?

I think what you need is, create a query with a prompt which will throw prompt screen while refreshing the report from BusinessObjects and create a script and attach it with the DAS job which will set the date value for the prompt variable.

  • Vasan

Listserv Archives (BOB member since 2002-06-25)

3

What you could do is to put the query for the date into the report itself, and use that result/date in your report as a variable. Simon

Listserv Archives (BOB member since 2002-06-25)

4

Do you have a Script that does this. IF so can you please mail it.

Thanks
Pavan

Listserv Archives (BOB member since 2002-06-25)

5

im really sorry pavan. i didn’t check list serv for many days.

it’s very simple:

Application.Variables(“Enter Start
Date:”) = “24-Jan-1999”

Try the above line to populate prompt, whicch has text “Enter Start
Date:”

if u r using BO4.x, parameters will be passed as string only. in bo5 u can also set the type of the parameter.

let me know if u need detailed help

vasan

Listserv Archives (BOB member since 2002-06-25)