It’s possible the BCA fills prompts?

[system]

I have BO 6.1.a

I need the process automatically at night fill prompts: Start and End date (I have this information in a table) and refresh the reports.
It’s possible the BCA fills prompts?

I think in BCA 5 it’s not possible. Can you confirm it?

Thanks!

---

mg (BOB member since 2004-01-07)

[system]

MG:
Please, do not cross post/double post the same question as it is against BOB’s rule #12:

Cross-posting the same message on multiple forums is not allowed. Our forum structure is fairly simple. If you aren’t sure where to post your question, simply put it in the most likely spot. A moderator may move or even split your topic if deemed appropriate.

A moderator can always move or split a topic if necessary. Thank you.

---

Andreas (BOB member since 2002-06-20)

[system]

I 'm sorry Andreas but is not the same question.

I need to know if it is possible to make with BCA (I ask it in BCA forum), but I can’t make it with BCA because we don’t have the BCA (I only want to know if it’s possible to do with BCA), so I put the question in Web Intelligence how can I do it without BCA.
I believe I don’t put “without BCA” in the Web Intelligence question…

Excuse me and thanks very much!

---

mg (BOB member since 2004-01-07)

[system]

Mg,

I think you have to fill the prompt yourself by creating the right SQL without prompts or intelligent prompts 8) . When we have a report with prompt which is used by users as well as BCA we create double prompts like " = Decode(@prompt(“startdate or 0 for sysdate”), 0, Trunc(sysdate), @prompt(“startdate or 0 for sysdate”))". Users just fill in the date they want, and when it is sent to the BCA you fill in 0.

HenkK

---

HenkK (BOB member since 2004-03-02)

[system]

I think you need to forget about prompts. They are fine for users but don’t make sense in terms of BCA. So what you do is create one or more pre-defined conditions in your universe and replace the prompts in the report with these conditions. I’m guessing from what you have written that your current prompts ensure the user only looks at information between the start date and the end date. So your pre-defined condition might be called something like ‘Current Period’ and the SQL in that condition will be a simple

date between start_date and end_date

---

Nick Daniels (BOB member since 2002-08-15)