Here is my problem:
We have many reports(BO FC & webi) with prompt, this prompt is a date.
Users want to see all report refreshed at current date(today).
How can I achive this?
Problems:
VBA is only for BO FC.
BCA: input today date every time I schedule? It is not fair!
We have many reports(BO FC & webi) with prompt, this prompt is a date.
Users want to see all report refreshed at current date(today).
What do you mean by 'users want to see all reports refreshed at current date(today). Do they want the end date to be today and they can change begin date?
So, they want a refresh on open for current data, then re-run the report for a specific timeframe?
If that is what they want, I can only suggest creating a prompt for them to ADD to the report after the refresh on opne or figure out some way for BO to use current as a default if the prompt os left blank. I have not done that !!!
Look for S. Krandel’s presentation from the Business Objects user conference 2003, titled: “Empowering End Users Through Smart Universe Design” (available from Business Objects Techsupport, requires maintenance contract).
There is a section about intelligent calendars in his presentation that might give you some good ideas.
I could swear I posted this before in this topic, but…
Another option:
Use a predefined condition that holds an OR statement.
(<date obj>=@prompt('Enter Date','D',,MONO, FREE) and @variable('BOUSER')<>'BCASUBMITTER') OR
(<date obj>=sysdate and @variable('BOUSER') = 'BCASUBMITTER')
This implies that you should use a common id to submit your reports to the BCA. If that ID is used, then the prompt will be ignored. You still have to fill it in on the initial submittal, but it will be ignored. Regular users well get their prompt value used.