Suppose a supermarket chain. It has 50 supermarkets , 1800 suppliers and 30
000 products. They want to offer information to their suppliers trough an
Extranet and SQL server 7 Olap services.
They want that each supplier knows the sales at each supermarket but only
about their own products.
P.e: Coca Cola can see only their products. Coca Cola can not see wich are
the others suppliers and products from other suppliers. All that trough a
browser with security access.
-We dont want to build 1800 cubes
-We dont want to build 1800 fact tables and 1800 product and supermarket
In the Intranet, the supermarket chain want to see the data from all the
If I build a Virtual Cube from all the 1800 cubes, the "sales" measures
from each cube has a different measure. Is there any way to group these
measures in only one?
The data warehouse has a Sales Fact table and Product, Supermarket ,
Supplier and time dimensions.