analysis manager sql server2000

dear sir/madam,

i have to create a cube in analysis manager in sql server 2000.as i want to see the data according to my organisation levels.

organisation level:

1.Business unit

2.Team manager

3.Sales manager.

and also i create the three user respectively and assign all user has adminstrator category in user accounts of windows XP.

after create the user and design the manage role to restrict the levels which i have create the dimension.after login which i have to create the user i can see all levels of data.

so pls solution for see data which i have to restrict the dimenssion only..

thanks

kesavanTry this url and read William Pearson's tutorials for answers, some version of them is also in your Analysis Service. Hope this helps.

http://www.databasejournal.com/features/mssql/article.php/10894_1429671_2

Kind regards,
Gift Peddie