Skip to Content
avatar image
Former Member

Issues faced while using BICS for creating WEBI report

Dear Experts,

I am facing below issues while creating WEBI report by using BICS:

1. There are prompts(for a characteristic) which are set at BEX level with values as Text and Key both. But in WEBI this prompt has only key values.What should be done to get key and text values both in input selections.

2. I am facing refresh problem in WEBI by using BICS. The prompts LOV values are not coming properly.. For example:

      Below is the prompt in my Webi report:

            Vendor = ABC

            Calmonth = 09.2014

            Material = A

      The report executes and after that I click on refresh again to enter new vendor.

         Vendor = XYZ

But in LOVs of vendor I can see only ABC not XYZ although data is available for this selection. When I manually enter XYZ, the selection is possible.

Please help me out.

Regards,

Ravi Rawat

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Dec 22, 2014 at 01:46 PM

    Hello,

    For problem 2, please try using the settings encircled below:


    Filter2.png (5.8 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Dec 23, 2014 at 05:02 PM

    What version are you on of BI 4.x?  I believe issue 1 was an old issue that should be resolved in the new Support Packs.

    Issue 2 also sounds familiar.  Are you on an older version?

    Thanks

    Jb

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 24, 2014 at 04:27 PM
    Add comment
    10|10000 characters needed characters exceeded

  • Dec 24, 2014 at 06:03 PM

    Hello Ravi,

    the BEx variable refers to a characteristic in your BW system and as part of the underlying InfoObject in BW there are properties that allow you to define if you would like to see the master data or the data from the cube. This needs to be defined on the InfoObject level - not in the BEx query.

    regards

    Ingo Hilgefort, SAP

    Add comment
    10|10000 characters needed characters exceeded