Very Computer

by **german mari** » Tue, 06 Apr 1999 04:00:00

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.

Firt issue:
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.
Problems:

-We dont want to build 1800 cubes
-We dont want to build 1800 fact tables and 1800 product and supermarket
dimension.

Second Issue:
In the Intranet, the supermarket chain want to see the data from all the
supplier.

Problems:

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.

by **Adrián Ceballo** » Thu, 06 May 1999 04:00:00

Hi,

Maybe this can help...

We build cubes using rolap or molap. We use "Papiro Reporter" and "PapiroWEB"
to publish all the sales externally through the WEB. Papiro permits to restrict
users to only that information that belongs to them. Take a look:
http://www.bftsystems.com

Internally

> 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.

> Firt issue:
> 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.
> Problems:

> -We dont want to build 1800 cubes
> -We dont want to build 1800 fact tables and 1800 product and supermarket
> dimension.

> Second Issue:
> In the Intranet, the supermarket chain want to see the data from all the
> supplier.

> Problems:

> 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.

Very Computer

how to handle 1800 cubes in an Extranet?

how to handle 1800 cubes in an Extranet?

how to handle 1800 cubes in an Extranet?