Problem in displaying Query condition with Report refreshe

building reports desktopintelligence
1

actively (@Prompt / UserResponse) OR Broadcast Agent (Script with SetAppl icationValue / ApplicationValue) MIME-Version: 1.0

Hi folks,

I realise that it is a long subject, but it’s a long story as well. Thanks for your help.

A customer, here in Australia, has to designed reports flexible enough to be able to be refreshed manually (Refresh Normally) or through the Broadcast Agent (Refresh Script) but getting the prompted values from a script, so we don’t have to reschedule the report every single time to change the prompt values.

And we want to display the values passed to the report and display them in the report in a cell.

So mainly, the idea is to display the value for “ApplicationValue()” or “UserResponse()” so we are sure the value returned is always filled. It works perfectly ONLY if you are refreshing the report interactively with or without script.

In the following variable’s definition, the user can choose a Year before to refresh the report.
If(ApplicationValue(“Year”)=“”) Then (UserResponse(“Query 1 with BEACH” ,“Year”)) Else (ApplicationValue(“Year”)) So if the Year has been filled interactively by a user, then we’d like to use “UserResponse()” otherwise if the script fixed the value then we use “ApplicationValue()”

As soon as you try to send the report to Broadcast Agent with the script the values stay blank in the report we retrieve from Broadcast Agent.

We have found so far the function ApplicationValue only works for the individual BusinessObjects
session that you are working in at that time. To prove this, if we open a document we noticed that the “ApplicationValue()” is no longer set.

This means that when BroadCast Agent has finished creating the document and ends that session, the “ApplicationValue()” is no longer associated to that report. If the variables that were used in the script are invoked when opening the document, then we saw them displayed in our report. If we do this we can’t refresh the prompts manually and won’t be able to refresh the documents the way we are trying to do.

Is there any other function we should use to get the values in both cases ?

Thanks

Pascal BRENNER

Pascal BRENNER - BusinessObjects Pre-Sales Consultant

“A superior sailor is one who uses his superior judgement to keep out of situations that require the use of his superior skills.”

Executive Computing - Sydney Office - 6 Ryde Road - Hunters Hill 2110 - Australia

Professional Mail : pbrenner@ecg.com.au Personal Mail : pbrenner@technologist.com
Phone : +612 9816 3433
Fax : +612 9816 3455

Listserv Archives (BOB member since 2002-06-25)

2

nter actively (@Prompt / UserResponse) OR Broadcast Agent (Script with Se tAppl icationValue / ApplicationValue) MIME-Version: 1.0

Hi Pascal,

The easiest way to achieve this is to add the year dimension object from the universe to the dataprovider that uses the prompt/script variable and use that in stead of the ApplicationValue or UserResponse, there is no way to save the ApplicationValue for a later session.

Good luck,
Marianne Wagt

Listserv Archives (BOB member since 2002-06-25)

3

Interactively (@Prompt / UserResponse) OR Broadcast Agent (Script withSetAppl icationValue / ApplicationValue) MIME-Version: 1.0

Congratulations!
You too, fell into this. We had this issue about 1 year ago and were not able to solve it via the builtin functions.
I think, the best way is to include the year object in the query result and, depending on the values, use a min/max function in the display cell.

OR: you yould create a simple script triggered on after_refresh, which sets a local “information” variable to the value of the UserResponse (if run interactively) or to the ApplicationVariable (if run by DAS). You must use the evaluate function in this case to get the value first, then set the (new) Document Variable to this value.
This is just an idea, I did not try this.

Walter

PS: as the name says: ApplicationVariable is only valid and available for the active session of Busobj, whereas
UserResponse is the response of the user IF ANY, otherwise is is empty (or undefined?)

Hope this helps.
Walter

Pascal Brenner wrote:

Hi folks,

I realise that it is a long subject, but it’s a long story as well. Thanks for your help.

A customer, here in Australia, has to designed reports flexible enough to be able to be refreshed manually (Refresh Normally) or through the Broadcast Agent (Refresh Script) but getting the prompted values from a script, so we don’t have to reschedule the report every single time to change the prompt values.

And we want to display the values passed to the report and display them in the report in a cell.

So mainly, the idea is to display the value for “ApplicationValue()” or “UserResponse()” so we are sure the value returned is always filled. It works perfectly ONLY if you are refreshing the report interactively with or without script.

In the following variable’s definition, the user can choose a Year before to refresh the report.
If(ApplicationValue(“Year”)=“”) Then (UserResponse(“Query 1 with BEACH” ,“Year”)) Else (ApplicationValue(“Year”)) So if the Year has been filled interactively by a user, then we’d like to use “UserResponse()” otherwise if the script fixed the value then we use “ApplicationValue()”

As soon as you try to send the report to Broadcast Agent with the script the values stay blank in the report we retrieve from Broadcast Agent.

We have found so far the function ApplicationValue only works for the individual BusinessObjects
session that you are working in at that time. To prove this, if we open a document we noticed that the “ApplicationValue()” is no longer set.

This means that when BroadCast Agent has finished creating the document and ends that session, the “ApplicationValue()” is no longer associated to that report. If the variables that were used in the script are invoked when opening the document, then we saw them displayed in our report. If we do this we can’t refresh the prompts manually and won’t be able to refresh the documents the way we are trying to do.

Is there any other function we should use to get the values in both cases ?

Thanks

Pascal BRENNER

Pascal BRENNER - BusinessObjects Pre-Sales Consultant

“A superior sailor is one who uses his superior judgement to keep out of situations that require the use of his superior skills.”

Executive Computing - Sydney Office - 6 Ryde Road - Hunters Hill 2110 - Australia

Professional Mail : pbrenner@ecg.com.au Personal Mail : pbrenner@technologist.com
Phone : +612 9816 3433
Fax : +612 9816 3455

OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’ Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’

–
Walter Muellner
Delphi Software GmbH / Austria
w.muellner@delphi.at, Tel. +43-1-8151456, http://www.delphi.at

Listserv Archives (BOB member since 2002-06-25)