Skip to Content

All selections for characteristic XYZ are invalid and have been discarded

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Sep 11, 2012 at 06:57 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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 

  • Jul 08, 2013 at 04:49 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 10, 2012 at 08:50 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 10, 2013 at 10:15 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded