Skip to Content
avatar image
Former Member

List of values not loading in Webi

Hi Team System Environment: SAP BW 7.1 & BO 4.1 SP4 Issue-BO Web intelligence reports not displaying list of values for variables while running query Info-provider for Bex query  -BW Cube Source for Webi-Report      -Bex query Connection type                  -BICS Connection we have design a BO WebIntelligence report on top of Bex query using BICS connection with couple of Variables When Bex query is executed in BW Environment able to see LOV's for variable When BO Webi report is executed unable to see LOV's for same Variable can any one suggest possible solutions Regards Bose

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 15, 2014 at 07:57 PM

    Your creating a prompt in universe based on list of values else in query filters. If it's in query filters are you prompting and enabled the option to show lov's?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2014 at 06:09 AM

    Hi Bose,

    Try the below and let me know.

    If you use Prompt:

    Uncheck "Keep last values selected" in prompt properties and now LOV's would be displayed automatically.

    If you use Value(s) from List:

    Check "Match Case", "Search in Keys" and "Search in Database" and give * to get list of values.

    ---Raji. S


    Add comment
    10|10000 characters needed characters exceeded

  • Oct 16, 2014 at 06:36 AM

    Hi Bose ,

    Are you getting any error .Can you post screenshot of issue .

    Use the object as prompt in the webi report to check whether the object holds any values are not.

    create a new report on same query and check in the set Variables of webi query panel whether LOV's are populating .

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Bose

      Are you able to see the list of values in the Prompts created as mandatory variable in BEX while running WEBI reports..

      I tried it out in 4.0 version and 4.1 SP01 version but i was not able to .. Kindly confirm the same..

      Or if any workaround done kindly let me know..

      Many thanks


      Regards

      Akshay