January 9, 2006 at 4:54 pm
I have a cube that has a "corporate" hierarchy dimension. I have explicitly set some cube level security (certain users can only see departments down, certain users can see regions down, and certain users can see the whole corporation).
I have created a report using SQL Reporting Services, and was hoping based on the user, only the appropriate data would be shown based on dimensional level security.
When I set the data connection to prompt for username and password, the dimensional level security works like a charm (after the user enters their Windows username and password). However, I cannot get the dimensional level security working with any other configuration in the data source (specifically "Use Windows Authentication"). I am trying to avoid having to prompt the user when running the report. Does anyone have any idea what is going on? - SQL AS 2000 and SQL Reporting Services 2000.
January 12, 2006 at 8:00 am
This was removed by the editor as SPAM
January 16, 2006 at 6:16 am
Might there be a way to use the global variable userid to create a dynamic query. I haven't done it, just brainstorming a little.
January 16, 2006 at 11:10 am
Thank you for your response. Here is how we finally resolved this issue:
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply