on 08-29-2012 7:05 PM
Hello-
I am using VC 7.3 and I have a simple model with a BW Query where it has 1 input variable and I output the results to a table. If I enter in an exact value, "01234", then I get the expected results (2 rows of data). However, if I enter in something like "faketext", I get an error message: "All selections for characteristic "XYZ" are invalid and have been discarded." and all the results show in the table like the query was run open ended.
In 7.0 Visual Composer this works as expected--no results are returned in the 2nd example where non-existent text was entered.
It appears that when I use the Filter port instead of the Variables port I get the results I am looking for however I dont think this is the solution. Any thoughts greatly appreciated.
Thanks,
Marty
Hi Marty,
there is no reason to open a SAP support message. This is a known problem that is caused from BI side. Check out note 1679910 in combination with note 1532050.
Regards,
Anja
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
We have recently upgraded from BW 7.01 to BW 7.31 SP 7. In our case also we are facing this error when we execute the query:
""
We are facing this issue only when query is executed on BI JAVA system. However when we execute same query in RSRT, it executes without any error.
: Was you problem related to Date Characteristic? Have you resolved it?
Regards,
Deepak
Hi Marty,
Am getting the same issue when i try to update the comment field in the input enabled query in Integrated Planning BI 7.3. Can you please let me know how did you resolved this issue.
Thank You.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Marty,
I'd like to add some info, I hope it's relevant for your case:
See Note 1794460, for using the Variables input port on a BI Query. You should get no results for an invalid input value.
Regardless of the desired behavior on the BI level, it's possible to define a dropdown list for the input value, so the user can't go wrong (using an Entry List). I know it's not always relevant - If it's relevant for your case it might be a nice addition to the application.
Thanks,
Udi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Marty,
it sounds like that you have migrated from 7.0 to 7.3. However, there are some changes, but in you case I think if there is no suitable solution availbale for you then I would open an oss message.
Regards,
Marcel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.