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

BEx: Characteristic master data

Hello

I have a questions regarding the customizing of BEx settings of master data, in our case "business partner".

Selection of Filter Values for Query Execution in BW (backend) -> Values in Master Data Table

A defined BEx query which also uses this master data "business partner" has the following setting for it:

Filter Value Selection during Query Execution -> Only Values for InfoProvider

With this setting I assume that the setting in the master data of BW are oversteered.

I would like to see in my filter variable only business partners which are connected to transactional data in my Infoprovider (cube).

But it does not work, also business partners with no data in the cube are selected in the filter variable.

Any ideas?

Thanks

BEO

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jul 15, 2011 at 08:29 AM

    the workbench settings are taken as default values when you use the infoobject in a query. they can be overwritten in the designer. you need to put it back to the default value to get what you want.

    M.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      If this is not the case that bp is line item in the InfoCube, than at the moment I also don't know what it could be. Check the note but I don't think it can help you.

      As far as I understand your situation, you have the setting to show only values from InfoCube in the BEx Query Designer it should work.

      Do you have a 7.x or a 3.x BW? For 7.x you can find hint's in note 984229 for 3.x in note 796737, maybe one will help you.

      We are also just discussing 1416952 for a line item case at the moment. Haven't implemented and tested it yet, because we would need a higher enhancement package on our system. If you will try out it would be interessting to hear from you.

      Regards,

      Peter

  • author's profile photo Former Member
    Former Member
    Posted on Jul 15, 2011 at 08:40 AM

    Hi BEO,

    is this query created on the multiprovider with more than one infoprovider?

    have you checked whether any transaction data available in the all the infoproviders?

    Thanks,

    Krishnan

    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.