Skip to Content
author's profile photo Former Member
Former Member

variable "read mode setting" Only Values for InfoProvider

Hi,

I have a problem with Selection Variable for a BEx Query:

- I'm working with SAP BI 7.0 support package 15

- My query is an input ready query;

- Characteristic, I want to filter with variable, has query property Advanced->Query Execution for Filter Value Selection = Only Values in InfoProvider

My problem is:

when I execute a query,

the Select Values for Variables screen appears

I push on the Select from List button

and Select Values For MyCharacteristic appears...

but it shows me all values in master data table of my characteristic instead of only values in the infoprovider!!!

Could someone explain me why it doesn't work correctly?

Thank in advanced

Fede

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 27, 2009 at 09:54 AM

    Hello Federico,

    For correct results You have to edit the info-object(characteristic) and

    then In the Business Explorer tab--> Query Def. Filter Value Selection -->Values in the info-provider.

    What you are doing is you are making changes to--"Query Execution for Filter Value Selection' field

    instead of this you should make changes to Query Def. Filter Value Selection then only the characteristic will show the values in the infoprovider in the list of values.

    Regards

    Priyanka

    Edited by: Priyanka on Mar 27, 2009 3:24 PM

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Priyanka,

      I'm sorry,

      but I forgot to write that my info-object(characteristic) has already set the property

      Business Explorer tab--> Query Def. Filter Value Selection as Only Values in the info-provider...

      then I don't understand why it doesn't work correctly!!!

  • author's profile photo Former Member
    Former Member
    Posted on Mar 30, 2009 at 12:35 PM

    Thanks to Mariana Lazar

    30.03.2009 - 12:30:36 CET - Risposta by SAP

    Dear Fede,

    Regarding the query built on aggregation level please note the following

    the aggregation level is always a Virtual Provider built other

    InfoProvider and hence it does not have the dimension table and hence

    the F4 mode D is not supported.

    Therefore when aggregation level is used in a query, F4 does not supportD-mode: 'Only Values in InfoProvider' and all master data values are

    displayed in the value list.

    Reference from the note

    984229 F4 modes for input help as of SAP NetWeaver 2004s BI

    ________________________________________________________________________

    4. Since other InfoProviders do not have a dimension table, the system

    displays only posted values if you select "Only Posted Values for

    Navigation". Otherwise, it displays the values from the master data

    table.

    ________________________________________________________________________

    Hope this should clarify your doubts. Please let me know if you have

    questions else please confirm the message at your earliest convenience.

    Thank you for your cooperation and kind regards,

    @KR@ Mariana Lazar

    Senior Support Consultant

    SAP Active Global Support

    Netweaver Business Warehouse

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.