The universe designers built in prompts in to the universe, but the values for the report I’m working on don’t change and I’d like to disable the prompts, is this possible?
MBradbourne (BOB member since 2003-08-28)
The universe designers built in prompts in to the universe, but the values for the report I’m working on don’t change and I’d like to disable the prompts, is this possible?
MBradbourne (BOB member since 2003-08-28)
Change the report query to include the hard coded conditions like
TAX_ID = ‘1234567’ instead of having
TAX_ID = @prompt (“Enter Tax ID” , N,)
What it means do not use the predefined condition/object of the universe instead create your own condition in the query panel by selecting that object and equating to the value.
JaiGupta (BOB member since 2002-09-12)
If the prompts are built into the universe as part of self-restricting joins/stub-joins on tables there is nothing you can do short of modifying the SQL code directly (which will increase maintenance down the road).
Andreas (BOB member since 2002-06-20)
The prompt is there, but I can’t edit the SQL directly (can you set that at a Universe level param?)
MBradbourne (BOB member since 2003-08-28)
Editing SQL is a right granted via Business Objects Supervisor.
I do not recommend editing SQL directly as this increases maintenance on the reports.
Andreas (BOB member since 2002-06-20)
If it’s the only option I have, I really have no choice. But it doesn’t matter because I can’t edit the SQL anyway.
MBradbourne (BOB member since 2003-08-28)
What do you mean by “built in prompts” exactly? Does that mean that any time a given table is used, it prompts (a bit unusual, but it could be the case)? Or does the use of a certain object trigger the prompt (this would be a more traditional use of a prompt)?
Dwayne Hoffpauir (BOB member since 2002-09-19)
Add some VBA so that BeforeRefresh the Application.Interactive is set to False. Then set the AfterRefresh to set the Application.Interactive back to True.
This prevents prompts from appearing and will therefore keep their current values.
digpen (BOB member since 2002-08-15)
The prompt is built in to the table join…
...WHERE
( PO_Creation_Date.DT_REF=SOURCING.PRCH_ORD.DT_CRTE_PO )
AND ( (SOURCING.PRCH_ORD_STAT.CD_STAT_PO=SOURCING.PRCH_ORD.CD_STAT_PO and SOURCING.PRCH_ORD_STAT.CD_SYS_SRC=SOURCING.PRCH_ORD.CD_SYS_SRC) [b]AND (SOURCING.PRCH_ORD_STAT.CD_SYS_SRC IN @Prompt ('Click "Values" & Select the desired Source Systems', 'A','Source System\System Code', MULTI, CONSTRAINED)) )[/b]
.....
MBradbourne (BOB member since 2003-08-28)
Then my suggestion was going to be the same as digpen. Put this VBA code in the ThisDocument module.
Private Sub Document_BeforeRefresh(Cancel As Boolean)
Application.Interactive = False
End Sub
Private Sub Document_AfterRefresh()
Application.Interactive = True
End Sub
It will cause the prompt boxes not to appear. The queries will refresh with the previous values. Be sure not to purge the data providers as this will “empty” the previous prompt choices.
Dwayne Hoffpauir (BOB member since 2002-09-19)