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
Thanks in advance
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.
Edited by: B V C on Apr 14, 2010 1:53 PM