## how to handle 1800 cubes in an Extranet?

### how to handle 1800 cubes in an Extranet?

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

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.

### how to handle 1800 cubes in an Extranet?

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

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

What happened ???

I went on vacation (I know, I know it ALWAYS blows up then), and SQL
Server blew up big time...

Configuration: Dell Dual Pentium III -- 500mhz -- 1 Gig Ram
NT 4.0 SP6 -- SQL Server 7.0 SP2 -- Outlook 2000 for SQLMail

Problem: SQL Server used up over 1800 threads and then stopped. This
happened several times over the course of 2 days.  Now it is back to
using only 45 threads for the past 48 hours....

Tried to use SQL Profiler and it showed just normal queries -- nothing
long-running -- until it stopped since it could not allocate any more

Of course now that I'm back it is running smoothly again -- as it was
for several months...

Bad News is that I'm scheduled for another 3 days off next week and
don't know what caused this last problem, so don't know what to expect
while I'm gone again...

Any ideas ???

Paul D. Johnson

Sent via Deja.com http://www.deja.com/