Pivottables and web access

[datras]

I am creating a database for scientist from a number of countries. They have asked for web access with pivottables to the database.

So fare I have created a data warehouse with cubes in SQL server analysis services 2000 and now I have tried to create a pivottable. I have just taken the web component in Visio InterDev and used the wizard to link to the cube. I have made a role for the cube where I so fare only have included myself as a user.

This is working as long as I am logged on to the PC with my user name and password but of cause a person from outside are not logged on to their PC with the user NT password that I will create for the cube. So how do I deal with that?

Hope someone can help me with this!

Cheers

 

[gaperry]

datras, reference this article and webcast from Microsoft.

http://support.microsoft.com/default.aspx?scid=kb;en-us;324961&Product=sql2k

I have a similar setup as you described and now have a good solution for this..I can type more on this later if you need it but have to run for now...