Error: WIS 00002 - Object level security Issue

building reports webintelligence
1

Hi all,
While applying object level security . i am getting the following err-

Some objects are not available to your user profile. You cannot refresh this document. See your Business Objects administrator. (Error: WIS 00002)

If I uncheck the Refresh on Open option under document properties.It shows the restricted Obejct.

Any one know how can i overcome from this problem.

Thanks in Advance

zapsterin (BOB member since 2007-12-27)

2

just a clue.

You need to ask your administrator to grant you access to the restricted objects before you will be able to run the query.

dessa :madagascar: (BOB member since 2004-01-29)

3

True. And the fact that you can see the restricted object when not opening on refresh is because the results are saved with the report. Only when you query the database via the universe with the restriction it will prompt you with an error.

wahey :netherlands: (BOB member since 2007-05-31)

4

Hi,
Thanks for the Reply.
so is their any way by which only the related object is displayed.

Thanks

zapsterin (BOB member since 2007-12-27)

5

hi dessa,

Thanks for the reply.

But Myself only has set the restriction on the object and checking it in report. I dont want user to see the restricted object not even err while he refershing the document.
I want user to see only those object which is relevent to him.

Thanks

zapsterin (BOB member since 2007-12-27)

6

I’m afraid that what you want is not possible (as far as I know). When you’ve created a report with an object that a user is not allowed to see this user will always see an error message when trying to refresh the report. You should either create different reports for different user groups or consider other options such as row-level security.

wahey :netherlands: (BOB member since 2007-05-31)

7

Hi wahey,
Thanks for the reply.

The scenario is like i have a drill on report.which is up to three level say A–>B–>C. so a user ‘X’ say is restricted for the object ‘A’ should not see the object A.for him the hierarchy should start from B–>C.

This is happening in one of my universe where the hierarchy is form the one table only i.e A,B,C all the three Object belong to one table only.

But in another universe where say these three object comming from three diffrent table is not happening.it shows that err message (wis:0002) or it will show the restricted object if i uncheck the option of “refresh on open”.

do you have any idea why it is happening.

Thanks

zapsterin (BOB member since 2007-12-27)

8

No, I’m sorry, I don’t. I would need to know more details. I’d advice you to investigate more closely how the restrictions are set up and in what they differ.

wahey :netherlands: (BOB member since 2007-05-31)