Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Unique Count of Vendors in Master Data

Hi BI Gurus;)

I am trying to complete the following.

I need to be able to show the total number of unique vendors in Master Data (Not in the cube)

I do not want to have 0VENDOR in the rows to achieve this. I want the formula to calculate this and not require 0VENDOR in the rows.

I can complete a reference characteric attribute value=1 but this gives me the count of the unique vendors in the cube only and I want the count of unique vendors in Master Data.

FYI there are approx 100 Vendors in the cube but 5000+ in Master Data.

The query result should show the following on one row

Purchasing Org................ Unique Number of Vendors in Master Data

1000 5000

Any ideas?

Thanks in advance

Stevo

Former Member
Former Member replied

Hi Stev,

Create a InfoSet between InfoObject 0VENDOR and InfoCube and create the Report on Infoset

Use 1ROWCOUNT keyfigure in report to meet your uniquie number of Vendors under a perchanse group.

This report will populate all master data from Infoobject 0VENDOR.

If you have any issues with Infoset design, Alteranatively, Create a multiprovider

create a hierarchy in 0VENDOR

Create a multiprovider on Incube and Infoobject.

use 1ROWCOUNT to measure unique records

and also Key Figures from cube will be available in extended star schema format.

Let me know if the above options not fulfil your requirement.

Best Regards,

BVC

Edited by: B V C on Apr 14, 2010 1:53 PM

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question