All selections for characteristic XYZ are invalid and have been discarded

[MartyMcCormick]

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

[anja_engelhardt2 · Accepted solution]

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

[Former Member · Accepted solution]

Hi Marty,

please check the notes that Anja mentioned. Please verify that you are on 7.30 SP8+ as mentioned in the OSS notes. Please let us know if your issue is solved or not.

Regards,

Marcel

[Former Member · Accepted solution]

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 

[Former Member]

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.

[former_member202465]

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

[Former Member]

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