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