Skip to Content
avatar image
Former Member

WEBI 4.1 - BICS - Access type for Result Values

Hi Expert,

I'm going to create new webi reporti in BO 4.1 using BICS connection.

I'd like to use in Bex query the property "Master Data" in "Access type for Result Values" but doesn't work.

I've done that:

step 1

1. set property Master Data in Access type for Result Values for infoobjects 0COSTCENTER in bex query

2. Insert infoobjects 0COSTCENTER in my WEBI report and it DOESN'T works! I'm showing only posted values.....

step 2

1. set property "Retrieve empty rows" in webi report query panel

2. refresh report, and now it WORKS fine!!!!

step 3.

1. add 0CURRENCY in bex query

2. set property Posted values in Access type for Result Values for infoobjects 0CURRENCY in bex query

3. add 0CURRENCY in webi query panel

3. add 0CURRENCY IN webi report and now I'm showing ALL currency though without value.

At this point I'm thinking that property "Access type for Result Values" in BEX query for BICS connection DOESN'T WORK!!

Could someone confirm that?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 02, 2014 at 08:42 AM

    Hi Gianmaria ,

    Bex query property "Master Data" in "Access type for Result Values" is only for BEx analyzer.

    Below thread may help

    http://scn.sap.com/thread/1566637

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Gianmaria,

      correct the setting in the BEx query will retrieve the master data information based on the navigation status for elements in the rows and columns.

      if you only need this for a single InfoObject you would have to solve it in the BW modeling by for example exposing the InfoObject as InfoProvider and then using a Composite Provider or a InfoSet (depending on BW version).

      Why do you need 0CURRENCY ? remember that the currency field in Web intelligence is not identical to 0CURRENCY as 0CURRENCY is only there once in the query and if you have more than one measure the currency field is the correct one.

      Also remember that Web Intelligence is a relational product and not an analytical product and Web Intelligence will always struggle with these concepts and the better choices for BW and HANA are the Analysis products.

      regards

      Ingo Hilgefort, SAP

  • Jan 02, 2014 at 05:01 PM

    Hello Gianmaria,

    Web Intelligence and Crystal Reports "ignore" the setting in the BEx Query Designer and the setting you mentioned for Web Intellience (Retrieve empty rows) is the correct setting to achieve what you looking for.

    Ignore all the other suggestions about two queries, or several providers - those are not needed for this.

    Simply set the property Retrieve empty Rows and Web Intelligence will show the report based on the master data.

    Analysis Office and Analysis OLAP are using the setting from the BEx Query and there is no extra step needed.

    regards

    Ingo Hilgefort, SAP

    Add comment
    10|10000 characters needed characters exceeded