Skip to Content
0
Former Member
Apr 08, 2010 at 02:25 PM

Unique Count of Vendors in Master Data

423 Views

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