I encounter a problem with the behavior of data restitutions during the execution of this one.
The problem arises when, from the data provider and a multiple request, we define the same prompt title with different values.
Can you tell me at runtime if these multiple queries if they take into account the values of the prompts of each of the queries?
Because when I run the queries with the titles of the common prompts from the first query, query 2 directly benefits from the values.
In the query properties, the order of the prompts titles mention the same prompt title repeated twice.
Is this normal?
As an example:
Combined query 1: Prompt title “prompt label” with the value “one” “two” “three”
Combined query 2: Prompt title “prompt label” with the value “four”
Obtained result :
Value corresponding to the first combined request = “one” “two” “three”
Value corresponding to the second combined request = “one” “two” “three”
Expected result :
Value corresponding to the first combined request = “one” “two” “three”
Value corresponding to the second combined request = “four”
Thank you in advance for your help.
I hope the French / English translation is correct
Plateforme SAP BusinessObjects BI 4.2 Support Pack 3 Patch 3
Version : 14.2.3.227
When you have two prompts with identical titles (names), Business Objects will treat them as the same. This is why both requests are returning the same values.
If you want different values for the two prompts, you will need to configure them to have different titles (or names).
Good afternoom, thank you for the response.
It’s strange I thought it worked with an old version. In addition, when we execute the code in SQL in a queryer, this one makes the distinction between the first query and the second query. In my example, the first query on the values "one, two and three" and the second query displays the result according to the value “four”.
Otherwise the 2nd solution does not suit me because the user must have only one guest title.
In a situation I need to create a combined query to isolate a different data population from the first combined query.
Doing a single request with sub-requests and the same guest title with different values would I have the same result as doing two combined requests?
Thank you for your help
as said, there has to be different labels to work with different user input.
if you want to remove data from the first query with a second query you can use a subquery
( query1 … but not-in-list of query2)
or a combined-query with the minus-combination-type,
the result will be the same.