on 08-19-2013 11:23 AM
Hi All,
I have a query browser connectivity with a prompt, i have connected this prompt to an excel sheet. The selector(prompt i/p), has two formats one is a number say some 38491, and the other in the name of a state. Now when i run the query i get the following error,
Request processing failed. (XLS 000009)
Request processing failed. (XLS 000009) [] <com.businessobjects.semanticlayer.qt.QTException: Query script generation failed. See your BusinessObjects administrator. {0} (WIS 00013)>
this occurs only when I pass the number but when i pass the Text format (name of state) it works fine and the error does not pop out, can anyone point out what problem this is. The number selection (38491) passes as a text only, i even tried passing it alone and still does not work. I appreciate any helps or tips,
Thanks,
Fazith
Hello,
Which version are you running?
If I remember correctly this happened in SP5 and is fixed now.
Alex
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mohammad,
i think that you are trying to pass the Key value to BW query.
if it's the case so i can confirm that it's a bug, ADAPT01693215.
for more infotmation please check the SAP KBA
Best regards,
Mohamed AISSA.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
The dimension on which the prompt is set - is that defined as string or number in the universe?
Are the number and state prompts on the same query or separate query?
Thanks
Runali
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.