parameter boxes are empty

Hi,

I am have a reporting server which connects to a analysis server which connects to a sql server and a db2 server. I am using windows integrated security all the time except for the DB2 connection. That is a fixed username/password.

Reporting server (RS), analysis server (AS) and sql server are all on the same machine.

I created a local group and added the correct users to it.
I gave that group browse rights on the reports so that works correctly.

I created a role in AS and added that group to that role. Gave all read rights to that role.

I created a login for that group on the SQL server and gave that group db_datareader role.

When I connect as an administrator every reports runs fine.

When the test user connects they can browse the reports but the drop down boxes for the parameters are empty.

What goes wrong ?

With regards,

Constantijn Enders

Hi Constantjin

Im having the same problem...

I'm guessing when you say: <<Give all read rights to that role>>
you mean that you are setting the read rights in the cell data tab
when editing your role's security....

If I am correct, try the following:

Uncheck the Combo boxes on the cell data tab
(The one for 'Enable Read Permissions' and 'Enable Read Contingent Permissions')
and see the effect.
User will now be able to see everything.

It seemes that any attempt to set permissions on the cell data tab causes this
problem.

G

|||

Hi,

Unchecking did solve the problem.

I also removed them from SQL server and it works.

So basically what I had to do to give report users rights was
- create a role in AS
- put users/groups in that role
- give that role read rights on the cubes

and that's it.

Thanks for your quick help

Constantijn Enders