This blog wil be updated almost daily and the topics will be dealing with the daily support of SAP BusinessObjects BI support. So check back daily! Protected by Copyscape Online Plagiarism Test

Sunday, February 5, 2012

Some Options are disabled / not funtional in WebI 4.0 on top of SAP BW BEx Query

 SAP BusinessObjects introduced a new functionality where now WebI documents can be created on top of BEx query using BICS.


SAP BusinessObjects 4.0 (Product: 14.0.0) Patch level 10.0

SAP BW: SAP EHP 1 for SAP NetWeaver 7.0 (Patch 08)

The BEx : BI AddOn 7.x on (based on 7.10); SP 10, Patch 1

Java Pug-in: Java version 6 Update 29 (build 1.6.0_29b11)

I’m using the WebI from BI Launch Pad which uses Java plug-in to work. I’m not using SAP Web Intelligence Rich Client (this one needs local client installation).

1) The Scope of Analysis and View Script (previously View SQL) option in the Design mode of the Query
     Panel are not available if you use BEx queries as a source. You will see those disabled.


                    FIG 01 – The Scope of Analysis and View Script options disabled
 
2) In the Filter area in WebI on BEx, the AND operand does not change to OR
 
 
    Fig 02 – Query Filters using AND operand
 
If you try to double-click on this operand AND to try change it to OR, this will not work.
 
3) The search operands underscore (“_”) and percentage (“%”) doesn’t seems to work in WebI on
    top of BEx queries. Only operand “*” works. The obvious reason is the List of Values are not save
    on server.
 
 
 Fig 03 – Search Operand for List of Values
 
 
   Fig 04 – Search in Keys option
 
 
4) The Use Query drill also doesn’t work. Although you can check it in the Document Properties but it
    doesn’t work
 
 
         Fig 05 – Use Query Drill option in Document properties
 
At this time I could only find these options not to work. There could be other’s which I could not yet test.


Please update and let me know if anything here needs to be corrected or needs to be added here.


*******
******
*****
****
***
**
*



No comments:

Post a Comment