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?