Use Excel as UI to OLAP for reports

[Guest]

has anyone configure excel to be used a client ui for Olap SSAS 2000?

I have it working but trying to implement some security. I want to implement
a function to check the username and only return the data based on user
permission.

Has anyone tried this?

I was trying to create a function or parameter query to check the permission
against the dimension that I need return data based on the user name but not
sure if this can be accomplish in excel.

 

[Guest]

Hello thanks; however in using Pivottable I'm not saving the password.

I've setup databass cube roles but not sure if Excel is enforcing the
security. Is there a connection string for SSAS 2000?

 

[Guest]

Not sure how to create a user form to test.

Sam,

I don' t know if this is what you are looking for or not, but see
http://www.connectionstrings.com/ to use SQL strings (via MSQuery). Create a
user form for user name and password or if database is set up with
NTAuthentication, you can leave those items blank (and no need for form).
Permissions s/b already set in database security, you may have to give SQL
query "read" only access, etc.

If you use External Queries/Pivot Table Queries - Warning: if you "save" the
user name and password with the query, passwords are not encrypted!

 

[Guest]

Re: User Forms see http://www.contextures.com/xlUserForm01.html for a very
nice step by step.

Without knowing anything about your system, I think your SAS 2000 may be a
SQL Server based database. If you did not enter a user name and password
when you created your Pivot Table query, then I would guess your "log in" is
set up as NT Authorization. Can you check with your IT dept (the database
administrator) to confirm? If yes, you will not have to worry about
security, IT has already taken that into consideration at the database
connection level. Whoever is log'd in on the computer is what access that
user will have to the SAS 2000 database.

Let me know how it goes! Good Luck!