Hi,

I have one cube similar to the FoodMart Database and the Sales cube,
with one store dimension.

The problem is that the stores need to know their sales and the total
(not the others stores sales) but they access to the cube by the
internet (the problem is that the stores are not in my intranet).

How can I filter the information to every store? Do I need to create
one windows user per store?

I was thinking in use Proclarity or MIS as a front-end for the stores.
Do you think that these applications will help?

Did anybody found this problem before?

Thank's in advance!!!

Un saludo,

Enrique Barceló