cancel
Showing results for 
Search instead for 
Did you mean: 

prompt on the basis of profiles

Former Member
0 Kudos

hi everyone,

There is an issue regarding the prompt

There are two user profiles groups both are of same domain accessing the same report, the issue is, one user profile group wants prompt of a particular object on a report , while on the same report other user profile group doesn't want the prompt for the same object. Other prompts are fine with both the user groups, sho how to resolve this issue ?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Use Row level security in Universe.

Create a restriction, go to "Rows" tab in restriction wizard. In where clause provide the prompt condition.

Assign this restriction to the group for which you want to apply this condition.

So whenever the user uses the report, the condition will be applied automatically applies. For other users it won't.

Try this out. It works!

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

It will possible through user restrictions in the prompts. you can restrict the prompt for a particular user who don't want the Prompt. that will solve the problem.

All the Best,

Madhu...

Former Member
0 Kudos

It sounds like a report ownership issue.

Create two versions of the report, one owned by one team and one owned by the other team. They are both responsible for changes to their own report then.

Former Member
0 Kudos

version cannot be created as the same report is being usd by all users. is there any other work around for it .

Former Member
0 Kudos

If you are in XIr3 than you can have optional prompt. Propmt will be visible but need not to select any value.

Former Member
0 Kudos

optinal prompt is not the solution , as the requirement is that one user group wants that prompt compulsory while other group doesnt want that prompt at all.

Former Member
0 Kudos

Aapply restriction on object on which you have created the @prompt from Tools < Manage security.

For more detail and how to implement Security. Jus go through the below link:

http://www.dataspace.com/Downloads/IA_Final_MD.pdf

Hope this may help you out.