Issues faced while using BICS for creating WEBI report

[ravi_rawat]

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

[IngoH]

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

[Former Member]

Hi,

This is a bug resolved in BI4.1 SP4.

For more information, please refer to this KBA: 1971834 - In the Rich Internet Application or the WebIntelligence
Rich Client, when entering prompt ...

Kid regards,

Wafa Ben Nacef

[former_member59613]

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

[ravi_rawat]

Hi Jonathan,

It's BO 4.1.

Thanks,

Ravi Rawat

[former_member202257]

Hello,

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

[ravi_rawat]

Hi Shwetha,

I tried but still it is not working.

I am facing the same issue.

Thanks,

Ravi Rawat