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

dispaly vendors in bex who are not generated transactions

Hi Gurus

I want to display vendors who are not involved in transactions for a particular month in bex. I have master data for that vendors, but don't have data in cube for the vendors for that month as they not generated any transactions.

Any body plz hlep me out



Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 27, 2007 at 06:13 PM

    hi Shiv,

    Refer to note 541559. it for slow moving item report and an example on how to include all the customers that are not available in the cube is given. u can apply a similar logic by making a multiprovider on ur cube and vendor master data and then do the steps as said for customers in the note.

    Hope this helps you.



    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 01:48 PM


    According to Note:541559

    First create a multiprovider with your cube and the InfoObject vendor(for example 0vendor).Now define a particular structural element 'All customers':

    You take a key figure from the InfoObject provider, for example, 'Number of records' (1ROWCOUNT) and filter the InfoProvider artificial characteristic (0INFOPROVIDER) on the corresponding InfoObject (0CUSTOMER). You now activate the 'constant selection' attribute on this selection (on the 0INFOPROVIDER characteristic in the context menu) and then the 'Display non-posted values' attribute.

    The element 'All customers' now causes the infoobjectprovider (0CUSTOMER) to be read as well.

    The function 'Display unposted values' first internally generates a 'Constant selection' at the 'Characteristic' InfoProvider.This means that all restrictions on characteristics that do not exist in the infoobjectprovider - for example time characteristics - are not taken into account.Restrictions to characteristics that belong to both subproviders are however taken into account - for example customer group - (see also note 541517).

    The 'Constant selection' only changes the values in the corresponding columns, but does not generate any new rows.This is achieved via the function 'Display unposted values'.

    You now get the slow-moving items via an output condition on the sales column.If you don't want the element 'All customers' in the display, of course you can hide it

    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.