Overriding Prompts in Business Objects 2

[businessobjects]

I have a set of reports built using some predefined and simple conditions. There are prompts in the predefined
as well as in the simple conditions.Now, I am having problems in scheduling the reports as these prompts pops up during scheduling.These process has to be silent, without any user intervention.Is there any way to override the prompt and instruct BO to read the prompt values from... may be a parameter file/a text file containing the values for the parameters appearing in a prompt?

 

[ATP]

When ever I've scheduled a report to BCA or DAS it has asked for the prompts before it's scheduled and then it uses the prompts I entered when it runs.

Anyway, I run a report using the BCA which reads a file for a supplier id, alters the query, runs the report and saves it as html. This is done using VBA.

Have a look at thread393-88021 : VBA in BOB this has a v4 script example. (v5 does convert this into VBA with no problems)

Hope this is of some help.

ATP.

 

[bensonpa]

Occasionally BCA picks up ghost prompts where may have been used in earlier versions of the reports, When sending to BCA your prompted for answers to A, B and C but when the document is processed on the server it comes up with A, B, C and D. I have found I can cure this by first purging all the data providers of their data before resubmitting the report.

 

[mustang7]

Hello, Here is how you do it:
1) Put "Application.Interactive = false" before the prompts and just right after each prompt, put Application.Variables("variablename&quot.Value = "........" the value you need to pass onto. Make sure the Value is a String.
2) You can pass a value to a prompt by reading from a textfile. In Visual Basic and in VBA, you can read line after line from an external textfile by using LineInput. I don't have the code handy, but I will search for it.

Please remind me.