BusinessObjects Board

bypass auto refresh prompt

building reports desktopintelligence
#1

I am wanting to utilize auto refresh of a report on an hourly basis. I have it setup to refresh every hour. It does perform a refresh when expected but it always pops up the prompt with report conditions such as date and time, etc. Can this be bypassed or coded via a macro or script. I would like for the auto refresh to be totally unattended.

Thanks

Waxaholic (BOB member since 2005-08-01)

#2

Remove the prompts and hard code the values in the query panel.

Steve Krandel :us: (BOB member since 2002-06-25)

#3

I have removed all the conditions in the query editor but there is still a prompt upon refresh. It is a “Resolution” prompt which is asking for Day, Week, Month, Quarterly, Yearly. I can’t seem to figure out how to get by this. There doesn’t exist a predefined condition nor does it exist under the “Classes and Objects”.

Thanks,

Waxaholic (BOB member since 2005-08-01)

#4

Then it must exist in the universe itself. Sometimes people put prompts in the joins in the universe.

Steve Krandel :us: (BOB member since 2002-06-25)

#5

Thanks. I will check the universe and come up with a workaround. Thanks again for the guidance.

Waxaholic (BOB member since 2005-08-01)

#6

Hi,

If you are using BCA…

Check this thread.

https://bobj-board.org/t/15229/10

BO_Chief :us: (BOB member since 2004-06-06)