Hello.
I am using BusinessObjects 4.1.4. I am having a problem with DAS refreshing
a report built from a universe that has an @prompt created by Designer.
I have recreated the problem using the Beach universe which comes on the
BusinessObjects CD. First, in Designer I built a self join on the Region
table. I joined the field region to itself an put the following @prompt
statement in the where clause:
Region.region BETWEEN
@Prompt(‘Begin’,‘A’,‘Customer\Region’,MONO,constrained) AND
@Prompt(‘End’,‘A’,‘Customer\Region’,MONO,constrained)
Then, in Reporter, I created a report with the objects region and customer.
The prompt box appeared when the report was run and I selected England for
both Begin and End. The report ran and returned data where the region was
England. The report was saved as Islands Resort Test England.REP
I then created and compiled two scripts as follows:
Begin Paris.SPT
Sub Main
Application.Variables.Item (“Begin”).Value=“Paris”
End Sub
End Paris.SPT
Sub Main
Application.Variables.Item (“End”).Value=“Paris”
End Sub
I sent the Islands Resort Test England.REP to DAS with the following
selected actions:
Begin Paris.SPT
End Paris.SPT
Refresh Document.
DAS completed successfully but when I retrieved the Islands Resort Test
England.REP file from DAS I found that only the End value had been
refreshed. The report now showed data beginning from England and ending
with Paris.
How can I set up DAS so that both the begin and end values of my scripts
will be refreshed in the document. I cannot combine the two scripts into
one. Any help would be appreciated.
Best regards,
Crystal Golding
Senior Systems Analyst
Management Information Section
University of Queensland
Brisbane Australia 4072
E-mail: c.golding@mailbox.uq.edu.au
Web: www.mis.jdstory.uq.edu.au
Phone: +61 7 336 57289
Fax: +61 7 336 58202
Listserv Archives (BOB member since 2002-06-25)