cancel
Showing results for 
Search instead for 
Did you mean: 

Display message on a web template for specific queries

Former Member
0 Kudos

Hi all,

We're trying to find a way of displaying a message in our standard web template (0ADHOC) in order to warn users about issues concerning specific queries (availability of data, maintenance...). So, we would like to establish one message for some querys and be able to display it in our web template only if availabe.

We faced this requirement with 2 different options, but none is working perfectly:

1.- Add a Single Document web item to 0ADHOC_HEADER web template in order to display a document related to our InfoProvider. Issues that appear:

- Warning messages need to be suppressed because when query doesn't have a related document, an horrible warning message is displayed.

- InfoProvider related documents need to be established for each calendar month, so we're not able of establishing a document that can be correct for all months on the InfoProvider. So, document only appears if user sets a specific calendar month filter. If he doesn't set any filters, document is not displayed.

2.- Use callquerydoc() in 0ADHOC in order to call query documentation on a new window when web template is loaded. Issues that appear:

- If the query doesn't have a related document, we won't like the new window to appear (because it shows an error about not finding documentation).

- No matter where I put the call to that JavaScript function, but each time you press a button or change something when executing the query, new window appears again.

Could someone give me solutions for issues of at least one of these two options?

If you have other suggestions to achieve our goal, please let me know.

Thanks and best regards,

David.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

This can be done using a Custom BSP or JSP application workin along with the BI Web template.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi there, any replies? Should I summarize my question?

How do you notify users when data is not reliable? (caused by, for instance, data loading errors, query maintenance... so on).

I once used system messages (sm02) to notify all those data failures, but now we want the notification not to be global, but to be specific for some user groups (or query groups), and visible when they execute any query.

Thanks again,

David.

former_member184494
Active Contributor
0 Kudos

David,

Which version are you in ?

Also you could look at passing messages using user exits but am not sure as to how to get the query being executed using user exits... but then assume that such messages would be specific to infoproviders and there should be a way to fetch the same in the user exit.

Arun

Former Member
0 Kudos

Hi,

We're on BW 7.0 SP 10.

Regarding your answer, I don't exactly understand what you mean. What user exit should we modify to pass messages to a query execution? the one for query variables? User will execute a query using the standard way (bex, browser, internet browser).

Please, let us know. Thanks a lot,

David.